I’m in the process of transferring all data for a single site, from one Matomo instance to another. We cant’t use log data for the process, as we keep only the last week in the DB (we accumulate ~100GB per week on log tables), so I have to work with the archive tables.
In short, we dump the archive tables using a where clause for the site, and then in the other database we restore that data by inserting it row by row in the destination archive tables.
The problem is the dashboard and reports do not recognize this new information, showing only ‘there is no data for this report’.
Is there something we are missing in this process?
If you can point me in the right direction for handling the archive data, it would be great!