How to Mass Delete Post Revisions through Phpmyadmin

phphmyadmin-wordpress

If you are not using any plugin and don’t want to install one either to delete your Post Revisions which could take a lot space in case you have too many blog posts with revision, in this case you can delete all of the post revision at once by excecuting below query in your database using phpmyadmin, before you do make sure to back up database

DELETE FROM wp_posts WHERE post_type = "revision";

voila! you should have all of your post revision deleted by now!

How to Share Facebook Videos on your Blog – Website !
Convert Photoshop Design to Wordpress Theme !
Update Twitter, Facebook, Jaiku Status !
50 Attractive iPhone and iPod Touch Wallpapers
Wordpress 2.8 Around the Corner !
More Yahoo Meme Invites Available
How to Share your Tumblr Posts on Facebook !
How to make money Online !
Mumbai Rocked by a Terror Attack Death Toll at 100
Installing MAC OSx86 on PC – Dual-Boot Method [How-To-Guide]

This entry was posted on Saturday, February 14th, 2009 at 8:27 am and is filed under Tips. You can follow any responses to this entry through the RSS 2.0 feed. You can skip to the end and leave a response. Pinging is currently not allowed. - You can Also Follow us on Facebook or Twitter.

iPro