Title: Delete bulk posts from multisite
Last modified: February 2, 2023

---

# Delete bulk posts from multisite

 *  [anonymous87](https://wordpress.org/support/users/anonymous87/)
 * (@anonymous87)
 * [3 years, 4 months ago](https://wordpress.org/support/topic/delete-bulk-posts-from-multisite/)
 * Hi, I have wordpress multisite (5.2.4 version) and one of the admin account has
   been hacked and on his network site(and only there) is around 35000+ of spam 
   articles.
 *  I can access the database and delete the majority of those articles(by quering
   titles with spam words), but after some google search I found that it can get
   messy if I delete them directly from mysql, because data posts are in many tables.
 * So, what is the best solution to delete these bulk posts.
 * P.S. sorry for my english
    -  This topic was modified 3 years, 4 months ago by [anonymous87](https://wordpress.org/support/users/anonymous87/).

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

 *  [Dave Loodts](https://wordpress.org/support/users/davelo/)
 * (@davelo)
 * [3 years, 4 months ago](https://wordpress.org/support/topic/delete-bulk-posts-from-multisite/#post-16435980)
 * Auwh, that is a real mess. For bigger sites such as that probably is, first always
   take a backup. I would advice to make one via WPCLI; the command wp db export
 * Since it’s very hard to differentiate the injected “bad” posts to the real posts;
   i guess it’s nothing else then doing the manual labour. Or otherwise reinstall
   a previous backup.
 * Another thing you can do: create now a new staging copy site; and test out your
   own solution; which could be okay in some ways. But when you’re a bit unsure;
   do test that on staging.
 * Good luck!
 *  Thread Starter [anonymous87](https://wordpress.org/support/users/anonymous87/)
 * (@anonymous87)
 * [3 years, 4 months ago](https://wordpress.org/support/topic/delete-bulk-posts-from-multisite/#post-16436893)
 * Well, I can guarantee that I can differentiate the injected “bad” posts to the
   real posts, because the real ones don’t have words like dating, gambling and 
   other spam words. So I can find all IDs(or at least 90%) of these posts.
 * I want to risk(but I’ll do a backup), but I need some advices how to doit from
   mysql or maybe some wordpress functionality.

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

The topic ‘Delete bulk posts from multisite’ is closed to new replies.

 * In: [Networking WordPress](https://wordpress.org/support/forum/multisite/)
 * 3 replies
 * 2 participants
 * Last reply from: [anonymous87](https://wordpress.org/support/users/anonymous87/)
 * Last activity: [3 years, 4 months ago](https://wordpress.org/support/topic/delete-bulk-posts-from-multisite/#post-16436893)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics