Very slow migration

[voko]

I'm migrating a site with log data and archives from a local instance to a WAN/internet host.
For e very low traffic site (< 3 k visits over two years), it takes more than 18 hours, which seems a tad too slow.

Any suggestions on where I should look or tune the mysql or other settings?

Config:
Source: LAMP with piwik 2.14.3 on centos 6.5
Target: bitnami-piwik 2.14.3 on ubuntu 14.04. LTS

[Undergrounder]

I have problems with migrations and some others shell related tasks when xdebug is enabled. Maybe this can help.

[shivateja-madipalli]

Even I have similar issue, what could be the solution pls help.

[datenimperator]

Migrating a site with ~600.000 visits and ~3.000.000 actions runs for 23 hours now and doesn't seem to be finished any time soon. Network throughput between the hosts is more than 50MB/sec, data is coming in at ~ 100k/sec. This doesn't look right.

[Undergrounder]

Be careful with the migration.
We lost many data because of this bug (#22).

[datenimperator]

Too late. I did not assume any critical flaws here, given that it's from Piwik Pro. We do have a ~800MB SQL.gz backup of our Piwik database but migration doesn't seem to work nonetheless.