WordPress.org

Ready to get started?Download WordPress

Forums

Bulk Delete Posts (13 posts)

  1. planetphillip
    Member
    Posted 6 years ago #

    Hi,

    I have approximately 1000 posts I would like to delete in various categories.

    What is the best way for me to do that?

    I was hoping to create a new category, make it the default, delete all the categories that have posts I want to delete (All the posts in those cats wneed to be deleted) This would then move the post to the new default catgory and then delete that category.

    Unfortuantely it seems to revert back to the "General" category after the default.

    Any suggestions?

    TIA

  2. brockangelo
    Member
    Posted 6 years ago #

    I've done it two ways (doesn't mean either is right) :)

    1. Delete manually in Manage->Posts (yes, it is tedious)
    2. Go into phpMyAdmin and delete ranges (risky but quick)

    If the posts you want to delete are scattered, you'll probably want to find a better way. But if you have large blocks like "id# 213-568" phpMyAdmin might speed it up.

    Anybody else know a faster way?

  3. planetphillip
    Member
    Posted 6 years ago #

    Thanks for the reply. I considered doing it via phpmyadmin but didn't know if there were other tables that the post linked to that would screw things up.

    Deleting 1000 manually will drive me crazy!

  4. brockangelo
    Member
    Posted 6 years ago #

    "Deleting multiple posts" would be a nice suggestion for the "Ideas" section here on the codex, if its not been requested already.

  5. nims
    Member
    Posted 6 years ago #

    Hey even I am looking for such a thing. I guess there is a plugin to manage bulk posts ... but I dont remember off hand .. will search it out ... u do that 2.

  6. affiliatetip
    Member
    Posted 6 years ago #

    I would love a solution for this, too. I created a new blog to aggregate all of my blog posts and installed the WP-o-Matic plugin.

    This morning, I woke up to find 1300+ posts of the same post to the blog. :-P

  7. affiliatetip
    Member
    Posted 6 years ago #

    I searched for much of the day and never found a way to bulk delete within the amdin.

    So I did like brockangelo and went into phpMyAdmin.

    Under databases, I went to wp_posts and it was pretty intuitive as for how to select and delete posts quickly.

  8. jurgenfauth
    Member
    Posted 6 years ago #

    Looking for this, too -- I have posts in categories that need to be deleted, so a "delete all posts in category" would be just the ticket. Is there a way of doing that in phpMyAdmin?

  9. justinratwebtek
    Member
    Posted 6 years ago #

    You'd basically have to write a delete statement that uses a Join or (the better option) a subquery between wp_posts and wp_post2cat.

    I'd write an example, but I seriously just woke up and that'd be a bad idea considering I haven't had any coffee...

  10. Roy
    Member
    Posted 6 years ago #

    This one with more options would be nice, but this one promises what Phillip asks.

  11. jurgenfauth
    Member
    Posted 6 years ago #

    Great, thanks. That mass post manager looks like the ticket.

  12. DJ Allyn
    Member
    Posted 6 years ago #

    It would really be nice to have a plugin that would delete Posts and comments by date range.

    When I still had a Movable Type blog several years ago, you were able to click little check boxes of the posts you wanted to delete and then just hit the delete button.

    My problem is that I have divided two years worth of blog entries into two subdirectories for archival purposes. I went through the tedious process of downloading the database and pruning out the earlier year and then restoring the latest year to the new subdirectory. Now I have to go back to the original one and magically remove the past year's worth of posts, leaving the first year intact.

    We are talking about 8139 posts and 73992 comments in total. (yes, that is the reason for splitting it up -- the database is severely overtaxed)

  13. blogonexpo
    Member
    Posted 6 years ago #

    Anybody know of such a plug-in?

Topic Closed

This topic has been closed to new replies.

About this Topic