Disable and Remove WordPress Revision Post Features

Posted by in Tips, Wordpress

ADVERTISEMENTS

After WordPress introducing post revision features, it helps wordpress blogger to keep revision of post and restore to previous revisions anytime. However, too many revision stored on wordpress database might cause longer query time and processes database requests. That means, your blog will load slower and your visitors may wait longer before the content comes out. Beside that, greater revision post on wordpress also causes high CPU or memory load on your web hosting server. 

So, there is many ways to delete revision wordpress post or stop the post revision on your wordpress platform. Over here i listed some trick to remove wordpress revision post and disable revision post on wordpress. 

Tips to remove unwanted post revision and disable post revision features on WordPress:

1. SQL command to delete post revisions

I would assume you know how to login to your phpMyAdmin and know how to execute SQL command. So, simply run this SQL command and all stored post revisions will be deleted.

DELETE FROM wp_posts WHERE post_type = “revision”;

2. Use Delete Post Revision WordPress plugin

delete wordpress revision post plugin

Delete Revision is a simple wordpress plugin that remove all revision post within few click. This wordpress plugin also automatically search for post revision on your wordpress database by pressing the Check Redundant Revision button.   

Download Delete Revision  

3. Disable Post Revision features on WordPress

You can turn off post revision feature by go to your wp-config.php and adddefine(’WP_POST_REVISIONS’, false); before the closing ?> tag

How to Turn off WordPress Post Revisions:

  • Login via an ftp client to the folder containing your WordPress site
  • Copy the wp-config.php file to your desktop
  • Using a text editor ( example :notepad), open the wp-config.php file
  • Before the closing ?> tag, add the following line of code:
  • define(‘WP_POST_REVISIONS’, false);

  • Save the file and upload it to your server, overwriting the old file

So, the above revision posts trick streamline your wordpress database, making it smaller in the query post process.

NOTE: Do this with care. If you are not sure what you are doing, make sure to at least create a backup of the database first or even better, ask a professional to help you. Remember, both the SQL command and delete revision plugin will delete all your post revisions, and you are not allow to choose which revesion to be deleted. So, please make sure you won’t regret after delete them!

  • George Serradinho

    Thanks for sharing this info, I had the plugin but wanted an easier way of doing this.

  • John John

    Thanks a lot for the detailed info.

  • Gale

    Who is not familiar with SQL shell can safely use a plugin that does that work for you: Better Delete Revision.
    It is really better the “Delete Revision” plugin mentioned in this article because it not only removes old revision of posts and pages but also every other meta content related to those revisions!

  • http://www.latestgirls.com LatestGirls

    Don’t know but this thing doesn’t seems to work. :(

    Putting that line in wp-config.php is not working for me.

    It still keeps on adding entries in the DB.

  • http://www.techmixer.com km

    @LatestGirls,

    Can you paste wp-config that you modify. Perhaps we can try to help what wrong on wp-config.

  • Manojgoure

    Great post buddy .. it really helped me.