MySQL Forums
Forum List  »  InnoDB

Re: ERROR 1005: Can't create table (errno: 121) Help
Posted by: Bernie Glynn
Date: April 28, 2009 01:06AM

Steven,

Change the Foreign key to name to something new. I was using a GUI that presented me with a default foreign key number <foreign_key01>.

After reading a few of these forums I decided to change it to <foreign_key11>...

Bingo!

Make sure all FKs are unique, and start with one that may not have been used before. There are some replies about the INNODB...??? We'll I'm a noob and don't know what that is, but this FK numbering system worked for me and allowed me to add the new FKs.

Good luck!
Bernie

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: ERROR 1005: Can't create table (errno: 121) Help
7692
April 28, 2009 01:06AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.