How To Delete Existing WordPress Post Revisions_Dont Miss

by jaswanth (81) on December 26, 2009 | 1 Comment | 1,621 views

Friends, In this following tutorial, i am going to tell how to delete or remove existing WordPress post revisions. As we know that with WordPress 2.6 and beyond we got a feature called Post Revisions. It having some advantage but frineds.. this will clutters up the database with redundant content. More over if this continueing further your wordpress blog will take more time to load, even the custom fields may not work properly. So guys it is better to delete even once in a month or 20 days.

Just follow what i gave bellow.

First login to your phpMyAdmin section.
Just select your WordPress database from the phpMyAdmin
Now click on SQL tab from the menu at top and insert the following line of code and click go.

DELETE FROM wp_posts WHERE post_type = "revision";

Thats it you are done, now all the post revisions related records should have been wipe from your SQL database and all revision history should have been deleted, now you can find your loading speed of your blog cheers