Following yesterday’s post about Turning Off Post Revisions today I’m going to show you how to delete those revisions from the data base.
It’s very simple. Open your PhpMyAdmin or wherever you can administrate your data base and run the following query:
Note: Backup your data base before continuing!
Note 2: please notice that maybe your tables tag are diferent. If your table is called XX_posts and not wp_posts just change that in the query.
DELETE FROM wp_posts WHERE post_type = "revision";
Running this query in my personal blog time ago it deleted about 10,000 revisions 😉