Sarathlal N

Remove Post revisions from WordPress Database

The post revisions are a feature in WordPress blog engine. When we edit or update a post or page, WordPress keep old data as a revision in WordPress database.

This is extremely helpful in certain situation because we can easily restore old data from these revisions.

But when we have more posts & pages in our blog, certainly we have a large database. Additional to these actual posts & pages, we have more than its double revisions in our database.

These stored post revisions don’t have any direct impact on our WordPress performance until we have a large database. But keeping our database as small & optimized is a an important “to do” in such applications.

So now we are going to delete all our WordPress post revisions from database using a simple SQL command.

DELETE FROM wp_posts WHERE post_type = "revision";

We can use MySQL command-line interface, phpMyAdmin, SQLyog or other MySQL GUI tools to perform this action. So use this tip & optimize our WordPress database to perform well.

Need Help?

Do you need any help on WordPress? I'm happy to help you.

Contact Me

Recent Posts

  1. Get variation product data on selecting variation options - WooCommerce
  2. Add TinyMCE WYSIWYG (Rich text area) meta box - WordPress
  3. Reorder product tabs in single product page - WooCommerce
  4. Download webpage for offline reading - wget
  5. Remove product tabs in single product page - WooCommerce

Your Questions / Comments

If you found this article interesting, found errors, or just want to discuss about them, please get in touch.