Bulk delete subscribers

Once you've installed phpList... ask questions here!
Forum rules
Please help the volunteers to help you by supplying the version of phpList you are using, browser & version and if possible, a link to your phpList installation.

Bulk delete subscribers

Postby samhast » 8:28am, Tue 27 Aug, 2013

How can I delete all the subscribers?
samhast
PL Nut
 
Posts: 17
Joined: 11:54am, Fri 24 May, 2013

Re: Bulk delete subscribers

Postby duncanc » 10:14am, Tue 27 Aug, 2013

There is not a command to delete all subscribers.

The best might be the Remove Subscribers page where you can copy/paste a list of email addresses to be removed.

Go to Subscribers > manage subscribers > bulk remove subscribers
duncanc
Moderator
 
Posts: 2440
Joined: 6:34am, Sat 08 May, 2010
Location: London

Re: Bulk delete subscribers

Postby samhast » 11:19am, Tue 27 Aug, 2013

yes then I have to copy a list of all the users (79000)
in previous version, it was possible to delete all users that are not member of a list... So that isn't possible anymore?
samhast
PL Nut
 
Posts: 17
Joined: 11:54am, Fri 24 May, 2013

Re: Bulk delete subscribers

Postby Sven2157 » 7:59pm, Tue 27 Aug, 2013

I am a bit reluctant to share this, as you can get into A LOT of trouble with this, but ...
  • *** The following SQL commands could break your database!
  • *** Once executed there is NO GOING BACK!
  • *** These execute EXTREMELY FAST!
  • *** ONCE DONE IT IS FINAL!
  • *** BACK UP DATABASE COMPLETELY, BEFORE ATTEMPTING!
  • *** I AM NOT RESPONSIBLE FOR YOUR ERRORS
  • *** YOU ASKED, I TOLD ...

* - This assumes default user table prefix( phplist_user_ ).

  1. Log in to your phpMyAdmin.
  2. Click the database name on the left.
  3. In the main window click SQL.
  4. In the SQL Editor/Composer window type then execute each of the following, one at a time:
Code: Select all
TRUNCATE TABLE phplist_user_user

TRUNCATE TABLE phplist_user_user_attribute

*** BACK UP DATABASE COMPLETELY, BEFORE ATTEMPTING!
That should be all of them. All 79,000 gone is a couple seconds! :shock:

Hope that helps! :wink:

Sven2157
Sven2157
PL Master
 
Posts: 170
Joined: 12:18pm, Fri 07 Jun, 2013


Return to Questions and Problems after Installing

Who is online

Users browsing this forum: No registered users and 3 guests

cron