Warning ! phpMyAdmin is a powerful tool. I will not be held responsible for any loss of data.

WordPress 2.x.x uses a cache file. You MUST delete this cache st this time.
Delete everything in the /wp-content/cache directory as soon as you make the database change.

Plugins which generate site statistics for you can rapidly become very large - every visitor causes data to be written to the files.
Ordinarily this is not a problem, but if your database size is limited by your host it could be. Also, if you are moving domains, it could make your database slower to export and import.
This tutorial will show you how to empty a table, so resetting the contents to zero. This does not stop the plugin from working, and it does not damage your 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.
Note the size of the 'wp_bad_behaviour_log' table - this is one to be emptied in this example.


Now tick the box to the left of the table you wish to empty.
Note: your table may well have a different name, and unless you have been told otherwise, do NOT empty a table that is used by the WordPress core.


From the drop-down menu, highlight and click the 'Empty' option.

You will now get a confirmation screen.
This is your last chance to check - there is no 'UNDO' function here !


Click 'Yes' and you will be returned to viewing all the tables in your install.


And your table has been cleared out.
If you needed to Drop a table, follow exactly the same, but select 'Drop' from the menu.

 

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