MySQL errno: 150

If you’re trying to import an sql file and you get this error :

ERROR 1005 (HY000): Can't create table 'Table.frm' (errno: 150)

then add these commands at the top and bottom of the sql file:

Top of dump file:

SET FOREIGN_KEY_CHECKS = 0; -- TOP 

Bottom of dump file add:

SET FOREIGN_KEY_CHECKS = 1; -- BOTTOM