Difference between revisions of "How to recover corrupted MySQL data"
From Kolmisoft Wiki
Jump to navigationJump to search
| Line 7: | Line 7: | ||
Example how it looks in the /var/log/mysql.log: | Example how it looks in the /var/log/mysql.log: | ||
[[File:mysql_crashing_log.png| | [[File:mysql_crashing_log.png|400px]] | ||
| Line 20: | Line 20: | ||
After that log should show that recovery mode is turned on: | After that log should show that recovery mode is turned on: | ||
[[File:mysql_recovery_on_log.png | [[File:mysql_recovery_on_log.png]] | ||
Revision as of 18:36, 13 May 2011
Sometimes MySQL data gets corrupted.
It often happens when HDD space runs out.
After that when MySQL process is started, it keeps crashing.
Example how it looks in the /var/log/mysql.log:
Solution to this is into file /etc/my.cnf enter such line:
innodb_force_recovery = 4
and restart MySQL process:
/etc/init.d/mysql restart
After that log should show that recovery mode is turned on:
