WHM currently only allows you to check, repair and optimize each database one at a time, but that’s time consuming and boring! Here’s a quick way to check, repair and optimize all the databases right from the Terminal! It may be a good idea to pipe these commands to a file for reviewing, and definitely a good idea to back them all up before executing the repair and optimize functions. We’ve never had an issue running these commands, but YMMV… Just take a backup.

Check the databases for errors with this one.

mysqlcheck --all-databases -a

Repair the databases for errors with this one.

mysqlcheck --all-databases -r

and finally, Optimize all those databases with this one…

mysqlcheck --all-databases -o #optimize

Good luck! Have funs and watch out for snakes!

Brian Singer

Principal
With over 20 years of website development experience, Brian brings a wealth of knowledge around data processing, website hosting, high-level marketing strategy, SEO, and more. Brian is a graduate from the McDonogh School, holds a B.F.A. in Imaging Arts and Sciences from Rochester Institute of Technology and serves on the board of several non-profits.

Comments

Leave a Reply

Your email address will not be published.

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Brian Singer

Principal
With over 20 years of website development experience, Brian brings a wealth of knowledge around data processing, website hosting, high-level marketing strategy, SEO, and more. Brian is a graduate from the McDonogh School, holds a B.F.A. in Imaging Arts and Sciences from Rochester Institute of Technology and serves on the board of several non-profits.

Post Details

Categories: