mysql错误表_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