MySQL Forums
Forum List  »  MySQL Administrator

Re: Foreign key constraints with Administrator or Query Browser on MacOS X
Posted by: Barry Galbraith
Date: August 22, 2009 06:43PM


I don't know the exact answer, but does the MocOS use a case sensitive character set?

You quote "ALTER TABLE `Animal_Party`.`habitat` "

and the error says
"Can't create table 'animal_party.#sql-89_8' (errno: 121) (1005)"

Notice the case difference?

On Windows that I use, case is not important. Everything is converted to lower case unless it's quoted.

When you create a table, there is a file of the same name as the table created to hold the structure, even if the data is in an InnoDB file.

Try with case the same as the error message and see what happens.

Good luck.

Options: ReplyQuote

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.