Live SQL database import

hooumeri

New Member
Hi everyone,

I'm trying to import a mySQL database, the size is around 1.8 Gb.

This is what MailWizz shows:

Screen Shot 2017-02-26 at 12.50.22.png
There are no mySQL errors on my MailWizz server. On the server where I'm trying to import from, I have the following in the mySQL error log:


Code:
2017-02-26 12:43:01 140158676342816 [Warning] Failed to create a socket for IPv6 '::': errno: 97.
2017-02-26 12:43:01 140158676342816 [Note] Server socket created on IP: '0.0.0.0'.

I don't think it's related though.

MailWizz application log is not showing any errors either. I can see that the column names of the database table have been imported, as they can be seen as the tags of the list, but not one subscriber is successfully imported, just like it's saying, "imported 0 subscribers".

Am I doing something wrong, or maybe the table itself is too large?
 

hooumeri

New Member
Not sure which one you meant, but I have included both of these:

Screen Shot 2017-02-26 at 21.29.53.png

The blank options are correctly set, but I didn't include them here..
Settings for import/export under MailWizz settings:

Screen Shot 2017-02-26 at 21.30.17.png

Looking at these got me thinking.. Do the limits set here also apply for a live database import, in which case the file size limit would become a factor?

EDIT: From the dashboard, I can see that something has happened:
The import process for list "Master" has successfully started, counting 3146816 records!
 
Last edited:

twisted1919

Administrator
Staff member
@hooumeri - Sorry for the late response.
Looking at the above, there should not be any issue with importing. However, i think something hangs somewhere and i am not sure what/where. If you can PM me with all the data ai need to test this and also maybe a FTP login to debug it, then maybe we can fix it.
Otherwise, export a csv from your database and import that in mailwizz.
 
Top