Hi,
I am attempting to migrate the database from MariaDB 10.5.23 to MySQL 8.0.36. I have followed the instructions outlined in https://docs.nextcloud.com/server/latest/admin_manual/maintenance/backup.html#backup-database.
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