How To Export Members Email from Vb Database?
 

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.

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.

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.

Get a install LAMP and phpMyAdmin, import your database using mysqlimport, and export the email column from phpMyAdmin.

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

Run this query --
And export that.

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

anyone?

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