Delete all auto-saves/revisions in a WordPress blog without using Plugin

  1. Previous
  2. Next
  3. Recent

    1. Signs 'He' May be Cheating on You
    2. 7 Vows of Hindu Marriage - Know What 'Saat Vachans' Mean
    3. RuPay vs Visa vs Mastercard vs American Express- A Comparison
    4. What is RuPay? Everything You Need to Know About India's Domestic Payment System!
    5. Top 10 Online Portals to Find a High Paying Job in India
    6. Top Indians who Revolutionized the IT Sector in India
    7. 8 Initiatives by Narendra Modi that Could Change the Future of the Nation
    8. 8 Work-from-home Jobs for Housewives, Students, and Part timers
    9. Complete Company Registration Process in India - Explained
    10. Change Name in India in 5 Steps - Filing Affidavit, Newspaper Ad & Gazette Notification

When a blog-post is written using WordPress, its auto-saved after every 60 seconds. This is to prevent accidental loss due to system or browser crash. In fact, every blog-post has an auto-saved version if changes are made in it.

Additionally, when an author manually saves a post or make changes to it and publish, the previous (same) post is saved as revision.

deleting revisions is important for a wordpress blog

On an average, a post has a minimum of 5-6 revisions, which are all stored in database consuming big space. A blog with 500 posts might be as heavy as 2500 posts. So a better idea is to free it. We can do this by executing simple MySql query on the database for a WordPress blog.

Stepwise Instructions to delete all revisions

1. First login to your webserver. Here we’ve CPanel as the interface.

2. Now go to ‘phpMyAdmin’.

delete all blog revisions or auto-saves from wordpress-1

3. Select your WordPress database. Here its named as ‘wordpress’, your database might be named differently.

delete auto-saves from wordpress-2

4. Select ‘wp_posts’ table, then click SQL at the top. Enter the following query and execute it pressing ‘Go’ button. Click ‘Ok’ when asked for confirmation.

delete auto-saves from wordpress

click to expand

That’s all! All revisions should be deleted by now. This would free up lot of space from your MySQL database. You can also delete drafts and trash similarly.

[This process is useful in freeing up space, and making WordPress database to perform faster. Its completely safe.]

blog comments powered by Disqus