# Issues when Exporting / Importing DB in Mautic

**URL:** https://forum.mautic.org/t/issues-when-exporting-importing-db-in-mautic/22639
**Category:** Mautic 4 Install/Upgrade Support
**Created:** [February 8, 2022, 7:06pm UTC](https://forum.mautic.org/t/issues-when-exporting-importing-db-in-mautic/22639 "2022-02-08T19:06:34Z")
**Posts on this page:** 2
**Page:** 1

<div class="post-metadata">

### Author: ![UHLHosting](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/uhlhosting/32/3043_2.png) [@UHLHosting](https://forum.mautic.org/u/UHLHosting)
#### Post date: [February 8, 2022, 7:06pm UTC](https://forum.mautic.org/t/issues-when-exporting-importing-db-in-mautic/22639/1 "2022-02-08T19:06:34Z")

</div>

**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_ :

---

<div class="post-metadata">

### Author: ![andrewchildsza](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/andrewchildsza/32/33_2.png) [@andrewchildsza](https://forum.mautic.org/u/andrewchildsza)
#### Post date: [November 21, 2022, 2:19pm UTC](https://forum.mautic.org/t/issues-when-exporting-importing-db-in-mautic/22639/2 "2022-11-21T14:19:08Z")

</div>

I am having the same issue migrating 4.4.4 to another server:

ERROR 1146 (42S02) at line 21: Table ‘mautic.asset\_downloads’ doesn’t exist

I have the same error.
