網絡癱瘓上不了網？電腦出故障？找破解軟件？加入創想工作室QQ群，向大神求助，一步解決問題！QQ群號碼：18345199。[點此獲取更多QQ群]
公司一臺服務器，php+mysql搭建的環境放公司網站，今天機房意外重啟后，結果打開后臺報錯，想必你已經知道庫的引擎是myisam 的了，太悲催，太蛋碎了，先看看報錯信息：
mysql> desc v9_member;
ERROR 130 (HY000): Incorrect file format 'v9_member'
mysql> check table v9_member;
+-------------------------+-------+----------+----------------------------------------+
| Table | Op | Msg_type | Msg_text |
+-------------------------+-------+----------+----------------------------------------+
| hivedbwm.v9_member | check | Error | Incorrect file format 'v9_member' |
| hivedbwm.v9_member | check | error | Corrupt |
+-------------------------+-------+----------+----------------------------------------+
2 rows in set (0.00 sec)
執行REPAIR TABLE table_name USE_FRM; 修復：
mysql> REPAIR TABLE v9_member USE_FRM;
+-------------------------+--------+----------+----------+
| Table | Op | Msg_type | Msg_text |
+-------------------------+--------+----------+----------+
| hivedbwm.v9_member | repair | status | OK |
+-------------------------+--------+----------+----------+
1 row in set (0.02 sec)
mysql> desc v9_member;
+--------------+---------------+------+-----+---------+-------+
| 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)
