Delete users from Joomla V2.5

Question

I am having an outside contractor work on my joomla site, and want to protect the users and passwords. I cannot use the solution in this thread since I have too many users - Bulk user delete on joomla 2.5

I have "cloned" the site to a new url, and then used MySQL Workbench to delete all of the users and the user groups map file.

DELETE FROM hhd_users where id>32; DELETE FROM hhd_user_usergroup_map where user_id >32;

However, I now receive a 500 error after trying to login. I cannot use the admin to delete users, even if I can show 1,000 on a screen at once because I have ~20,000 users in the DB.

Is there an easier way to delete the usernames and passwords? Is there another table I should have deleted as well?

Answer 1

If you are the only Super User (main administrator), you may find your own record in hhd_users and hhd_user_usergroups_map tables, make a record of it, or copy relevant data to some text file, and then EMPTY both tables.
Then create new records in both tables for yourself again, this time as only user in them.