fail1Table “.xxxxxx” is marked as crashed and should b
程序员文章站
2022-05-30 21:58:12
...
今天由于服务器自动关机了,我再打开网站时出现fail1Table “.\\xxx\\xxx” is marked as crashed and should be repaired操作,经过冷静分析这是表的问题我后来在网上找到了两个办法,有需要的同学可以参考一下。
解决方法一
我自己安装了myadmin这样就带一个修改功能,找到你出问题的,你进去看到一般是提示“正在使用中”那么这个表就出问题了,我利用phpmysqdmin修复功能就可以搞定如下图红色框
修改成功提示
这样就代表你修复成功了,快看看表是不是好了哦
解决方法二
到的安装目录的bin/myisamchk工具,
在命令行中输入:
代码如下 | 复制代码 |
myisamchk -c -r ../data/dedecmsv4/dede_archives.MYI |
然后myisamchk 工具会帮助你恢复数据表的索引。
不需要重启mysql
注明:本站原创文章转载必须注明来源
推荐阅读
-
Table ‘xxx’ is marked as crashed and should be repaired 错误解决方法参考
-
Table ‘xxx’ is marked as crashed and should be repaired 错误解决方法参考
-
MySql is marked as crashed and should be repaired问题
-
mysql错误:……is marked as crashed and should be_MySQL
-
Table'./mysql/user'is marked as crashed and should be repa_MySQL
-
MYSQL is marked as crashed and should be repaired解决办法
-
mysql错误:Table XXX is marked as crashed and should be repai
-
速解决MySQL “is marked as crashed and should be repaired”故障
-
数据库崩溃-mysql数据库常常出现 table XXX is marked crashed and should be repaired
-
fail1Table “.xxxxxx” is marked as crashed and should b