Bulk Delete Posts

  • 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

Viewing 12 replies - 1 through 12 (of 12 total)

  • 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?

    Thread Starter planetphillip

    (@planetphillip)

    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!

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

    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.

    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. ??

    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.

    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?

    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…

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

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

    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)

    Anybody know of such a plug-in?

Viewing 12 replies - 1 through 12 (of 12 total)
  • The topic ‘Bulk Delete Posts’ is closed to new replies.