How to Fix MySQL Database (MyISAM / InnoDB)

This is a great MySQL 101! Recently I got several problems with a few MySQL databases because the server wasn’t able to write to the SAN storage. I found this page and the command ” /usr/local/mysql/bin/mysqlcheck –all-databases -uUSERNAME -pPASSWORD -r” fixed all the corrupt tables. Sure it took some time to check/repair all the tables, but the work need to be done. One hint, before you start repairing, you should search for the location of the MySQL binaries (use “locate mysqlcheck” for example) otherwise it will not work. You need to have MySQL ROOT access for many functions mentioned on this page.

Source…

Related Posts

• Optimize your MySQL Server with MySQLTuner

  Login to your server’s console and download MySQLTuner (I use my user’s home directory) wget [...]