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: