Blog Post

Azure Database for MySQL Blog
7 MIN READ

Migrating from Azure Database for MariaDB to Azure Database for MySQL using MySQL Shell

rahulsaha's avatar
rahulsaha
Brass Contributor
Jun 02, 2023

Are you ready to make the switch from Azure Database for MariaDB to Azure Database for MySQL? Our latest blog post provides a comprehensive guide to help you navigate this transition seamlessly. Learn how to use MySQL Shell for logical backup and restore, and get step-by-step instructions for both offline and online migration processes.

MariaDB is the open-source relational database management system created by MySQL’s original developers. MariaDB is designed to be highly compatible with MySQL. It supports the same SQL syntax, data ...
1_Dump_Restore.png
Updated May 05, 2025
Version 7.0
Tom Burton's avatar
Tom Burton
Copper Contributor
Mar 08, 2024

I'm having trouble with getting the replication going.  How are you getting the information required for '<binlog-file>' and <binlog position>?  I've tried to get this information from the source using "show binary logs;" just before doing a dumpInstance but get the error "ERROR 1381 (HY000): You are not using binary logging".  When I do "SHOW VARIABLES LIKE 'log_bin';" it reports that the variable is OFF; but there is no way to access that server parameter in the Azure Portal and even if there was there is no way to restart the MariaDB service.

 

UPDATE: I think I've found the way around this.  I created a replica of the MariaDB service, leaving it deploying for long enough for log_bin to be set.  I then cancelled the deployment and was able to show the binary logs and binlog events.