How to Delete Existing WordPress Post Revisions

Last Updated On: January 22, 2016

 

To remove all existing post revisions entries from WordPress database Posts table, simply login to MySQL phpMyAdmin. Select the appropriate WordPress database, and then issue the following command:

DELETE FROM wp_posts WHERE post_type = "revision";

it’s recommended to backup the database before performing the deletion SQL statements.