mysql表错误记录

普通修复

mysql> repair table cab_data;
+---------------------+--------+----------+------------------------------------------------------------------------+
| Table               | Op     | Msg_type | Msg_text                                                               |
+---------------------+--------+----------+------------------------------------------------------------------------+
| http_cache.cab_data | repair | error    | Incorrect key file for table './http/cab_data'; try to repair it | 
+---------------------+--------+----------+------------------------------------------------------------------------+
1 row in set, 2 warnings (0.00 sec)

用mysqlcheck修复

mysqlcheck -ro http

http_cab_url                                  OK
http_cab_data                                OK

本文转自it你好 51CTO博客，原文链接：http://blog.51cto.com/itnihao/836498，如需转载请自行联系原作者