MySQL Foriegn Key create ERROR: MySQL Error Number 1005

Have you ever come across this error?

MySQL Error Number 1005
ERROR 1005 (HY000): Can’t create table ‘./wordpress/#sql-2693_f74e.frm’ (errno: 150)

Jason summarized very good article to track down error reported on his blog.

It helped me , hopefully these tricks will help you as well!!

Post in comment , if it helps to save your day!!

2 thoughts on “MySQL Foriegn Key create ERROR: MySQL Error Number 1005”

Sheeri K. Cabral on December 15, 2011 at 4:46 pm said:

You can find all that information on the MySQL manual page: http://dev.mysql.com/doc/refman/5.5/en/innodb-foreign-key-constraints.html

Reply ↓
Denish Patel on December 15, 2011 at 5:13 pm said:

Sheeri,Thanks for pointing that out. The problem is ERROR is misleading and it takes long time to reach to that page instead you reach to ERROR page and you will be misguided. I think MySQL ERROR doc should link http://dev.mysql.com/doc/refman/5.5/en/innodb-foreign-key-constraints.html .

Reply ↓