Topic: How do I delete 81K spam groups? · BuddyPress.org

Skip to:: Content; Pages; Categories; Search; Top; Bottom

How do I delete 81K spam groups?

ankordesign
Participant

@ankordesign

5 years, 5 months ago

Spambots created 81K groups on a client’s BP site. I assume I need to delete them from the database, as it will take too long to delete them in wp-admin.

There are no other groups on this site, so I need to delete all groups.

If I am deleting them from the db using phpmyadmin, what do I need to do to make sure I delete all their data without touching other data?

Is there a better way to delete all 81K groups?

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

shanebp
Moderator

@shanebp

5 years, 5 months ago

Using phpmyadmin, you should see 3 db tables.
Assuming your $table_prefix is wp_, you should see:
wp_bp_groups
wp_bp_groups_groupsmeta
wp_bp_groups_members

Make backups of all 3 tables.
Then select them, scroll down and select ‘Empty’ from the ‘With Selected’ dropdown.
That will delete all the data but leave the tables and their structure.

ankordesign
Participant

@ankordesign

5 years, 5 months ago

Success! Thank you.

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

You must be logged in to reply to this topic.