Table 'xxx' is marked as crashed and should be repaired

mysql 프롬프트 및 사용하시는 툴의 sql명령문으로,

mysql> analyze table [targetTable];

를 실행하셔서 테이블에 대한 보고서가 작성되며,

mysql> repair table [targetTable];

를 실행하셔서 복원합니다.

shell> perror 126 127 132 134 135 136 141 144 145
MySQL error code 126 = Index file is crashed
MySQL error code 127 = Record-file is crashed
MySQL error code 132 = Old database file
MySQL error code 134 = Record was already deleted (or record file crashed)
MySQL error code 135 = No more room in record file
MySQL error code 136 = No more room in index file
MySQL error code 141 = Duplicate unique key or constraint on write or update
MySQL error code 144 = Table is crashed and last repair failed
MySQL error code 145 = Table was marked as crashed and should be repaired

참고링크 : http://dev.mysql.com/doc/refman/5.0/en/repair.html