首页 > 代码库 > MySQL错误Incorrect file format解决方案
MySQL错误Incorrect file format解决方案
一台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)
本文出自 “屌丝运维男” 博客,请务必保留此出处http://navyaijm.blog.51cto.com/4647068/1574048
MySQL错误Incorrect file format解决方案
声明:以上内容来自用户投稿及互联网公开渠道收集整理发布,本网站不拥有所有权,未作人工编辑处理,也不承担相关法律责任,若内容有误或涉及侵权可进行投诉: 投诉/举报 工作人员会在5个工作日内联系你,一经查实,本站将立刻删除涉嫌侵权内容。