Deleting 53000 Spam inactive users
Currently inherited a website which has a terrible spam issue with BP.
Simply put no measures were taken so it ran rampant. I have sorted this, but am now left with a very bloated DB.
SELECT * FROM wp_signups WHERE active = 0;
I get the list of all inactive users.
From here could some suggest the best way to remove all the data attributed to these inactive spam users?
It boggles me that there isn’t something online.
The reason i ask is i note the usermeta table is bloated along with the wp_signups, so i assume there is some relationship data in there, which ideally needs to go along with the inactive spam signups.
Any guidance appreciated.
And yes all is backed-up.
- You must be logged in to reply to this topic.