MYSQL – Check, Repair and Optimize All Tables in All Databases « ByREV

Linux command to auto repair, check & optimize all the tables in all databases from mysql server: (v3.23.38 and later)

mysqlcheck -u {user} -p{passwd} --auto-repair --check --optimize --all-databases

or the shorter version

mysqlcheck -u {user} -p{passwd} -Aor

where:

• {user} – user full access to the database ( can be root )
• {passwd} – password for {user} acount

mysqlcheck can not repair read-only tables.