Migration of Matomo

Hi there, we are migrating Matomo from a RHEL 6.9 32 bit OS to a RHEL 7.4 64 bit OS and are running into some errors after logging in.

We have version matched Matomo on both servers, then copied the database from old to new.

This is one error we are getting.

SQLSTATE[42S02]: Base table or view not found: 1146 Table ‘analytics.piwik_archive_numeric_2019_04’ doesn’t exist

That is the only issue we have run into. Has anyone else seen this issue before?

Just to be sure: This table does exist in the old installation and does not in the new?