Skyvia mailchimp to MySQL

Skyvia mailchimp to MySQL

Postby ll2016 » Fri 10 Jun 2016 03:21

Sorry Dev Art,

Another question. I have use Dev art Skyvia to connect my mailchimp to mysql successfully and smaller tables has been replicated successfully. However when Iam replicating the listmembers tables which contain 400k rows, and checking on mysql processlist, the status command has become SLEEP? is that normal? it seems to be not doing anything or its still processing? Have left it for more than 3 hrs now.

Thank you
ll2016
 
Posts: 11
Joined: Tue 31 May 2016 06:12

Re: Skyvia mailchimp to MySQL

Postby Pinturiccio » Mon 13 Jun 2016 14:17

When your package processes a lot of rows the execution time can take several hours or even days. You should wait till the replication is finished.
Pinturiccio
Devart Team
 
Posts: 2044
Joined: Wed 02 Nov 2011 09:44

Re: Skyvia mailchimp to MySQL

Postby ll2016 » Sun 19 Jun 2016 23:07

Hi,

Just a quick question, is there a max columns that the merge tag will get imported to MYSQL from mailchimp? It seems to stop at 50 columns and from the skyvia interface, even when i clicked on "edit task" to get into Task Editor, there are some fields that were not there so it doesnt allow me to choose. I have replicate the table to MYSQL but not all merge tag columns were there eventhough most merge tags were loaded but there were about 5 that wasn't.

Thank you very much~
ll2016
 
Posts: 11
Joined: Tue 31 May 2016 06:12

Re: Skyvia mailchimp to MySQL

Postby Pinturiccio » Fri 24 Jun 2016 13:12

We have answered you via e-mail.
Pinturiccio
Devart Team
 
Posts: 2044
Joined: Wed 02 Nov 2011 09:44


Return to dotConnect for MySQL