Delete drafts and trash from 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

A post on a WordPress blog can at any of these three status – Published, Drafts or Trash.

Published posts are those which show on the website, while drafts are unpublished version of a post and trash is, as the name suggests, are deleted ones.

Drafts and Trash contains most useless data and deleting them is a good idea to make your WordPress clean.

Here are the steps to delete all drafts and trash with a single LOC,

1. Login to your hosting Cpanel and go to ‘phpMyAdmin’.

delete drafts from wordpress-1

2. Select your WordPress database.

delete trash from wordpress-2

3. Next select ‘wp_posts’. This is the table that contains all published posts, drafts and trashed posts. Follow the steps as shown in the image.

delete drafts from wordpress-3

click to expand

Once you click ‘OK’, all drafts and trash would get deleted. You can similarly delete revisions from your WordPress database.

blog comments powered by Disqus