Support » Plugin: FeedWordPress » Is there a way to mass delete syndicated posts with an SQL script?

Viewing 3 replies - 1 through 3 (of 3 total)
  • When you click to remove the specific rss sindication it asks you what to do and there is option to “remove posts of this feed also”?

    Or you can try this plugins:

    http://wordpress.org/extend/plugins/wp-mass-delete/

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

    Cheers!

    @3×7: Thanks for your suggestion, but the “remove posts from this feed also” option, and the existing mass-delete plugins are too slow to execute (Over the past years, I racked up over 100,000 posts). Both hit the timeouts of my server (which are already set at very high values), and take ages to delete just 1000 posts.

    Experimenting on a test database with the above script, shows a delete of 350,000 posts is done in 120 seconds. But I am not sure if it does not leave any garbage in the database…. That is really the question…

    well it leaves some garbage for sure, specially if there were plugins that did some processing with posts and saved some post meta to their tables…

    Try WP-Cleanup plugin after deleting..

    Or I would suggest you to hire a developer to create this simple script with your code to remove all posts and all associated data to the posts.. this should not be expensive work…

    Cheers!

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Is there a way to mass delete syndicated posts with an SQL script?’ is closed to new replies.