Mysql innodb表信息损坏一例

Mysql innodb表信息损坏一例

111104 15:09:43 [ERROR] Cannot find or open table enterprise/user_trasactions from
the internal data dictionary of InnoDB though the .frm file for the
table exists. Maybe you have deleted and recreated InnoDB data
files but have forgotten to delete the corresponding .frm files
of InnoDB tables, or you have moved .frm files to another database?
or, the table contains indexes that this version of the engine
doesn't support.
See http://dev.mysql.com/doc/refman/5.1/en/innodb-troubleshooting.html
how you can resolve the problem.
http://dev.mysql.com/doc/refman/5.1/en/innodb-troubleshooting-datadict.html

--1 查是否支持该engine--
show engines;

--2 建立inndb engine的新表--

--3 drop表 并重建 --

--4 原因--
 DDL不正常退出,造成数据字典与数据文件不一致

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/13794466/viewspace-711821/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/13794466/viewspace-711821/