Error in query (3105) when importing database backup

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:

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?