A5下载文章资讯

分类分类

discuz:Table 'xxx' is marked as crashed and last (automatic) repair failed

2015-07-08 17:14作者:fang

今天给一个客户导出sql备份,出现下面的错误Table 'phpcms_article' is marked as crashed and last (automatic) repair failed when using LOCK TABLES 。我尝试去phpmyadmin修复,还是不行。只能用命令在服务器修复:
1

service mysqld stop

先停止mysql服务;

2

cd /var/local/mysql/数据名

切换到该表目录下(注意:不切换过来会总提示myisamchk一些错误导致失败);

3

myisamchk -r xxx.MYI

(如果还是提示错误,就多加一个参数-f 强制进行。 myisamchk -r -f xxx.MYI )

discuz:Table xxx is marked as crashed and last (automatic) repair failed

这样就完成了

展开全部

相关

说两句网友评论
    我要跟贴
    取消