# Database Migration MariaDB to MySQL

**URL:** <https://help.nextcloud.com/t/database-migration-mariadb-to-mysql/184512>\
**Category:** ℹ️ Support\
**Created:** [March 7, 2024, 6:19am UTC](https://help.nextcloud.com/t/database-migration-mariadb-to-mysql/184512 "2024-03-07T06:19:11Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![gabglus](https://help.nextcloud.com/letter_avatar/gabglus/32/6_449c533f586939b6e5f246632a46421f.png) [@gabglus](https://help.nextcloud.com/u/gabglus)\
**Post date:** [March 7, 2024, 6:19am UTC](https://help.nextcloud.com/t/database-migration-mariadb-to-mysql/184512/1 "2024-03-07T06:19:12Z")

</div>

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](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

---

<div class="post-metadata">

**Author:** ![wwe](https://help.nextcloud.com/user_avatar/help.nextcloud.com/wwe/32/72963_2.png) [@wwe](https://help.nextcloud.com/u/wwe)\
**Post date:** [January 16, 2025, 8:39am UTC](https://help.nextcloud.com/t/database-migration-mariadb-to-mysql/184512/2 "2025-01-16T08:39:33Z")

</div>


