Check and Repair MySQL Tables Using Mysqlcheck Check a Specific Table in a Database $ mysqlcheck -c database_name table_name -u root -p Check All Tables in a Database $ mysqlcheck -c database_name -u root -p Check All Tables and All Databases All $ mysqlcheck -c -u root -p --all-databases Specific list data_bases $ mysqlcheck -c -u root -p --databases database_name_1 database_name_2 Analyze Tables using Mysqlcheck $ mysqlcheck -a database_name table_name -u root -p Optimize Tables using Mysqlcheck $ mysqlcheck -o database_name table_name -u root -p Repair Tables using Mysqlcheck $ mysqlcheck -r database_name table_name -u root -p Combine Check, Optimize, and Repair Tables All $ mysqlcheck -u root -p --auto-repair -c -o --all-databases Specific database $ mysqlcheck -u root -p --auto-repair -c -o database_name Mode debug $ mysqlcheck --debug-info -u root -p ... Source : http://www.thegeekstuff.com/2011/12/mysqlcheck/
