Delete Post Revisions In WordPress without Plugin

Delete Post Revisions In WordPress without Plugin – Occasionally updating or revising a post on your WordPress site isn’t a time-consuming task. It also doesn’t take up a lot of space. However, over time, revisions do start to add up and can eventually take up a considerable amount of space on your database.

Whether you’re in a pursuit to free up some much-needed space or prevent the matter altogether, disabling or removing old post revisions from your WordPress site is an available option. Doing either can help reduce database bloat and optimize performance.

In this post, we’ll discuss what post revisions are and how they can be used. We’ll explain why you’d want to disable, limit, or remove them, and walk you how to do each one. Let’s get started!

What Is a Post Revision?

Post revisions, which are sometimes referred to as revisions, are a built-in feature of WordPress. They are useful because they make it easy to revert to a previous version of a post and undo the changes you made.

For example, let’s say you decided to delete some paragraphs in your post. However, later, you realize that edit was a mistake and want to recover the information you eliminated. With post revisions, you can easily do that.

Delete Post Revisions via phpMyAdmin

Advanced users can delete WordPress post revisions via phpMyAdmin.

First, make sure that you have created a complete WordPress database backup.

After that, simply log in to your WordPress hosting control panel and click on the phpMyAdmin icon.

Next, you need to select your WordPress database from the left column. PhpMyAdmin will now display tables in your WordPress database.

After that, you need to click on the SQL tab from the top menu.

This will load phpMyAdmin’s SQL interface. From here you can manually run commands on your WordPress database.

You need to enter the following code.

DELETE FROM wp_posts WHERE post_type = "revision";

PhpMyAdmin will now delete all revisions from your WordPress database.