Merge two databases with piwik tracking data

Hi,

We have encountered a problem when trying to merge tracking data from Instance A (that tracks 5 sites with IDs 1-5) to Instance B (that tracks the same 5 sites with the same IDs plus 4 more). We’d like to move previous data from Instance A to Instance B. We tried mysqldump and database import in phpmyadmin but conflicts occurred for example in piwik_log_link_visit_action table and others because of id_xy fields. Is there any supported method to bring over data without having to reset Instance B’s database?
Thanks,

Aayushya

1 Like

i too would like to know if this is possible as i find myself with the same problem.

Maybe this plugin can help: http://plugins.piwik.org/SiteMigration ?