WenRou's Blog

新浪微薄腾讯微薄

最新碎语:测试图片碎语哦

您的位置:WenRou's Blog >lnamp> centos下MYSQL数据表损坏修复Table is marked as crashed and should be repaired

centos下MYSQL数据表损坏修复Table is marked as crashed and should be repaired

centos下php网站数据表损坏,提示:Table './xxx' is marked as crashed and should be repaired

建议停止 mysqld服务后再修复!

用这个命令修复:myisamchk -r -o -f /usr/local/mysql/data/sqlaaa/test_user.MYI

如果提示myisamchk is not found ,用绝对路径,例如:

/usr/local/mysql/bin/myisamchk -r -o -f /usr/local/mysql/data/sqlaaa/test_user.MYI

---

转载请注明本文标题和链接:《centos下MYSQL数据表损坏修复Table is marked as crashed and should be repaired

发表评论

31 + 1 =
路人甲 表情
看不清楚?点图切换 Ctrl+Enter快速提交
 sitemap