Hi All,
I had some innodb table relationships set up, but then I did something (not known) to mess it up. Part of it involved setting the table types to myisam temporarily to not deal with the foreign key constraints as I tweaked the fields.
In the process I renamed a key table. I finally was able to rename it to its original name, but I can't change it back to INNODB because I get this error:
Error on rename of './relatebase/#sql-693_e522' to './relatebase/relatebase_userbase' (errno: 150)
I think I have some corruption in the innodb table but I don't know what to do. Any assistance??
Thanks MUCH in advance,
Sam Fullman
[edit: Well, figured something out that worked. I created a new table from the myisam key table with a different name, 2) retyped the new table as INNODB, 3) changed the name of the old myisam table, 4) changed the name of the new INNODB table back to the original name -- isn't MYSQL FUN -- I would like to know, however, what might have happened -- I depend on mySQL to be reliable :-)]
