ERROR 1005: Can't create table './db/table.frm' (errno: 150)

Hello, I found the key to solve this problem in: http://darkstar.ist.utl.pt/mysql/doc/en/InnoDB_foreign_key_constraints.html You'll probably need an INDEX for that new foreign key you are declaring in older versions this isn't neccesary but in latest ones it is a restriction. You can have more i

Re: ERROR 1005: Can't create table './db/table.frm' (errno: 150)

Hello, I found the key to solve this problem in: http://darkstar.ist.utl.pt/mysql/doc/en/InnoDB_foreign_key_constraints.html You'll probably need an INDEX for that new foreign key you are declaring in older versions this isn't neccesary but in latest ones it is a restriction. You can have more i

Re: ERROR 1005: Can't create table './db/table.frm' (errno: 150)

foreign_key_checks=0? Best regards, Heikki Innobase Oy http://www.innodb.com InnoDB - transactions, foreign keys, and a hot backup tool for MySQL Order MySQL support from http://www.mysql.com/support/index.html . Subject: ERROR 1005: Can't create table './db/table.frm' (e

ERROR 1005: Can't create table './db/table.frm' (errno: 150)

Dear MySQL: I am getting the error 'ERROR 1005: Can't create table './db/table.frm' (errno: 150)' using InnoDB tables on 4.0.13-max-log. This is nothing to do with referential checking. The command: SET foreign_key_checks=0 Does alow the import of referential tables,