How to remove wordpress Post Revisions

Share No Comments  Email

By: Energy Complaints | posted in Tutorials, Wordpress |
Date: June 22nd, 2009

Every time you update your posts or pages wordpress will automatically backup the last version of the posts. This feature can be very helpful when you want to go back in time and change your posts to the past version, but I find it clogging up the database as each update will add an new line to the database. Over time it can add up and I don’t really need this anyways.

To remove this Post Revisions.

First open up wp-config.php and add the line below…
define('WP_POST_REVISIONS', false);

To delete and remove all existing post revisions entries and rows from WordPress database Posts table, simply login to MySQL command-line interface, phpMyAdmin, SQLyog or other MySQL GUI tools. Select the appropriate WordPress database (if you have more than one databases on the same server), and then issue the following command (it’s also recommended to backup the database before performing the deletion SQL statements):

Click the Query Window icon on the top left corner of your phpmyadmin. See image below. Make sure you select the correct database first. When you click the Query Window icon, you should get a pop up, just past in the code DELETE FROM wp_posts WHERE post_type = “revision”; and clcik GO. Again make sure you back up first before doing this.

More info on “How to remove wordpress Post Revisions” with the below links.

Related posts:

1. Installing WordPress Tutorial This article is aim at beginners. Things you need before starting: A web host with cPanel and myphpadmin. Download the latest wordpress. FTP software to...
2. How to remove category slug from wordpress url Lets say you have your wordpress website online and you want to remove the word “category” from your url. For example: http://www.yourdomain.com/blog/category/wordpress and you want...
3. How to Transfer your WordPress site to a new web host I’m not going to each step by step, I am assuming you know the basics. If you don’t understand any of the steps, write a...
4. WordPress 3.0 is out! The newest WordPress is now out with version 3.0 Theonious. Version 3.0 is name after the famous Jazz musician Thronious Monk. With tons of new...
5. Helpful WordPress Modification Links Instead of writing each links on each post. I’m going to have this post containing all the list of wordpress links that I find helpful....
6. Two different design and layout for wordpress posts Lets say you have your wordpress setup and ready to go. But we all know that the current default wordpress can only have one single...
7. Back up wordpress SQL database I always find myself needing to back up my database from time to time and this is a great tutorial. Here I have tried using...
8. My top wordpress plugins My top wordpress plugins. 1. Akismet – This plugin comes standard with wordpress for a good reason. One of the most annoying thing is comment...
9. Free WordPress Setup and Installation Need help installing WordPress? You have come to the right place. We install WordPress free. Yes, free set up and free install for the...
10. Deciding to upgrade to Windows 7? Now that Windows 7 is in the market, many consumers are wondering how it compared to the past Windows operation system. Here is the...