Re: Backup mysqldump

[Kai Voigt]

The reason for the error is that you got a table "admin" in your backup that already exists in your running database. There're only two solutions to handle it. Either drop your existing "admin" table and apply the commands from mysql.dbs again, or open mysql.dbs in a text editor and remove the commands related to the "admin" table.

If you want existing tables automatically deleted when applying a backup file, use the --add-drop-table option when running mysqldump. This will include commands to drop an existing table when the data is being restored.

--
Kai Voigt, Senior Instructor, MySQL AB
[e-mail], www.mysql.com
Office: Kiel, Germany