How to delete post revisions in WordPress blogs?

WordPress comes with a built-in feature that allows you to undo changes and go back to a previous version of a post. This feature is called Post Revisions or simply Revisions.

But suppose your post revisions are too high from across multiple posts. Sometime down the line you may need to delete them if the list has become too big.

Now there are multiple ways to do it. There are plugins avaialble to do it. But I feel having plugin for an action which you might not be using very frequently is not a good idea.
Simplest way to get rid of it is using code and delete directly from the database.

step 1: Login to your blogs cpannel of WordPress site’s hosting account and click on phpMyAdmin.



step 2: Click on the WordPress database of your blog from the left navigation panel.



Step 3: Go to SQL query window and enter the following command and hit ‘Go’.

That’s it. You are done.
Note: Do not forget to backup your database/site before running the command.

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.