I was recently messing around with my website’s MySQL database, and I did something new and good. I searched around the internet and there is no script on the internet to delete WordPress post revisions using functions.php file, so I created one. Believe me, it’s easy as making milkshake.
Add following code to your theme’s functions.php file and it’ll delete all the post revision:
DELETE FROM $wpdb->posts
WHERE post_type = 'revision'
[alert style=”red”]Note: Please remove this code immediately after saving your functions.php file. You only need to run this code once, there’s no need to keep this code in your theme.[/alert]