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 )