Optimize and Repair MYSQL Database on OS X
Example query:
mysqlcheck -u username -p –all-databases –repair –analyze –optimize
If you dont have MYSQL alias set up you may need to type:
/usr/local/mysql/bin/mysqlcheck -u username -p –all-databases –repair –analyze –optimize
If you want to put this on a cron job you might need to include your password in the string like:
-p(password) <— no brackets or spaces
like:
mysqlcheck -u username -ppassword –all-databases –repair –analyze –optimize