"This avoids problems with tables having to be reloaded in a particular order when the dump is reloaded. For earlier versions, you can disable the variable manually within mysql when loading the dump file like this:
mysql> SET FOREIGN_KEY_CHECKS = 0;
mysql> SOURCE dump_file_name
mysql> SET FOREIGN_KEY_CHECKS = 1;"
I am having problems dumping a database from one system to another. Not sure if the problem is above, will have to try. It wasn't the above problem.
From this post I learnt that you have to force backticks on table names using:
--quote-names
when doing a mysql_dump. Or else if the name conflicts with key words, the dump will fail to import.
