Merge two databases with piwik tracking data


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?


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: ?