![]() |
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 --
Code:
SELECT email FROM user |
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 Quote:
|
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 |
All times are GMT. The time now is 12:34 AM. |
Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
![]() |
|
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|