How to delete all users?

Discussion in 'Troubleshooting' started by akanowicz, Sep 24, 2009.

  1. akanowicz

    akanowicz New Member

    Joined:
    Feb 19, 2007
    Messages:
    31
    I imported our member list, but for some reason the expire dates were all set to 9/20/2009, which prevented me from doing a rebuild db to move them into WP.

    Is there a way to delete all users so that I can reimport them correctly?
    akanowicz, Sep 24, 2009
    #1
  2. thehpmc

    thehpmc Member

    Joined:
    Aug 24, 2006
    Messages:
    901
    Did you not backup the database first? You could then reinstall old database.
    thehpmc, Sep 24, 2009
    #2
  3. skippybosco

    skippybosco CGI-Central Partner Staff Member

    Joined:
    Aug 22, 2006
    Messages:
    2,526
    So you added payments AND users or what was the expiration date that you're referring to?

    Either way, from PhPmyAdmin you can run a SQL command like:

    DELETE from members where added = {whatever the added date/time value is for the users you imported}

    and/or

    DELETE from payments where expire_date = 2009-20-09

    obviously backup before experimenting
    skippybosco, Sep 25, 2009
    #3

Share This Page