Automatically Optimise and Repair all MySQL databases on your server

Quickly and easily check for or optimise and repair any MySQL database corruption with the following commands.

Extended checks on all databases plus auto repair any corrupted

mysqlcheck -u root -p --auto-repair -c -e --all-databases

Extended optimise on databases plus auto repair any corrupted

mysqlcheck -u root -p --auto-repair -o -e --all-databases

note that you’ll need to use an account with authorisation over all databases,  this will normally be your MySQL root user and password

Additional Useful Mysqlcheck Options

The following are some of the key options that you can use along with mysqlcheck.

-A, –all-databases Consider all the databases
-a, –analyze Analyze tables
-1, –all-in-1 Use one query per database with tables listed in a comma separated way
–auto-repair Repair the table automatically it if is corrupted
-c, –check Check table errors
-C, –check-only-changed Check tables that are changed since last check
-g, –check-upgrade Check for version dependent changes in the tables
-B, –databases Check more than one databases
-F, –fast Check tables that are not closed properly
–fix-db-names Fix DB names
–fix-table-names Fix table names
-f, –force Continue even when there is an error
-e, –extended Perform extended check on a table. This will take a long time to execute.
-m, –medium-check Faster than extended check option, but does most checks
-o, –optimize Optimize tables
-q, –quick Faster than medium check option
-r, –repair Fix the table corruption