Remove revisions from Wordpress pages

To remove revisions from WordPress pages, follow these steps:

  1. Backup your WordPress database: Before making any changes, it's always a good idea to back up your database in case anything goes wrong. This will ensure that you can restore your site if needed.

  2. Access your WordPress database: You can access your WordPress database through a tool like phpMyAdmin or by using a database management tool provided by your hosting provider.

  3. Find the wp_posts table: In the database, locate the table with the name "wp_posts". The prefix "wp_" may be different depending on your WordPress installation.

  4. Identify the post_type: Look for the "post_type" column in the wp_posts table. The post_type "revision" is used for storing revisions of posts and pages.

  5. Delete the revisions: Run the following SQL query to delete the revisions from the wp_posts table:

DELETE FROM wp_posts WHERE post_type = 'revision';
  1. Optimize the database: After deleting the revisions, it's a good practice to optimize your database to reclaim the space. You can do this by running the following SQL query:
OPTIMIZE TABLE wp_posts;
  1. Verify changes: Verify that the revisions have been removed by checking your WordPress pages. You should no longer see any revisions listed.

By following these steps, you will be able to remove revisions from your WordPress pages. Remember to always backup your database before making any changes and proceed with caution.