MySQL error './ivr/t_cdr ' is marked as crashed and should was repaired when doing LOCK TABLES

This should be the case when running a business, MySQL database abnormal interruption caused the table exception, check the MySQL log error is as follows

[Email protected] opt]# tail-n5/var/log/Mysqld.log16082713: in: -[Error]/usr/libexec/mysqld:table'./ivr/t_cdr'  isMarked ascrashed and should be repaired16082713: in: +[Error]/usr/libexec/mysqld:table'./ivr/t_cdr'  isMarked ascrashed and should be repaired16082713: in: +[Error]/usr/libexec/mysqld:table'./ivr/t_cdr'  isMarked ascrashed and should be repaired16082713: +: +[Error]/usr/libexec/mysqld:table'./ivr/t_cdr'  isMarked ascrashed and should be repaired16082713: +: the[Error]/usr/libexec/mysqld:table'./ivr/t_cdr'  isMarked asCrashed and should be repaired

Check the information, use MYISAMCHK to repair the table, switch to the database date directory, execute the following command to repair the table MYI file

cd/var/lib/mysql/-F t_cdr. MYI

From for notes (Wiz)

MySQL error './ivr/t_cdr ' is marked as crashed and should being repaired when doing LOCK TABLES