Home > Database > Mysql Tutorial > body text

fail1Table “.xxxxxx” is marked as crashed and should b

WBOY
Release: 2016-06-07 17:51:28
Original
1244 people have browsed it

今天由于服务器自动关机了,我再打开网站时出现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

注明:本站原创文章转载必须注明来源

source:php.cn
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template
About us Disclaimer Sitemap
php.cn:Public welfare online PHP training,Help PHP learners grow quickly!