Notifications
Clear all

How do I delete 32,000 inactive users (UI can do only handful at a time)?

2 Posts
2 Users
1 Reactions
144 Views
Posts: 127
Topic starter
(@mplusplus)
Reputable Member
Joined: 5 years ago

Hi there,

My WPForo has over 32,000 inactive users (bot attack) and I need to delete them all. (Admin UI allows only a handful at a time, so I need a better way).Ā 

Is there a MariaDB SQL Query that I can run or do something else to delete all inactive users in one go? I have attached the list of table names in my database.

Thanks.

Ā 

PS: I found some SQL queries but they did not work for my case.

1 Reply
Sofy
Posts: 5207
 Sofy
Admin
(@sofy)
Support Team
Joined: 7 years ago

Hi,

You can use the code provided here: https://wpforo.com/community/how-to-and-troubleshooting-2/delete-inactive-users/#post-77189.

Just change the prefix according to your website.

Reply