WordPress.org

1. sebastienpage
   Member
   Posted 2 years 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

2. Shane G
   Member
   Posted 2 years 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.

3. sebastienpage
   Member
   Posted 2 years 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

Topic Closed

This topic has been closed to new replies.