How do I delete a wordpress user from giant database?

Question

The native wordpress delete users page is unable to load for us, as we have hundreds of thousands of user accounts that it queries and loads into a drop down menu every time the page is loaded. Essentially our wordpress site has gotten so big that it's impossible to delete a user account using worpress's built in tool.

I can delete the user directly from the database, but I also want to attribute their content to someone. Is there another solution for deleting user accounts and attributing their content to another user?

Answer 1

Using WP CLI, you can easily delete users without concerns about loading the WordPress UI.

wp user delete is the command you're looking for.

In your case, use wp user delete 123 --reassign=567 for deleting a user by ID and reassigning to another user.