Wednesday, August 24, 2005

MySQL: FOREIGN KEY Constraints:
"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.