Add this to the beginning of dump SET AUTOCOMMIT = 0; SET FOREIGN_KEY_CHECKS=0; and this to the end SET FOREIGN_KEY_CHECKS = 1; COMMIT; SET AUTOCOMMIT = 1;
Read more