机器重启后莫名其妙的原因:
ERROR 130 (HY000): Incorrect file format 'dev_list'
以下是解决办法,用REPAIR命令修复OK,具体引起的原因在查。
mysql> desc dev_list; ERROR 130 (HY000): Incorrect file format 'dev_list' mysql> check table dev_list; +-------------------------+-------+----------+----------------------------------------+ | Table | Op | Msg_type | Msg_text | +-------------------------+-------+----------+----------------------------------------+ | dev_list| check | Error | Incorrect file format 'dev_list' | | dev_list| check | error | Corrupt | +-------------------------+-------+----------+----------------------------------------+ 2 rows in set (0.00 sec)
执行REPAIR TABLE table_name USE_FRM; 修复:
mysql> REPAIR TABLE dev_list USE_FRM; +-------------------------+--------+----------+----------+ | Table | Op | Msg_type | Msg_text | +-------------------------+--------+----------+----------+ | dev_list| repair | status | OK | +-------------------------+--------+----------+----------+ 1 row in set (0.02 sec) mysql> desc dev_list; +--------------+---------------+------+-----+---------+-------+ | 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)