用 myisamchk修复Table is marked as crashed and should be repaired 解决方法
本人在电脑本地装了phpstudy环境装了worpdress,上传网站数据。
却出现了Table is marked as crashed and should be repaired 问题。
通过phpmyadmin修复也解决不了问题。
通过网络查询,找到了用myisamchk修复Table is marked as crashed and should be repaired 解决方法:
举例说明:
数据库名:semwoo
表名:wp_postmata
myisamchk 工具路径:E:\phpStudy\PHPtutorial\MYSQL\bin\myisamchk.exe
(电脑左下角)开始 -> 运行 输入 cmd。
输入:
C:\Users\Administrator>e:
E:\>cd phpStudy\PHPTutorial\MYSQL\bin
E:\phpStudy\PHPTutorial\MYSQL\bin>myisamchk -c -r ..\data\semwoo\wp_postmeta.MYI
(注意如果上面命令不能修复,可以把-r改成-f强制修复)
E:\phpStudy\PHPTutorial\MYSQL\bin>myisamchk -c -f ..\data\semwoo\wp_postmeta.MYI