Export 420.000 mails

[adivor]

Hello to all!

I have a 420.000 users forum and i need export only mail addres in txt file. I tried "generate mailinglist" in admin menu but i can't see all mails...

Please Help Me :-(

[omardealo]

1- open phpMyAdmin from Cpanel
2 - select your database
3 - from top click SQL
4 - Run this SQL query
SELECT email
FROM `user`
ORDER BY `user`.`email` ASC
5 - from top click Export
6 - select CSV from list on left , in down ( Save as file) from Compression select zipped and click Go in down

[Lynne]

Or, if you do want to use the admincp to generate it, just do one usergroup at a time.

[adivor]

Thanks,

last question:

I need ip and timestamp on my export... how is possible? i don't see this datas on phpmyadmin :-(

I need:
mail - username - reg date - ip

[ozzy47]

Follow the instructions in post #2, but change this line:
SELECT email

To this:
SELECT username,email,joindate,ipaddress

[adivor]

thanks!

[ozzy47]

Not a problem, glad to help. :)