Use mysqlcheck to Optimize and Repair MySQL Databases on Linux

Here are three quick commands that are useful to check, optimize, and also repair your mysql databases!

1. Check Databases

    $ mysqlcheck -cA -u root -p

       (-c for check database, -A for all databases)

2. Optimize Databases

    $ mysqlcheck -oA -u root -p

       (-o for optimize)

3. Repair Corrupted Databases

    $ mysqlcheck -rA -u root -p

       (-r for repair)