Get Latest Computer Tips and Tricks by Email for Free

Top Tip! Click Here to Scan for System Errors and Optimize PC Performance
Home » Tutorials

How to repair MySQL Tables

4 February 2008 19 Comments

Sometimes it is possible that your Wordpress database can become overburdened in the process of fetching so much requests and because of it, it will create overhead. As time progresses, overhead values of some tables can become very high and it might cause the database to crash, like what happened to me recently. It is similar to the concept of defragmentation in windows. To keep your database healthy and free of any overheads, just follow the steps shown below

1) Open phpMyAdmin client and select your wordpress database and click on its name

2) You will now see all the tables of the database as shown below.

1

3) Select the checkbox of each table which have an overhead value

4) Go to the drop down menu “with selected” and select repair table


2

 5) An sql query will now be executed and if everything works fine, you will see a screen similar to the one shown below.

repaired   

This way all the overhead value will be cleared. If the overhead values is under a kilobyte, it isn’t much of a problem but sometimes the overhead value can become very large. So it is better to perform these steps once every few days so as to keep your database healthy.

Popularity: 5% [?]

Related Posts

  • Feb 08 stats
  • Repair Your Internet Connection with XP TCP/IP Repair
  • Wordpress Plugin : WP-Table
  • Repair and Tweak Internet Explorer with Repair IE
  • Site Problems
  • 19 Comments »

    • Ashish Mohta said:

      Great it worked for you. I had seen this isssue at some more places. This post will be a great help to them

    • Binny V A said:

      How much was your overhead when your database got corrupted?

    • Madhur Kapoor said:

      @Binny
      around 3 MB

    • Garry Conn said:

      Very cool post Madhur… I can’t begin to tell you how helpful this will be for many WordPress bloggers.

    • SauceTheGame said:

      Interesting Madhur, You wont have to worry about this unless you receive a large influx of traffic over a short period of time though right.

    • Nirmal said:

      Good to see that everything is back to normal for you. Nice tutorial.

    • Jacklin said:

      Thank you for sharing the steps. This is very useful. Anyway the steps are very clean and easy to understand.

    • Kyle Eslick said:

      Great write up!

      Bookmarked for future reference 8)

    • Syahid A. said:

      Great tips for bloggers Madhur. Learning from experience is the best.

    • Dexter | Techathand.net said:

      This is cool although I am afraid to work in Mysql

    • Feb 08 stats said:

      [...] How to Repair MYSQL Tables [...]

    • Bobby’s Batch #12 - My Date With a Deceptive Lying Witch | Revellian Dot Com said:

      [...] How to repair MySQL Tables: Also from Madhur. I found this gem looking through his archives. A solid, step by step guide for repairing your wordpress MySQL tables. [...]

    • Bobby Revell said:

      I have a question, are you good at debugging mysql tables? Can you repair a corrupted wordpress database backup? Or do you know someone who can?

    • Madhur Kapoor said:

      @Bobby
      No Bobby, i have no expertise there. Maybe you can try visiting the some forums like digital point, you might find someone there.

    • Abhishek said:

      I never headed such Problem. any reason why such had happened ?

    • Madhur Kapoor (author) said:

      @Abhishek
      This can happen in due course of time as more queries are fetched from Database so it is better to check it regularly.

    • Vote for this article at blogengage.com said:

      How to repair MySQL Tables…

      Sometimes it is possible that your Wordpress database can become overburdened in the process of fetching so much requests and because of it, it will create overhead. As time progresses, overhead values of some tables can become very high and it might c…

    • Added by a PAL to FAQ PAL said:

      How to repair MySQL Tables…

      Sometimes it is possible that your Wordpress database can become overburdened in the process of fetching so much requests and because of it, it will create overhead. As time progresses, overhead values of some tables can become very high and it might c…

    • Wordpress commenting restored thanks to phpMyAdmin table repair » Moving at the Speed of Creativity said:

      [...] for help” post. Last week as I spent some time googling for answers, I came across a post (similar to this one) which explained how Wordpress mySQL databases over time can develop “overhead” and [...]

    Leave your response!

    Add your comment below, or trackback from your own site. You can also subscribe to these comments via RSS.

    Be nice. Keep it clean. Stay on topic. No spam.

    You can use these tags:
    <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

    This is a Gravatar-enabled weblog. To get your own globally-recognized-avatar, please register at Gravatar.