[prev in list] [next in list] [prev in thread] [next in thread] 

List:       mysql-win32
Subject:    Problem with innodb
From:       "Jorge Bastos" <mysql.jorge () decimal ! pt>
Date:       2006-03-30 19:12:34
Message-ID: 008801c6542d$e6dad380$0101a8c0 () pcjorge
[Download RAW message or body]


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

[prev in list] [next in list] [prev in thread] [next in thread]