Check, repair, optimize all databases with one command

June 10, 2013 — 2 Comments

My server had some tables marked as ‘crashed’ in one of the databases.. the server had recently gone down pretty harshly so I wanted to go through and check, repair and optimize all of the tables in every database on the server (there are about 30 databases.. mostly wordpress ones.. some vbulletin.. some xenforo).

I came across this command which seemed to do the trick – you should also notice a little bit of speed-up from the optimization..

Give it a shot and let us know what you think!

2 responses to Check, repair, optimize all databases with one command

  1. Sweetness. I can’t wait to give this a try. We just updated and optimized our databases (wordpress and joomla) a month ago and it took forever doing them one-by-one.

  2. I just tried it and it seems to have worked perfectly so far. I will update my post here if I have any issues. It is very convenient to be able to do it all with one command so thanks for yet another helpful post.

Leave a Reply