Live SQL database import

[hooumeri]

Hi everyone,

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

This is what MailWizz shows:


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:

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?

 

[twisted1919]

@hooumeri - Can we see the import settings ?

 

[hooumeri]

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



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



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!

 

[twisted1919]

@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.

 

[hooumeri]

@twisted1919, no worries, thanks for your reply! I have PM'ed you with the related information. Thank you so much!