• 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?

#1
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 :)
 

Jake Bunce

XenForo moderator
Staff member
#3
Run this query using phpmyadmin:

Code:
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
Thank you very much indeed Jake :)

Received this error when ran Jake -
Code:
#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