Today I faced with a issue of table corruption in MYSQL
Investigating the cause, this is what is indicated in the mysql site
if any of the following events occur:
- The mysqld process is killed in the middle of a write.
- An unexpected computer shutdown occurs (for example, the computer is turned off).
- Hardware failures.
- You are using an external program (such as myisamchk) to modify a table that is being modified by the server at the same time.
- A software bug in the MySQL or MyISAM code.
Analyze table gave the result
Found 1213886 keys of 1213885
and table corrupt
Fortunately the error was rectified easily by the repair tables command
Good to know, you had easily repair mysql database but sometimes the corruption in the mysql database table creates a big trouble for somebody. My friend has also suffer with the corrupt table. He has used a third party mysql recovery application to fix the issue from here http://tiny.cc/vrd1i
ReplyDelete