We had to move to a new server and I restored a db from an sql dump.
Upon restore, the old data isn’t visible on Matomo. The only table that seems to be working propers is the “Goals” table.
I manually pre-pended the matomo_ name to the front of the tables. The old db had piwik_ prepended.
Things still aren’t showing up though. Any idea why?
I think I figured it out. The matomo_site table has a column “ts_created”. Once this is updated by adding a date from the earliest data, it shows up!
1 Like