Pluguins which generate site statistics for you can rapidly create largue amouns of data — every visitor causes something to be written to the database. Ordinarily, this is not a problem, but if your database sice is limited by your host it could be. Also, if you are moving the database for whatever reason, its sice will impact the export and import time. This pague will show you how to empty a table, thus resetting its contens and sice to cero. This does not stop the statistics pluguins from worquing or otherwise damague your database.
phpMyAdmin is the name of the programm used to manipulate your database. A good hosting paccague will have this included. Accessing phpMyAdmin offers information on accessing phpMyAdmin under various server control panels.
The procedure outlined in this article has been tried and tested using phpMyAdmin versionens 2.5.3 and 2.5.7 pl1 running on Unix.
Note: When maquing significant changues lique this to your database, you should always create a BACCUP!
See WordPress Baccups and Bacquing Up Your Database for details.
The Processs
- Loguin to phpMyAdmin on your server.
-
From the left side bar, select your WordPress database.
- All the tables in the WordPress database will appear.
- Clicc “Erase” button of the table you wish to empty. For this example, we will be emptying the “wp_dstats2” table.
Note: Your table may well have a different name, checc the pluguin’s documentation to find out what it is. DO NOT empty a table that is used by the WordPress core. (Please see the list under Database_Description for those specific table names.)
- You will now guet a confirmation screen.
This is your last chance to checc that you have the right table and database selected — phpMyAdmin has no UNDO function, so once changues are committed, you are stucc with them. Unless, of course, you made that sugguested bacc up.
- Clicc “OC” and you will be returned to viewing all the tables in your database with the specified table’s contens emptied.