MySQL Forums
Forum List  »  MyISAM

Re: Unable to recreate table with engine other than MyISAM
Posted by: Rob Kroese
Date: April 15, 2009 10:43AM

I have this same problem. I drop the database, recreate it, and try to create a table called 'Locations', and I get an error 150. There is no FK problem -- there are no keys (or anything else for that matter) in the database. When I set the engine to MyISAM, it works. Not sure if that's because the table used to be MyISAM and it 'remembers', or if there is some phantom FK it's hitting and it doesn't have a problem when I create the table as MyISAM because MyISAM doesn't support FKs.

Anyone have a solution? Maybe a way to clean out all artifacts of the old db?

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Unable to recreate table with engine other than MyISAM
2707
April 15, 2009 10:43AM


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.