检查表是否损坏:
.....
check table product_order
修复表:repair table product_order;
如果修复还是不成功的话 如下图:
mysql> repair table product_order;
+------------------------+--------+----------+---------------------------------------+
| Table | Op | Msg_type | Msg_text |
+------------------------+--------+----------+---------------------------------------+
| u_crm_db.product_order | repair | Error | Incorrect file format 'product_order' |
| u_crm_db.product_order | repair | error | Corrupt |
+------------------------+--------+----------+---------------------------------------+
2 rows in set (0.00 sec)
此时使用:repair table product_order use_frm;
转载请注明:谷谷点程序 » Mysql坏表修复的方法