There are many useful features in WordPress, and one of them is the Post Revision feature. This is already in WordPress versions, although this is a useful feature, it may cause some problems. One of them is to increase the size of your database as it will have to save the editing history. Depending on how long you have been writing a post, you can edit the post dozens of times and then archive the entire revision history will become problematic. Now you can manually delete them, or you can run a simple query that we will show you in this article and delete all revision.
The first thing you need to do is log in to phpMyAdmin and select your WordPress database.
Click the SQL button and enter the following query:
Code:
DELETE FROM wp_posts WHERE post_type = "revision";
In this code, let's look at the wp_posts table and remove all posts that already have a revision post_type associated with it. Now depending on the size of your database, this can save you much space.
