When you update a blog post, Wordpress stores the old version of your post as a revision document. If you make very many updates, these revisions can have a significant impact on your database size. On some of my Wordpress sites, half the blog posts stored in the DB were revisions.
If you're sure that you don't need these older versions of your blog posts, you can delete them permanently with this MySQL command:
You might want to make a database backup first.Code:DELETE FROM wp_posts WHERE post_type = "revision";
Submit Your Webmaster Related Sites to the NB Directory
I swear, by my life and my love of it, that I will never live for the sake of another man, nor ask another man to live for mine.
After deleting the post revisions, add the following to the wp-config.php script. It disables post revisions. I added this to all of my blogs.
For most WordPress sites, tracking post revisions is a useless feature.Code:define('WP_POST_REVISIONS', false);
"Democracy is two wolves and a lamb voting on what to have for lunch. Liberty is a well-armed lamb contesting the vote." -- Benjamin Franklin