1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

XF 1.1 Save Users?

Discussion in 'XenForo Questions and Support' started by PetSue, Sep 3, 2012.

  1. PetSue

    PetSue Member

    Just wondering please if it's possible to save the User list by name and email address from either the Admin or Database?

    Thank you :)
  2. PetSue

    PetSue Member

    Apologies for triplicate thread but received error each time of dead server.

    Admin/Mod please delete 2, sorry.
  3. Jake Bunce

    Jake Bunce XenForo Moderator Staff Member

    Run this query using phpmyadmin:

    SELECT username, email
    FROM xf_user;
    If you want to save the results then click Export at the bottom of the page in phpmyadmin after you run the query. It will give you lots of format options.
  4. PetSue

    PetSue Member

    Thank you very much indeed Jake :)

    Received this error when ran Jake -
    #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'LIMIT 0, 30' at line 3
  5. Chris D

    Chris D XenForo Developer Staff Member

    Maybe drop the ; at the end. So:

    SELECT username, email
    FROM xf_user
  6. PetSue

    PetSue Member

    Thank you very much guys worked a treat :)

Share This Page