MySQL error incorrect file format solution

A MySQL server, the machine unexpectedly restarts, n tables error, presumably you already know that the library engine is MyISAM, too sad, too broken, the first look at the error message:

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)

Execute repair TABLE table_name use_frm; FIX:

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 (    | NO  )  | pri | null    |       | |  pkey_comment | varchar (4000)  | YES  |     |  null    |       | |  pkey_name    | varchar (+)   | no   | pri  | null    |       | |  pkey_type    | varchar (767)   | NO   |      | null    |       | |  integer_idx  | int (one)        | no   |     | null    |        |+--------------+---------------+------+-----+---------+-------+5 rows in set   (0.02 SEC)

This article is from the "Dick Silk ops Man" blog, please be sure to keep this source http://navyaijm.blog.51cto.com/4647068/1574048

MySQL error incorrect file format solution