Backup database structure only.

Jun 29, 2012 at 7:27 AM
Edited Jun 29, 2012 at 7:27 AM

Hi, thanks for the project, it's a big help.

Are there plans for the option of generating the database structure only? 

Coordinator
Jun 29, 2012 at 2:36 PM

Hi, you can try use these codes with MySqlBackup.DLL (V1.2)

private void Backup()
{
    string sqlDumpFile = "C:\\backup.sql";
    string con = "server=localhost;user=root;pwd=1234;database=member;";
    MySqlBackup mb = new MySqlBackup(con);
    mb.ExportRowsData = false;
    mb.Export(sqlDumpFile);
}

By executing this, your backup will not contains any rows. only tables structure.

But, the auto-increment is not reset. Perhaps, a Reset Auto-Increment to 1 should be available in the next version.