How to repair all MySQL databases on a server in one go

April 22nd, 2009 Categories: Hot Tips, cPanel

Here’s a quick & ditry trick to repair all MySQL databases on a server, in one go.

Run the following commands on your server, in the console as root.


mysqlcheck –all-databases -r #repair
mysqlcheck –all-databases -a #analyze
mysqlcheck –all-databases -o #optimize

Share and Enjoy:
  • Digg
  • Sphinn
  • del.icio.us
  • Facebook
  • Mixx
  • Google Bookmarks
  • De.lirio.us
  • email
  • Furl
  • laaik.it
  • LinkedIn
  • MySpace
  • Slashdot
  • StumbleUpon
  • Technorati
  • YahooMyWeb
  • Print
  • TwitThis
Tags: , , , , ,
No comments yet.
You must be logged in to post a comment.