we have an Piwik 1.7 installation tracking ~20 sites. Now, I have to extract all data of 5 from these sites and import them into a second Piwik installation.
Has anyone done this before? Is there a script for that, or do I have to extract the data manually?
My idea was to dump all data from tables piwik_archive_* containing the concerining idsites and insert them into the new DB. (Same with all other tables containing a idsite.)
I am unsure regards table piwik_log_action, because it does not contain an idsite.
Any tips or advises would be fantastic!