Check MySQL Database for Errors and Repair

Gary Kuhlmann - February 23, 2014

When checking the mysql server logs (located at /var/log/mysqld.log) I started seeing errors ending in:

...is marked as crashed and should be repaired.

You can use (run from server cli):

mysqlcheck [database name]

to check all of the tables. If one is identified as being in an error state you can repair it using (run from within mysql or mysql workbench):

repair table `[database name]`.`[table name]`