Export 2.3 million subscribers fails

P

Papapooch

Member
I was watching the download progress and at about 50 mb the export failed with "Network Error". I think I have set the maximum settings for exporting.
Exporter settings
Enabled Yes
Records per file 100000
Memory limit 5 GB
Process at once 10000
Pause 2

My server has 30 GB memory.
Not sure what the Memory Limit setting of "System Default" would allow. WOuld it be more than 5 GB?

I am wondering if it is maybe a Command-timeout that is occurring.
Any ideas?
Thanks
 
I will try that.
I see you posted this example command on the forum. It references list_uid.

php -q /the/path/to/apps/console/console.php list-export --list_uid=2hy17d7s52ndy --segment_uid=18nhat166fr16 --folder_path=/the/path/where/you/want/the/file/saved/on/your/server

We wish to export All Subscribers. Is there a list_uid for All?
I looked in the mw_lists table and did not see one.

We have nearly 200 lists.
 
Not a problem. I used HeidiSQL connected to the Mailwizz database remotely from my Windows machine.
The following syntax write to a file in the /var/lib/mysql/mailwizz folder...

select *
INTO OUTFILE 'allsubscribers.csv'
FIELDS TERMINATED BY ','
OPTIONALLY ENCLOSED BY '"'
LINES TERMINATED BY '\n'
from mwv_subscribers_plus

Then I moved the file to the /home/ubuntu folder where I could download it with FileZilla.
 
You must log in or register to reply here.
Back
Top