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

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
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.
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