首页 > 代码库 > mysql "is marked as crashed and should be repaired"故障

mysql "is marked as crashed and should be repaired"故障

项目遇到这个问题,磁盘满了之后继续操作,导致表的索引错误。

phpmyadmin有修复按钮,但是项目用的是windows环境下的mysql front软件。网上关于这个故障的修复回答,在实际操作中还是有点偏差,所以把过程记录下来。

找到myisamchk.exe路径(C:\mysql5.6\MySQL Server 5.6\bin)之后,直接运行“myisamchk -c -r 路径”,例:

C:\mysql5.6\MySQL Server 5.6\bin>myisamchk -c -r D:\database\mysql5.6\data\dbname\tablename

网上有答案说运行myisamchk -c -r D:\database\mysql5.6\data\dbname\tablename.MYI

结果报了 is not a MyISAM-table的错...

修复情况如下:

Data records: 163763
- Fixing index 1
Found link that points at 18337776 (outside data file) at 8461788
- Fixing index 2
Data records: 163762

本文出自 “飞天马铃薯神教” 博客,请务必保留此出处http://1105190775.blog.51cto.com/10048144/1880287

mysql "is marked as crashed and should be repaired"故障