A5下载 - 努力做内容最丰富最安全的下载站!

A5站长下载站

当前位置:A5下载 > 源码技巧 > discuz > discuz:Table 'xxx' is marked as crashed and last (automatic) repair failed

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

时间:2015-07-08 17:14作者:fang人气:170

今天给一个客户导出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

这样就完成了

标签discuz,Table,xxx,marked,crashe

相关下载

查看所有评论+

网友评论

网友
您的评论需要经过审核才能显示

热门阅览

最新排行

公众号