PLEASE NOTE: I am currently reviewing and extending this document.
While caring for a remarkable amount of MySQL server instances, troubleshooting becomes a common task. It might of interest for you which
Recovering a crashed MySQL server
After a server crash (meaning the system itself or just the MySQL daemon) corrupted table files are quite common. You’ll see this when checking the /var/log/syslog, as the MySQL daemon checks tables during its startup.
Apr 17 13:54:44 live1 mysqld: 090417 13:54:44 [ERROR] /usr/sbin/mysqld: Table './database1/table1' is marked as crashed and should be repaired
The MySQL daemon just told you that it found a broken[Read more...]