No announcement yet.

Mass Delete Users through PhpMyAdmin

  • Filter
  • Time
  • Show
Clear All
new posts

  • meissen
    started a topic [Forum] Mass Delete Users through PhpMyAdmin

    Mass Delete Users through PhpMyAdmin

    I have about 1,000 spam users that I need to delete from my site. All of these users have zero posts, but they all have signatures with URLs in them. I can see there's references to the users in multiple user tables. I already have a CSV file with all the user IDs I want to delete, so basically I just need to know how to set up the query or queries.

    Delete rows from users where userid IN (csv file)
    Delete rows from usertextfield where userid in (csv file)

    etc etc etc.

    What tables do I need to run the delete rows against?

    Thanks in advance.

Related Topics