Browse > Home / Webmaster Tutorials / Check, Repair and Optimize ALL Databases with 1 command!

| Subcribe via RSS

Check, Repair and Optimize ALL Databases with 1 command!

May 30th, 2009 Posted in Webmaster Tutorials

Most webmasters can have the problem that some tables aren’t optimized or have overhead. This will cauze your server/VPS to work slower than usual since it can’t use all it’s resources. If you do this command once a week then you should be fine and your databases would stay optimized all the time. Follow the steps below:

1. Login into shell via SSH
2. Do this command (you can change the username if it isn’t ‘root’):

mysqlcheck -u root -p –auto-repair –check –optimize –all-databases

3. Enter the password
4. Sit back and enjoy with getting your databases fixed with a single command =)

No related posts.

Related posts brought to you by Yet Another Related Posts Plugin.

Tags: , ,
This entry was posted on Saturday, May 30th, 2009 at 10:52 AM and is filed under Webmaster Tutorials. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

2 Responses to “Check, Repair and Optimize ALL Databases with 1 command!”

  1. GarykPatton Says:

    June 16th, 2009 at 3:55 AM

    How soon will you update your blog? I’m interested in reading some more information on this issue.


  2. b0rce Says:

    June 16th, 2009 at 10:36 AM

    It’s randomly updated, but we will post one news MINIMUM in one week. However, you can register or follow us via RSS.


Leave a Reply

You must be logged in to post a comment.