Much has been said about how uncomfortable is WordPress keeping backup copies of our entries as we are writing them. For certain sites that are very good, but We think it is a feature that should be disabled by default, since it does nothing but dirty the database.
There are two methods to delete the revisions in WordPress, one through the database and another one with a plugin.
1. Log in to your hosting Control Panel (cPanel, Plesk, etc). In the Databases section, choose your database and click in phpMyAdmin.
2. Now you are in the phpMyAdmin control panel.
3. Execute a SQL. Insert a query, using the DELETE command, as follows:
DELETE FROM wp_posts WHERE post_type = "revision";
All revisions of the database of your wordpress will be removed, freeing a good space in it.
There are some plugins that delete the revisions in wordpress, optimizing the database and doing the work automatically. Use the wordpress plugin search to find them. You can use the official wordpress plugin page to do the search and then search within the plugin section of your wordpress. I find it more comfortable that way, especially visually.
Deactivate the historical function
You can disable the function of saving the revisions if you are not interested. I show you the method to do it:
1. Access the FTP where you have hosted your website with wordpress (you can do it with an FTP program, through Dreamweaver or in the simplest way, which is through the control panel of your hosting, look for the section FILES or FILES ADMINISTRATOR).
2. Inside the file page, you will see a list of them, choose wp-config.php and open it.
3. Add this line to the end of the text:
/** Disable WP Post Revisions */define('WP_POST_REVISIONS', false);
In this way, copies of the revisions will not be saved in your database any more.
With these methods (cleaning database, installing plugin and deactivating the historical function), You can remove all revisions of entries in the database that we don’t need. I hope you like this tutorial.