How To Export Members Email from Vb Database?

[Rajdeep]

Hello,

Can anyone tell me if there is any way to extract members email from a vbulletin database ( .sql file )

Actually i have a very big and old database, i stopped running that site for some reasons, but now i have started new website and i want to send them email to inform about my new website.

Pleas dont suggest to restore the backup as its really big db and i am not willing to buy dedicated server for it just to get the emails.

Any help will be really appreciated.

Thanks
Regards.

[Stefan118]

If the old site still exists, you can make a kind of mailing list.

ACP --> Users --> Send email to users

You can write the mail there and send them to everyone in your database.

[Rajdeep]

no it doesnt exist now and i have already mentioned that.. and restoring it will be lot of pain as i will be needing dedicated to handle such big database.

[vbresults]

Get a install LAMP and phpMyAdmin (http://linux.justinhartman.com/Setting_up_a_LAMP_Server), import your database using mysqlimport (http://dev.mysql.com/doc/refman/5.0/en/mysqlimport.html), and export the email column from phpMyAdmin.

[Rajdeep]

I installed wampserver and restored database, but now how can i retrieve the email list?

[vbresults]

Run this query --
SELECT email FROM user

And export that.

[Rajdeep]

thanks for your reply, but i couldn't restore the whole database, it takes so much time in `vb_searchcore`, `vb_searchcore_text`, `vb_searchgroup`; and my pc got shut down by mistake, so is there is any easy way?

tell me command to restore only user tables from the full database

Thanks

Run this query --
SELECT email FROM user

And export that.

[Rajdeep]

anyone?

[Rajdeep]

I tried twice to restore the backup but i always end up getting this error -

Error 2006 <HY000> at line 3096232: MySQL server has gone away

how can i fix this?

Please someone help.

Thanks