At this moment I have Piwik installed locally for each of my sites. Now I would like to move those sites to a single Piwik installation.
I have installed Piwik onto a new server, and have moved the first site. Not everything went right as my database import overwrote my initial installation (i.e. superuser data).
Now I wonder about moving additional sites to this installation. I thought:
- Create a new site and use the new tracking code, so old installation does not receive any more data.
- Migrate the data from the old server to merge it with the data on the new one.
My concern now is the part 2. and how to ensure that only the data about the site that is migrated is merged, not to overwrite anything.
From this perspective, which tables from MySQL are to be imported into the new Piwik installation (new tracking already running), and how to ensure that the data is merged in the right way?