一台mysql 服务器，机器意外重启后，N个表报错，想必你已经知道库的引擎是myisam 的了，太悲催，太蛋碎了，先看看报错信息：
mysql> desc PARTITION_KEYS;
ERROR 130 (HY000): Incorrect file format 'PARTITION_KEYS'
mysql> check table PARTITION_KEYS;
+-------------------------+-------+----------+----------------------------------------+
| Table | Op | Msg_type | Msg_text |
+-------------------------+-------+----------+----------------------------------------+
| hivedbwm.PARTITION_KEYS | check | Error | Incorrect file format 'PARTITION_KEYS' |
| hivedbwm.PARTITION_KEYS | check | error | Corrupt |
+-------------------------+-------+----------+----------------------------------------+
2 rows in set (0.00 sec)
执行REPAIR TABLE table_name USE_FRM; 修复：
mysql> REPAIR TABLE PARTITION_KEYS USE_FRM;
+-------------------------+--------+----------+----------+
| Table | Op | Msg_type | Msg_text |
+-------------------------+--------+----------+----------+
| hivedbwm.PARTITION_KEYS | repair | status | OK |
+-------------------------+--------+----------+----------+
1 row in set (0.02 sec)
mysql> desc PARTITION_KEYS;
+--------------+---------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+--------------+---------------+------+-----+---------+-------+
| TBL_ID | bigint(20) | NO | PRI | NULL | |
| PKEY_COMMENT | varchar(4000) | YES | | NULL | |
| PKEY_NAME | varchar(128) | NO | PRI | NULL | |
| PKEY_TYPE | varchar(767) | NO | | NULL | |
| INTEGER_IDX | int(11) | NO | | NULL | |
+--------------+---------------+------+-----+---------+-------+
5 rows in set (0.02 sec)
©著作权归作者所有：来自51CTO博客作者navyaijm2012的原创作品，如需转载，请注明出处，否则将追究法律责任
mysql表损坏索引损坏数据库
随时随地看视频
