mysqlcheck -u root -p --auto-repair --check --optimize --all-databases
http://blog.taragana.com/index.php/archive/mysql-tip-how-to-check-repair-optimize-all-tables-in-all-databases/