How to Delete WordPress Post Revisions or auto saved posts

Its important to maintain your database table size and optimize them regularly when your blog is regularly being updated.

Delete and remove all existing stored post revisions and changes made on pages stored in the database in order to reduce the wp_posts table size, especially when there is already tons of revisions or changes been kept.

Method 1

To delete and remove all existing post revisions entries and rows from WordPress database Posts table, simply login to MySQL command-line interface, phpMyAdmin, SQLyog or other MySQL GUI tools. Select the appropriate WordPress database (if you have more than one databases on the same server), and then issue the following command (it’s also recommended to backup the database before performing the deletion SQL statements):

DELETE FROM wp_posts WHERE post_type = “revision”;

Once all post revisions related records is purged, all revision histories is deleted, and users no longer able to check the changes by phase or compare differences between versions.

Method 2

Add the below line to  to your wp-config.php file and  change the 6 to however many revisions you want or -1 to keep them.

define(‘WP_POST_REVISIONS’,6);

Method 3

Also you can use the WP plugin here   to delete old revisions.

Hope you enjoyed the post, let us know your comments

[ratings]

Related Articles You Are Probably Interested In:

1. How to Mass delete autosaved posts in WordPress
2. Tutorial: How to Disable or Limit or Delete Autosave Post-Revisions in WordPress
3. How to Mass Delete pending posts in WordPress
4. Life Saving SQL Queries for a WordPress Blogger
5. Auto post from your WordPress Blog to FaceBook Fan Page
6. How to Mass Delete Spam Comments at once?
7. How to Auto Post to FaceBook?
8. How can users submit Posts from Frontend in WordPress?

6 Responses to “How to Delete WordPress Post Revisions or auto saved posts”

1. The Method says:

   January 3, 2010 at 1:52 pm

   I was searching for Blogs about How to Delete WordPress Post Revisions or auto saved posts | OC Blog and found this site. I am interested in your content and I appreciate sites like this.

   Reply
   • admin says:

     January 6, 2011 at 2:02 am

     Thank you for your kind words! Am glad that it helped.

     cheers
     Josh

     Reply
2. Merrick Before GrainChickenDog says:

   May 28, 2010 at 10:59 pm

   Wonderful idea!!! I would like to thank you for informing this here. It will be very useful to me.

   Reply
   • admin says:

     January 6, 2011 at 2:03 am

     Glad that it helped you.

     cheers
     Josh

     Reply
3. Joshuthomas says:

   September 23, 2010 at 12:22 pm

   Welcome buddy !!

   Reply
4. khaleed says:

   June 18, 2011 at 8:35 pm

   Hi,

   Great and thanks for the tutorial but I think you forget to mention that when googlebot crawl the website they will see as a duplicate.

   One more thing the command that you write doesn’t work
   DELETE FROM wp_posts WHERE post_type = “revision”;
   The “revision” should be only contain ‘revision’.

   Anyway your article help me a lot on how to delete the autosave in wordpress because many articles I found doesn’t mention that we have to choose a database first before we can delete all revision. lol

   Reply