Wednesday, December 26, 2012

mysql - error 1005 (hy000) at line ... can't create table

Creating the database:
 
$ mysql -uroot -pmysql < my_tester_createdb_2.sql

Returns:
ERROR 1005 (HY000) at line 202: Can't create table './tester/#sql-d2d_146.frm' (errno: 150)


Solution

Search for a foreign key reference mistake like:

 - incompatible types
 - unsigned (when it shouldn't )







No comments:

Post a Comment