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' |
Good post, thanks
I am very pleased you wrote that!!!
Tricia
Awesome 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.
Simply 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.