mysql错误:Table XXX is marked as crashed and should be repaired
执行下面语句
repair table 表名;
例如:
repair table terminal_gis;
或
问题解决办法
三种修复方法如下所示:
myisamchk --recover --quick /path/to/tblName
myisamchk --recover /path/to/tblName
myisamchk --safe-recover /path/to/tblName
例如:
D:\mysql6\data\cpc>myisamchk --safe-recover terminal_gis
- recovering (with keycache) MyISAM-table 'terminal_gis'
Data records: 13006
Wrong block with wrong total length starting at 54976
Found block that points outside data file at 127388
Found block that points outside data file at 158620
Found block that points outside data file at 295260
Data records: 13000
第一种是最快的,用来修复最普通的问题;而最后一种是最慢的,用来修复一些其它方法所不能修复的问题。