reversing an import

[ajlee]

we accidently imported a group of people into a list that shouldn't be on there. is there anyway to 'reverse' that import? even if we just go back to the list from a day or two ago...

[DW]

Users can be removed using a custom tool like PhpMyAdmin commonly available from your web hosting control panel.  This is done by clicking yoru database and then "SQL", where you can enter a custom MySQL query.

To remove all users imported to list 1 on May 2nd try the following query.  Note that running these queries is non-reversible so be very careful you have the correct list and date.

DELETE FROM lm_users WHERE list = '1' AND dateadd = '2008-05-02' AND refurl LIKE '%Imported%'

If you want to see which users -would- be deleted before running DELETE:

SELECT * FROM lm_users WHERE list = '1' AND dateadd = '2008-05-02' AND refurl LIKE '%Imported%'

Regards