How to Delete Post Revisions from WordPress Database

Add Tool

Delete Post Revisions from WordPress Database


Delete Post Revisions from WordPress Database

There are a lot of good features of WordPress, Post Revisions is one of them. This is a helpful and a good feature, it may cause some problems. One of them is increase the size of WordPress Database. It depends on how long it takes you to write a post, you might have as many as hundred post revisions. Now if you want to delete it manually, you will need many time. You can delete them quickly through MySQL database easily. To delete all revision of your post through MySQL you need to run a simple query which we will show you in this post and get rid of all these useless revisions.

How to Delete Post Revisions from WordPress Database

At first to do this you need to login to your phpMyAdmin and select your WordPress Database. After selecting your current site database

delete post revisions from wordpress database
Click on the SQL Button and enter the following query:

DELETE FROM wp_posts WHERE post_type = "revision";

In this code basically we looked up a table wp_posts and removed every post that had a post_type revision associated with it. Now depending on the size of your database, this may save you a lot of space.

Source: http://www.wpbeginner.com


Tags: WordPress delete post revisions, WordPress limit post revisions, wordpress database, WordPress view post revisions, wordpress database backup
Payza

About Masum Billah

Delete Post Revisions from WordPress Database 1stWebSuite website seo tool is a free website ranking tool site provides a lot of on page and off page seo useful tools for you. On this site, we have a large number of website ranking tools


SIGN UP TO GET UPDATE TO YOUR INBOX




Discuss about: How to Delete Post Revisions from WordPress Database


adf.ly