If your constantly having headaches dumping data to MySQL and it errors out because of foreign keys, you can do:


SET FOREIGN_KEY_CHECKS=0;


-- dump --


SET FOREIGN_KEY_CHECKS=1;