Issues when Exporting / Importing DB in Mautic

Your software
My PHP version is : 7.4
My MySQL/MariaDB version is (delete as applicable): 10.3.32-MariaDB-0ubuntu0.20.04.1

Updating/Installing Errors
I am : Installing / Migrating
Upgrading/installing via (delete as applicable) : Command Line

These errors are showing in the installer : No errors were shown!

These errors are showing in the Mautic log :

Your problem
My problem is : I am unable to import an SQL dump into Mautic 4.1.2 . Tried several ways and all failed:

First attempt
ERROR 1005 (HY000) at line 25: Can't create table mautic.asset_downloads (errno: 150 "Foreign key constraint is incorrectly formed")

Second attempt
ERROR 1146 (42S02) at line 21: Table 'mautic.asset_downloads' doesn't exist

We are migrating from another server, to a newly deployed Mautic 4.1.2.

The old server was installed since version 2.x and we upgraded when new releases were made on time. So now both servers are in same version, yet the SQL dumps seems to fail when exporting/importing them into new Mautic server.

Steps I have tried to fix the problem :