mysql 错误代码1194解决方法

今天上服务器一看，发现网页错误，无法连接数据库服务器。mysql服务自己down掉了，然后重新启动服务器，发现网页无法打开，提示： 

[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