Resetting / Reinitializing Database counters to get a fresh start

Discussion in 'Troubleshooting' started by accularian, Jan 20, 2007.

  1. accularian

    accularian Online Macintosh support — aMember Guru.

    Joined:
    Dec 12, 2006
    Messages:
    41
    Now that I am done testing... how can I reset my membership database back to zero. I want my first real customer to have an ID of 1. I know I can go into the sql database and change it manually but I really want to just reset the automatic counter... but I can not find that.

    Thanks

    Dana Haynes
    Accularian
    http://www.accularian.com
    accularian, Jan 20, 2007
    #1
  2. alex

    alex aMember Pro Customer Staff Member

    Joined:
    Jan 24, 2004
    Messages:
    6,021
    Try to run mysql query:

    DELETE FROM amember_members

    NOTE - it will delete ALL members from your aMember table!
    alex, Jan 24, 2007
    #2

Share This Page