Database Migration MariaDB to MySQL


I am attempting to migrate the database from MariaDB 10.5.23 to MySQL 8.0.36. I have followed the instructions outlined in

However, upon restoring the backup in MySQL, I encountered the following error:

ERROR 1101 (42000) at line 769: BLOB, TEXT, GEOMETRY, or JSON column ‘health’ can’t have a default value

resulting in the termination of the restoration process.

Upon investigation, it appears that the issue is related to default values in LONGTEXT fields. I am seeking guidance on how to address this problem and successfully complete the restoration process.

Thank you in advance.

Best regards, Gabriel