当mysql表被损坏,提示如下错误
Table ‘./xxxxx’ is marked as crashed and should be repaired when using LOCK TABLES
修复方法
#cd /var/lib/mysql/freeiris2/
#myisamchk -c -r cdr.MYI
输出:
– recovering (with sort) MyISAM-table ‘cdr.MYI’
Data records: 375646
– Fixing index 1
– Fixing index 2
– Fixing index 3
– Fixing index 4
– Fixing index 5
– Fixing index 6
– Fixing index 7
– Fixing index 8
– Fixing index 9
Data records: 375644