Fast2Host Logo

Databases

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 

 



Maintain peace of mind with 24/7 UK based support

Email any time or call 01480 26 00 00 014 80 26 00 00