First, I spent a good portion of my whee early hours this morning cleaning up some Wordpress Database issues I found to be absolutely hideous. First and foremost the post revisions offered up by Wordpress now-a-days is definitely useful and an appreciated feature; but it has some serious database issues that I find really annoying.

So, let’s first disable Wordpress’s post revisions by modifying wp-config.php in your web root:

define('WP_POST_REVISIONS', false);

Just throw that code in your wp-config and we can move on to removing the revisions from the wordpress database with:

DELETE FROM wp_posts WHERE post_type = "revision";

If you’re like me, you probably renamed your table prefix in Wordpress’s config (wp-config.php), if so just adjust wp_posts to reflect your wordpress table prefix. That about does it!