mysql 1194 错误表格已损坏，需要修复

dly · 发表于 2011-4-25 21:39:43

[mysql]Table tblName is marked as crashed and should be repaired
Mysql提示tblName表格已损坏，需要修复，解决方法：
[root@mysqlserver ~]#more /var/log/mysqld.log
090718 11:22:07 [ERROR] /usr/libexec/mysqld: Table 'ware' is marked as crashed and should be repaired
090718 11:22:07 [ERROR] /usr/libexec/mysqld: Sort aborted
090718 11:23:42 [ERROR] /usr/libexec/mysqld: Table 'ware' is marked as crashed and should be repaired
090718 11:23:42 [ERROR] /usr/libexec/mysqld: Sort aborted
090718 11:24:01 [ERROR] /usr/libexec/mysqld: Table 'ware' is marked as crashed and should be repaired
090718 11:24:01 [ERROR] /usr/libexec/mysqld: Sort aborted
090718 11:25:19 [ERROR] /usr/libexec/mysqld: Table 'ware' is marked as crashed and should be repaired
090718 11:25:19 [ERROR] /usr/libexec/mysqld: Sort aborted

进入到对应的数据库目录：
[root@mysqlserver ~]# cd /var/lib/mysql/dbname

使用myisamchk修复：

[root@mysqlserver mysql]# myisamchk -r tblName

mysql 1194 错误 表格已损坏，需要修复

mysql 1194 错误表格已损坏，需要修复