Transfer of data between two installations possible?

Support & Bugs
1

Hey,
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!

Karsten

2

Yes you can move the piwik_archive_XX tables for the websites you wish to move and it might just work.

First, make sure you run the archive.php script to archive everything

http://piwik.org/setup-auto-archiving/