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.
[ Short URL ... ]