Re: Error 1062 while restoring backup

[Peter Warren]

You need to to avoid the primary keys and foreign keys check when restoring, when backing up, you need to add the disable keys statement before dumping a table.

Read more about the disable keys statement on the following page:

http://www.databasethink.com/mysql/backup/help/task-wizard/advanced-settings.php

Please search the string "Surround the INSERT statements with ALTER TABLE table_name DISABLE KEYS" on the page.

You can use a freeware to instead of mysqldump to dump your MySQL databases. It will automatically add the DISABLE KEYS statements in the SQL file:

Free Backup for MySQL

http://www.databasethink.com/mysql/backup-free/