Restored a DB - Data not Displaying


#1

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?


#2

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!