WordPress launched post revisions in version 2.6 update and it proved a wonderful feature. Yes friends, WordPress post revision is really a wonderful feature that stores the record of each saved draft and published article. So, it is very essential at the time when you mistakenly deleted the content of the post you was written yesterday or previously and even saved the draft. In that case, the revisions feature lets you restore the old versions of your post very easily without losing any single word.
So, anytime you may be needed to browse your older post revisions to restore one. But on the one hand, the post revisions is a wonderful feature, but it still came with a great deficiency that a common WordPress consumer ignores, i.e the revisions are responsible for increasing the size of your database.
As I told you, whenever you saves a post or a page, a revision is automatically created and stored in your WordPress database. Each additional revision will slowly increase the size of your database. If you save a post or page multiple times, your number of revisions will greatly increase overtime. For example, if you have 100 posts and each post has 10 revisions, you could be storing up to 1,000 copies of older data!
The larger size of database may increase the website page loading time and degrade the performance of website. So, if you’ve stored the great amount of useless post revisions in your database, you should delete them to free up the space and improve site performance.
RECOMMENDED FOR YOU:
- Display the Last Updated Date in WordPress Blog Posts
- WordPress Plugins That Secretly Power Allusefulinfo.com
How to Delete WordPress Post Revisions Easily
However the authentic way of deleting your old WordPress post revisions is from PhpMyAdmin but many people specially beginners would not be familiar with PhpMyAdmin and that’s why I’ve come up with an alternative and very easy way to delete your WordPress post reviews.
To delete the old post revisions in WordPress, you use can a plugin called Better Delete Revision, featured in 10 must have plugins I considered in 2014. Yes guys I also use this plugin to delete the old post revisions very easily.
UPDATE: Advanced Database Cleaner is the best plugin for deleting post revisions and the whole database optimization at the moment. I recommend you to try it.
Here’s the simple steps to install and use Better Delete Revision plugin for deleting post revisions:
Step 1: First of all, click on THIS LINK to download the Better Delete Revision. Now, login to your WordPress admin area and upload, install and activate this plugin.
Step 2: Now, after activating a click on Settings (at the same place) or you can also find it inside your WordPress admin area settings. Next, in the Better Delete Revision plugin settings, click on the button “Check Revision Posts” to find the number of revisions stored in your database.
Step 3: Plugin will show you all the revisions stored in your database. To delete these revisions, just scroll down the page to most bottom and click on button “Yes, I would like to delete them”.
It will take a little time (a few seconds took for deleting 264 revisions in my case) depending on number of revisions stored in your database and your connection speed.
Anything More I Need to Do?
No! After the above procedure, the post revisions will be deleted successfully from your database automatically and you don’t need to do anything more manually (from PhpMyAdmin).
As of mine, I hope you will also find this plugin very helpful for deleting your old post revisions from your WordPress blog database to save up the waste space.
Moreover, on having this awesome plugin, you don’t need to worry about database optimization or don’t need any other plugin to optimize your database. In fact, with Better Delete Revision, you can also optimize your database very easily in a just a few clicks.
MORE WORDPRESS TIPS:
Turning off Post Revisions
However, you can delete all the stored WordPress blog post revisions by using the above mentioned plugin, but can’t stop them saving more revisions on future updates.
So, you can easily turn off post revisions to be stored in your database by adding a simple code syntax to your wp-config.php file.
define( 'WP_POST_REVISIONS', false);
The above command will restrict WordPress from creating post revisions on updating articles. In case if you want to retain the saving of post revisions, then you can set a limited number of revisions to be stored in your database. Just use the following line in your wp-config file.
define( 'WP_POST_REVISIONS', 2);
Here the number 3 means that only 2 post revisions will be stored of each post in your MySQL database even you update the post number of times.
Its a great plugin but if we delete the post revisions, I had an issue, I mean in my posts I inserted a gallery, if we delete the revisions, only the gallery images are deleted in all posts which are having galleries in posts and remaining all are fine, could you give me the solution for this, other than that the plugin is awesome. Thank you –Ram
It is great plugin for deleting old post revisions. I don’t need to worry about anything because it is very easy to use.