XF 1.1 Save Users?

[PetSue]

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]

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

Admin/Mod please delete 2, sorry.

 

[Jake Bunce]

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.

 

[PetSue]

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

 

[Chris D]

Maybe drop the ; at the end. So:

SELECT username, email
FROM xf_user

 

[PetSue]

Thank you very much guys worked a treat