Blog Post

Azure Database for MySQL Blog
9 MIN READ

Migrating from Azure Database for MariaDB to Azure Database for MySQL using MyDumper/MyLoader

AnojThomas's avatar
AnojThomas
Icon for Microsoft rankMicrosoft
Apr 17, 2025

This blog provides essential guidance for making the transition from Azure Database for MariaDB that is retiring September 2025, to Azure Database for MySQL smoothly using MyDumper/MyLoader + Replication. Learn how to perform key migration steps, ensure minimal downtime, and enhance your digital presence with Azure Database for MySQL - Flexible Server.

MariaDB, the open-source relational database management system created by MySQL’s original developers, is designed to be highly compatible with MySQL. It supports the same SQL syntax, data types, and...
Updated Apr 16, 2025
Version 1.0
mariadb
jdcowpland's avatar
jdcowpland
Copper Contributor
May 07, 2025

I tried to follow these steps, only Azure have deprecated MySQL 5.7, so I had to use MySQL 8.0. Hit an error on myloader:

Variable 'sql_mode' can't be set to the value of 'NO_AUTO_CREATE_USER'
/*!40101 SET SQL_MODE='NO_AUTO_VALUE_ON_ZERO,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION'*/;

 

Any ideas on how to proceed?

jdcowpland's avatar
jdcowpland
Copper Contributor
May 07, 2025

For anyone else hitting this issue, MySQL dropped support for 'NO_AUTO_CREATE_USER' in 8.0.

I ran 

sed -i 's/NO_AUTO_CREATE_USER//' *.sql

within my backup folder to remove it from all my .sql dump files, and that allowed me to proceed.