Page 1 of 1

Skyvia mailchimp to MySQL

Posted: Fri 10 Jun 2016 03:21
by ll2016
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

Re: Skyvia mailchimp to MySQL

Posted: Mon 13 Jun 2016 14:17
by Pinturiccio
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.

Re: Skyvia mailchimp to MySQL

Posted: Sun 19 Jun 2016 23:07
by ll2016
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~

Re: Skyvia mailchimp to MySQL

Posted: Fri 24 Jun 2016 13:12
by Pinturiccio
We have answered you via e-mail.