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 2 years, 1 month ago by anonymous87.
Viewing 2 replies - 1 through 2 (of 2 total)

  • 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

    (@anonymous87)

    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.