今天上服务器一看,发现网页错误,无法连接数据库服务器。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。
全部