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.

Mozilla and hypocrisy

Right, but what about the experiences that Mozilla chooses to default for users like switching to  Yahoo and making that the default upon ...