# Error in query (3105) when importing database backup

**URL:** https://forum.mautic.org/t/error-in-query-3105-when-importing-database-backup/26086
**Category:** Product Support
**Created:** [November 15, 2022, 2:52am UTC](https://forum.mautic.org/t/error-in-query-3105-when-importing-database-backup/26086 "2022-11-15T02:52:45Z")
**Posts on this page:** 1
**Page:** 1

<div class="post-metadata">

### Author: ![avi](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/avi/32/997_2.png) [@avi](https://forum.mautic.org/u/avi)
#### Post date: [November 15, 2022, 2:52am UTC](https://forum.mautic.org/t/error-in-query-3105-when-importing-database-backup/26086/1 "2022-11-15T02:52:46Z")

</div>

**Your software**  
My Mautic version is: 4.3.1  
My PHP version is: 7.4  
My Database type and version is: MariaDB 10.3.34

**Your problem**  
My problem is:  
I am trying to migrate Mautic from one server to another. I dumped my mautic DB using mysqldump, and when I try to import it into the new server using phpmyadmin, I get this error:

```auto
Error in query (3105): The value specified for generated column 'generated_sent_date' in table 'email_stats' is not allowed.

```

From what I read, this is do to virtual generated columns.

Is there any way I can fix the exported db so it imports properly?

Thanks!