XF 1.1 Save Users?

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

PetSue

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

Admin/Mod please delete 2, sorry.
 

Jake Bunce

XenForo moderator
Staff member
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.
 

PetSue

Member
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
 

Chris D

XenForo developer
Staff member
Maybe drop the ; at the end. So:

Code:
SELECT username, email
FROM xf_user
 
Top