Mysql data imported OK, but nothing showing in the dashboard

Your software
My Mautic version is: Moving from old 4.10 installation to new intallation with 5.02
My PHP version is: 8.1
My Database type and version is: Mariadb 10

Your problem
My problem is:

Data and contacts not showing after export from 4.10 installation, and import into new installation running 5.02. Export dumped 900MB, new intall via Softaculous with no errors. Login OK with empty tables.

I then imported the 900MB sql file using PHPMyAdmin via CLI using the command mysql -u root -p -h localhost databasename < dumpfile.sql

Import went smoothly, No errors.

The tables in the new installation are populated OK, and reflect the tables in the 4.10 installation.

However, there is no data, contacts, etc showing in the new dashboard of the 5.02 installation.

Everything in the new installation looks fine, and I can add new contacts, which then show up in Contacts.

However, none of contacts from the 900MB are showing, anywhere.

These errors are showing in the log:

There are no error logs in /var/logs/

Steps I have tried to fix the problem:

Cleared cache with rm -rf var/cache/*

Made sure all the ownerships are correct, as far as I am aware.

The parameters in local.php such as database, user, password, are all correct.

I’m not a mysql expert, but I think it may have something to do with the schema?

Any ideas, pointers would be appreciated.