Sciencetext Tips & Tricks

Tech talk, social media, blogging, computing tips and tricks

Disable and Delete Wordpress Post Revisions

March 12th, 2009 · by David Bradley >> 5 Comments

  • Share/Bookmark

delete-post-revisionsFreelance blogging publisher and design expert, Kim Woodbridge, discusses one of the potentially confusing aspects of the current version of the Wordpress blogging software – post revisions. Ever since version 2.6 (we’re currently at 2.7.1) the software keeps a copy of all the modified versions of each post you write, which can add up to a lot of space used needlessly in your Wordpress MySQL database in a very short time if you’re a prolific blogger or simply like to tweak your posts a lot before publishing.

Thankfully, Kim runs through a wp-config.php hack to disable post revisions that will save a lot of heartache if you’re on a limited hosting account.

She also points out that there is a plugin – WP Post Control – that can do the job of disabling revisions (as well as a few other things) for the fainthearted who don’t fancy editing core WP files by hand.

Using the plugin route has the added benefit of not having to remember that you modified the file when you upgrade or have to restore from a backup of your wp-config.php file. So, I ran the plugin and disabled post revisions and made the non-Flash uploaded default for adding images to my posts too. One thing I noticed, however, is that it does not remove post revisions from old posts.

For that you will need the plugin Delete Revision, which as the name suggests allows you to find all the posts with at least one revision copy, and delete them all with just a couple of clicks. There were almost 2000 post revisions on Sciencetext, now cleared out. If you’ve disabled post revisions, you can safely uninstall Delete Revision once you’ve done that.

5 responses so far ↓

  • Kim Woodbridge // Mar 12, 2009 at 2:02 pm

    Good find with the Delete Revision plugin! You had a lot of revisions.

    I did not actually test WP Post Control so I’m assuming it works without any problems …?

    And thanks for reminding me to edit my twitter bio – I’m certainly not an expert ;-)

  • David Bradley // Mar 12, 2009 at 2:37 pm

    Yes, I don’t know how I accumulated quite so many revisions. I guess part of it is when I’ve interviewed someone about whom I am writing and then they’ve got back to me with additional material that needs splicing in later.

  • Laura // Mar 15, 2009 at 4:09 pm

    This is one of the most useful posts I have read for using WordPress. Thanks. I’m going to get rid of my revisions too. I should go through my old posts and clear the code up from my change to WP from Blogger. Left a lot of junk which will make a lot of revisions. I wouldn’t have known about them without your post. :)

  • David Bradley // Mar 15, 2009 at 7:54 pm

    Glad to be of service Laura ;-) Credit to Kim W for putting me on to this idea though.

  • 8 WordPress Spring Cleaning Tips: Backups and More | (Anti) Social Development // Mar 16, 2009 at 1:41 pm

    [...] or a plugin, remove old ones manually with Stratos’ instructions, or remove old ones with the Delete Revisions plugin found by David Bradley. Let’s keep our WordPress database as light as we [...]