2015년 9월 17일 목요일

MyISAM index corrupt error

What problems??


When you use MyISAM table, you may see error :
[ERROR] /db/mysql/bin/mysqld: Incorrect key file for table './dbstat/global_status.MYI'; try to repair it

What for ?


When MyISAM index file is corrupted, You can see errors.

What Can I do for fixing problems?


mysql> repair table [tablenm]

when you execute "repair table xxx", You may lost some data.


댓글 없음:

댓글 쓰기