Problem exporting 15,000 email addresses

[twg]

I tried to use the Add on and then installed it on ZenCart but whenever I click on export email addresses, it will not work and timeout..

It takes a long time and just timeout. My customer database is about 15,000.

Anyone can help?

Any other way to get an export of the email addresses in CSV format?

Thanks for the help!

[tino.schlegel]

It times out because your host probably stops the execution of a php script after some time (e.g. 60 sec or less) There is no way around. You can only export the emails in smaller groups so that is doesnt abort the export.

Maybe try to use export the emails from the database directly. It could be faster so that all 15k are exported at once.

[RodG]

I tried to use the Add on and then installed it on ZenCart but whenever I click on export email addresses, it will not work and timeout..

It takes a long time and just timeout. My customer database is about 15,000.

Anyone can help?

Any other way to get an export of the email addresses in CSV format?

Thanks for the help!

Open the database with phpMyAdmin

Enter the following SQL query:

SELECT `customers_email_address` FROM `customers` WHERE 1

Press the 'export' button at the bottom of the page.
Tick the 'CSV' tickbox
Tick the 'save as file' checkbox
Press the 'Go' button (You'll be prompted where you wish to save the file on your local computer).

No guarantee that this'll avoid a timeout issue, but it'll certainly give you your best shot.

Cheers
Rod