Tables can sometimes get cluttered with little bits of info that are not actually needed, and while they don't break (unless they get really overcrowded) it is sometimes wise to tidy them up. For some reason this is called "Repairing"

Warning ! phpMyAdmin is powerful stuff. If you have any doubts at all, please seek further advice. I will not be held responsible for any loss of data. ALWAYS BACKUP before altering a database !


Login to phpmyadmin.
Click 'databases'


A list of your databases will appear. Click the one that is your WordPress database.


All the tables in your database will appear. What you want to look at though is any numbers in the right-hand column. (Your table names will be different).

These show where this clutter is building up and we can get rid of it.

For each row that has a number on the right, check the entry box on the left.


Now scroll to the bottom of the screen and find the drop-down box.
Select the Repair table option.


You will then be taken to a success screen.


Going back to your main database display, you should see all the numbers in the right column have gone :)


 

These pages are independent of http://wordpress.org
All design, content & images © Mark 2004-2008. All rights reserved.