Title: Bulk Delete Data?
Last modified: November 27, 2019

---

# Bulk Delete Data?

 *  Resolved [mindeeforman](https://wordpress.org/support/users/mindeeforman/)
 * (@mindeeforman)
 * [6 years, 6 months ago](https://wordpress.org/support/topic/bulk-delete-data/)
 * Hi there,
 * I had installed WP RSS Aggregator a few years ago to aggregate a feed for my 
   website, but it never really worked the way I wanted it to.
 * Fast forward to today, and I now want to use it to pull in an RSS feed from Medium,
   but all my old data is still there. It’s more than 2 million feed items – 132,000
   pages. Is there a way to bulk delete all the plugin data and start fresh? I’ve
   uninstalled the plugin, but when I reinstall it, the data is still there. I talked
   to my hosting service and they were no help.
 * Thanks,
 * Mindee

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

 *  [Naweed Chougle](https://wordpress.org/support/users/hypersonic/)
 * (@hypersonic)
 * [6 years, 6 months ago](https://wordpress.org/support/topic/bulk-delete-data/#post-12187366)
 * [@mindeeforman](https://wordpress.org/support/users/mindeeforman/) You can run
   the following command using your MySQL client:
 *     ```
       DELETE p,tr,pm
           FROM wp_posts p
           LEFT JOIN wp_term_relationships tr
               ON (p.ID = tr.object_id)
           LEFT JOIN wp_postmeta pm
               ON (p.ID = pm.post_id)
           WHERE p.post_type = 'wprss_feed_item';
       ```
   
 * This will delete all feed items previously imported. Please ensure you have a
   full backup first, just in case something goes wrong.
 *  Thread Starter [mindeeforman](https://wordpress.org/support/users/mindeeforman/)
 * (@mindeeforman)
 * [6 years, 6 months ago](https://wordpress.org/support/topic/bulk-delete-data/#post-12190014)
 * Thanks – I tried that and it said “Table ‘edovatec_ss_dbname7b7.wp_posts’ doesn’t
   exist”
 * This really should be a feature of the plugin – is that possible to add?
 * The plugin has also been operating VERY slowly for me (possibly because of the
   2 million+ entries) and tends to only show some items. For example, when I was
   deleting the old feeds, there were 21 of them but I would only ever see 2-3 at
   a time.
 * Also, I had no templates this morning, so added one, and now I have 20 called“
   Default” and the one I added isn’t showing.
 * Any ideas?
 * Thanks again!
 *  [Naweed Chougle](https://wordpress.org/support/users/hypersonic/)
 * (@hypersonic)
 * [6 years, 5 months ago](https://wordpress.org/support/topic/bulk-delete-data/#post-12194937)
 * Can you check if the user running the command has the adequate permissions? Perhaps
   your database may have got corrupted, and you may need to run a repair from your
   MySQL client.
 * As for the trouble with Templates, we’ve seen this happen with users who skip
   an intermediate release while updating their core plugin to the latest version.
   To fix this, you’ll need to delete the templates from your database to get the
   site back to normal. To do so, delete all posts from `wp_posts` with `post_type`
   equal to `wprss_feed_template`.
 *  [Naweed Chougle](https://wordpress.org/support/users/hypersonic/)
 * (@hypersonic)
 * [6 years, 4 months ago](https://wordpress.org/support/topic/bulk-delete-data/#post-12296873)
 * Closing this thread since it’s been inactive for a while.

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

The topic ‘Bulk Delete Data?’ is closed to new replies.

 * ![](https://ps.w.org/wp-rss-aggregator/assets/icon-256x256.gif?rev=3157090)
 * [RSS Aggregator - RSS Import, News Feeds, Feed to Post, and Autoblogging](https://wordpress.org/plugins/wp-rss-aggregator/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/wp-rss-aggregator/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/wp-rss-aggregator/)
 * [Active Topics](https://wordpress.org/support/plugin/wp-rss-aggregator/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/wp-rss-aggregator/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/wp-rss-aggregator/reviews/)

## Tags

 * [delete](https://wordpress.org/support/topic-tag/delete/)
 * [wipe](https://wordpress.org/support/topic-tag/wipe/)

 * 4 replies
 * 2 participants
 * Last reply from: [Naweed Chougle](https://wordpress.org/support/users/hypersonic/)
 * Last activity: [6 years, 4 months ago](https://wordpress.org/support/topic/bulk-delete-data/#post-12296873)
 * Status: resolved