- If you have the access to mysql thru terminal, then you can use the command below:-
mysql> SET foreign_key_checks = 0;
mysql> SOURCE your_db_dump_file;
mysql> SET foreign_key_checks = 1;
- If you import your database thru web interface like phpmyadmin, then you need to edit the sql dump file. Add this to the 1st line of your sql db dump file:-
SET foreign_key_checks = 0;
- then add this line to the last line in your sql db dump file:-
SET foreign_key_checks = 1;
- Now you may import your sql dump file, and it should have no error by now.