MySQL Command Line to Check, Auto Repair and Optimize All Tables in All Databases

This is a handy command line that will check, auto repair and optimize all tables in all MySQL databases.

mysqlcheck -u root -p –check –auto-repair –optimize –all-databases