MySQL dump import -> Error 1217
Contributed by dionak 
Tagged: MySQL When using innodb tables and foreign key constraints, importing a mysqldump can sometimes generate foreign key errors.
Add to the beginning of the dump file: SET FOREIGN_KEY_CHECKS=0;
Add to the end of the dump file: SET FOREIGN_KEY_CHECKS=1;
This disables foreign key checks for the mysqldump import session only, allowing the data to be imported without the error being generated.
You may also like -
Microsoft SQL Server: How to Find the Foreign Keys in a Database
Drop or delete a table in MySQL
XP and Vista: Backup or Restore the Registry
iPhone/iPod Touch: Two Caps Lock Methods
IE9: Disable Internet Options
How do I import emails from other services into Gmail?
Create a basic MySQL tableImport CSV file directly into MySQL