List:MySQL on Win32« Previous MessageNext Message »
From:Jorge Bastos Date:March 30 2006 7:12pm
Subject:Problem with innodb
View as plain text  
People, anyone had this problem descrived below?
http://dev.mysql.com/doc/refman/5.0/en/innodb-troubleshooting-datadict.html

InnoDB: Error: table test/parent already exists in InnoDB internal
InnoDB: data dictionary. Have you deleted the .frm file
InnoDB: and not used DROP TABLE? Have you used DROP DATABASE
InnoDB: for InnoDB tables in MySQL version <= 3.23.43?
InnoDB: See the Restrictions section of the InnoDB manual.
InnoDB: You can drop the orphaned table inside InnoDB by
InnoDB: creating an InnoDB table with the same name in another
InnoDB: database and moving the .frm file to the current database.
InnoDB: Then MySQL thinks the table exists, and DROP TABLE will
InnoDB: succeed.


I can't create tables with engine=innodb


Jorge
Thread
Problem with innodbJorge Bastos30 Mar