2 messages in com.mysql.lists.plusplusRe: C++ query to backup table from da...
FromSent OnAttachments
Arlis Rose30 Jun 2005 11:09 
Warren Young30 Jun 2005 15:13 
Subject:Re: C++ query to backup table from database
From:Warren Young (mysq@etr-usa.com)
Date:06/30/2005 03:13:20 PM
List:com.mysql.lists.plusplus

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.