I had to move my entire Rancher setup to a different worker node. So I did a mysqldump to create a complete copy of the database. I then recreated the Mariadb container, restored matomo database and deployed my Matomo container.
In the UI it said there was already tables and I could only use a different prefix or I could delete the tables. I chose to delete them and then I restored the database again from the same backup shortly after.
Everything in the UI works fine, except I only have data from the last two days. No data from previous segments is showing in the UI.
Inspecting the database, I have:
matomo_archive_blob_2023_01 matomo_archive_numeric_2023_01 matomo_archive_blob_2023_02 matomo_archive_numeric_2023_02 matomo_archive_blob_2023_03 matomo_archive_numeric_2023_03 matomo_archive_blob_2023_04 matomo_archive_numeric_2023_04 matomo_archive_blob_2023_05 matomo_archive_numeric_2023_05
These tables are filled with data.
Does anyone know how I get Matomo to read these tables to show previous weeks/months of data? I’ve lost about 6 months of analytics at the moment.