WordPress introduces some new featured that called Post Revisions, if we keep on edit our post content, Post Revision will be created, and this is not good if you have a lot of Post Revision it’s will increased your Databases sizes, on this post I will show you how to deleted post revision and meta associated to those revisions on WordPress. So you can save your Databases sized.
The good things is, we will use SQL Queries to do this, you can use phpMyAdmin or install SQL Executionner Plugin and write down on your SQL Command Area
DELETE a,b,c FROM wp_posts a WHERE a.post_type = 'revision' LEFT JOIN wp_term_relationships b ON (a.ID = b.object_id) LEFT JOIN wp_postmeta c ON (a.ID = c.post_id);
And done, you have deleted post revision and meta associated to those revision. Thanks for share this code