By wwwoliondorcom on

How to select Database fields to Export from MySql ? Need only usernames and Emails

Hi,

Trying to export database users list I can't select only the USERNAME and USER EMAIL, so can you tell me how to do ?

Thanks a lot.

⋅ Categories: Drupal 5.x

Comments

mahyarsbt’s picture

mahyarsbt commented

you want to export from Drupal or phpmyadmin?

in phpmyadmin go to your drupal DB
go to users table

user table query show :

SELECT *

edit table query with Profiling [ Edit ] to:

SELECT `name` , `mail` 
FROM `XX_users` 
LIMIT 0 , 10000

Note1: if you set table prefix change "XX_" to your table prefix

then user table show users & emails only

in end of table
you can see "Query results operations"
click export

wwwoliondorcom’s picture

wwwoliondorcom commented

Thank you, yes i want to export usernames and passwords from Mysql to text file, and i will try this now.

MakeOnlineShop’s picture

MakeOnlineShop commented

Hi,

Can you explain exactly how to export Email addresses to a text file from MySQL ?

Thank you.