Foreign Key Constraints

http://dev.mysql.com/doc/refman/5.0/en/innodb-foreign-key-constraints.html

mysql> SET foreign_key_checks = 0;
mysql> SOURCE dump_file_name;
mysql> SET foreign_key_checks = 1;