From: Warren Young
Date: June 30 2005 10:13pm
Subject: Re: C++ query to backup table from database
List-Archive: http://lists.mysql.com/plusplus/4581
Message-Id: <42C46E96.5050800@etr-usa.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit

Arlis Rose wrote:

> First: what query could I pass that would create a backup of the database

Why reinvent the wheel?  The mysqldump command was created for this very 
purpose.  Just execute it in the background.

> Second: (this one I think I know already but don't hurt to ask :) to then
> delete all entries from that database
> (I'd assume it would just be:
> querry.Format("DELETE * From receivedemail");

That could work, but it's probably much more efficient to drop and 
re-create the database/table.

It doesn't seem that you're using MySQL++, by the way, which is the 
purpose of this list.  For general MySQL usage questions, including use 
of the C API, use the main MySQL mailing list.  For other APIs, I'm sure 
they have their own mailing lists.