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

Tagged with:  
Page 1 of 11