Why would you want to do that?
Because, it makes sense to maintain your database table size and optimize them regularly when your blog is regularly being updated. Removing all past post revisions and changes can help you purge a significant amount of redundant data stored on your blog’s database and help speed up the operations.
There is practically no need to maintain a burgeoning repository of all post revisions and auto-saves until you have a battery of writers working cross functionally on several articles.
How Do You Do It?
There are more then a couple of methods available to help you achieve this. Take your pick:
For The Technically Inclined
I love this method since I have a database administration background and I love to have complete control over my databases.
- Login to MySQL using command line interface, phpMyAdmin, SQLyog or any other MySQL GUI that you can lay your hands on.
- Select the appropriate database and perform a backup.
- Select the WordPress database that you want to purge data from (if you have more than one databases on the same server), and then issue the following command:
- This should purge all your revisions and auto-saves.
- Once done, users will no longer be able to check on the changes made or compare the differences between various versions.
- If you know SQL you should be able to modify the commands to add or remove post revisions selectively.
For Power Users
- Open the wp-config.php file.
- Add the follwing line of code:
- Change the 6 to the number of revisions you would like to maintain.
You can use the following WP plug-ins to delete old revisions:
We hope that you will now be able to exercise more control over post revision. Let us know of your comments.Tags: Amp, Blog, Command Line Interface, Complete Control, Config, Control, Database Administration, Database Table, Databases, Delete, Dummies, Mysql Gui, Plug Ins, Plugins, Power Users, Redundant Data, Repository, Revision Control, Revisions, Sqlyog, Wp