WordPress has very useful function to store previous sessions and copies of every post to restore, if you lost your connection or you want to compare your post with another post. Its a good feature but at the same time, it takes a lot of space in your database. Here I have a piece of code to remove unnecessary post revisions.
Please backup your database before executing these codes.
Simply go to you phpMyAdmin > Select your Database >SQL query > Execute the following command and then Go.
| 1 2 3 4 5 | DELETE a,b,c FROM wp_posts a LEFT JOIN wp_term_relationships b ON (a.ID = b.object_id) LEFT JOIN wp_postmeta c ON (a.ID = c.post_id) WHERE a.post_type = 'revision' |
kevin davis says
September 23, 2010 at 8:37 amGood post, thanks
Tricia says
September 25, 2010 at 1:37 pmI am very pleased you wrote that!!!
Tricia
Staten Locksmith says
September 27, 2010 at 4:33 pmAwesome post Muzammil, it’s been a while since I’ve been on here. I see that nobody has lost their passion. Good to be back.
potenzmittel shop says
October 3, 2010 at 1:48 amSimply discovered your web page through google and I consider this can be a disgrace that you are not ranked upper due to the fact that that is a Great post. To switch this I determined to avoid wasting your Blog to my RSS reader and I will try to point out you in one of my posts since you actually deserv extra readers when publishing content material of this high quality.