mysql 1005 - can't create table_创建表时报错ERROR 1005 (HY000): Can't create table'' (errno: -1)...

错误信息：

InnoDB: Warning: trying to init to the tablespace memory cache

InnoDB: a tablespace 15385 of name './PIXOS_DB/TB_COMPANY.ibd',

InnoDB: but a tablespace 15383 of the same name

InnoDB: already exists in the tablespace memory cache!

InnoDB: We assume that InnoDB did a crash recovery, and you had

InnoDB: an .ibd file for which the table did not exist in the

InnoDB: InnoDB internal data dictionary in the ibdata files.

InnoDB: We assume that you later removed the .ibd and .frm files,

InnoDB: and are now trying to recreate the table. We now remove the

InnoDB: conflicting tablespace object from the memory cache and try

InnoDB: the init again.

120830 13:55:25  InnoDB: Error: table `PIXOS_DB`.`TB_COMPANY` 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 copying the .frm file to the current database.

InnoDB: Then MySQL thinks the table exists, and DROP TABLE will

InnoDB: succeed.

InnoDB: You can look for further help from

InnoDB: http://dev.mysql.com/doc/refman/ ... roubleshooting.html