If you database has InnoDB tables, you will need to deactivate referential integrity while restoring data. Unfortunately, this can’t be done using the mysqldump utility. To do so, backup your database as you would normally. When done, open the SQL file and add the following statement at the very beginning:
SET FOREIGN_KEY_CHECKS=0;
…and add the following at the end of the file:
SET FOREIGN_KEY_CHECKS=1;
