Mass delete posts in a category

  • sebastienpage

    (@sebastienpage)


    16 years, 9 months ago

    Hello Community 🙂

    I am trying to mass delete posts in a specific category and I am having a hard time doing so using plugins. I found a few plugins but the problem is that I have so many posts (tens of thousands) that the plugin can’t handle it.

    I looked online and it says I should increase my runtime. Can’t do this.

    I read that the best way to mass delete posts from a category is to use phpMyAdmin or MySQL to delete them from the database directly. Note that I don’t have any knowledge whatsoever in these things.

    My question is, what is the MySQL query I have to run to: “delete posts from XYZ category that were posted between this date and this date”

    Your help would be greatly appreciated.

    Thanks in advance

Viewing 2 replies - 1 through 2 (of 2 total)
  • shane-g

    (@shane-g)

    16 years, 9 months ago

    Hi,

    Check with these steps:

    -> Login into the wordpress admin.
    -> Click on posts -> edit.
    -> Click on category for which you need to delete the posts.
    -> Select all the posts.
    -> Select delete from bulk actions drop down at the top which will delete the posts from the selected category.

    Also you can use this plugin:

    http://wordpress.org/extend/plugins/bulk-delete/

    Thanks,

    Shane G.

    Thread Starter sebastienpage

    (@sebastienpage)

    16 years, 9 months ago

    Thanks for the answer but that’s exactly what I don’t want to do. I obviously tried to go to post > edit > click category > delete.

    The problem is I have thousands of posts to delete and doing it this way would take me about… forever 😉

    I also tried the bulk delete plugin. It crashes on me all the time and doens’t seem to delete more than 4-5 posts at a time.

    Which is why I want to find out how to delete posts directly from the database…

    My question is, what is the MySQL query I have to run to: “delete posts from XYZ category that were posted between this date and this date”

    Thanks

    s

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

The topic ‘Mass delete posts in a category’ is closed to new replies.