ERROR 1813 (HY000): Tablespace for table 解法办法

CREATE TABLE `td_m_ability_atomic` (

  `ID` int(11) NOT NULL,

  `ABILITY_ID` int(11) NOT NULL,

  `ATOMIC_ID` int(11) NOT NULL,

  `PRIORITY` int(1) NOT NULL,

  PRIMARY KEY (`ID`)

) ENGINE=innodb DEFAULT CHARSET=utf8;

ERROR 1813 (HY000): Tablespace for table '`osapp`.`td_m_ability_atomic`' exists. Please DISCARD the tablespace before IMPORT.

今天遇到创建该表，报以上错误。

解决办法：

将 td_m_ability_atomic名改一下：

CREATE TABLE `td_m_ability_atomic _bak` (

  `ID` int(11) NOT NULL,

  `ABILITY_ID` int(11) NOT NULL,

  `ATOMIC_ID` int(11) NOT NULL,

  `PRIORITY` int(1) NOT NULL,

  PRIMARY KEY (`ID`)

) ENGINE=innodb DEFAULT CHARSET=utf8;

这样创建成功。

最后:

alter table  td_m_ability_atomic _bak rename  td_m_ability_atomic;