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 innodb | Jorge Bastos | 30 Mar |