Skyvia mailchimp to MySQL

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for MySQL
Post Reply
ll2016
Posts: 11
Joined: Tue 31 May 2016 06:12

Skyvia mailchimp to MySQL

Post by 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

Pinturiccio
Devart Team
Posts: 2420
Joined: Wed 02 Nov 2011 09:44

Re: Skyvia mailchimp to MySQL

Post by 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.

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

Re: Skyvia mailchimp to MySQL

Post by 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~

Pinturiccio
Devart Team
Posts: 2420
Joined: Wed 02 Nov 2011 09:44

Re: Skyvia mailchimp to MySQL

Post by Pinturiccio » Fri 24 Jun 2016 13:12

We have answered you via e-mail.

Post Reply