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
kkkapuq's avatar
kkkapuq
Copper Contributor
Feb 05, 2025

Hi, I have some problems.
These are my system versions.

Ubuntu : 18.04.20

MariaDB : 10.2

MySQL : 8.0

 

I used mysql-shell as snap install (Ubuntu 18.x doesn't work mysql-shell install).

So I ran this script as python, and this error occurred.

Has anyone solved this problem? Only a warning appears in the text, but I get an error.

mysql-py []> util.dump_instance("/backup/mariadb_dump", {"threads": 16, "showProgress": True, "compatibility": ["force_innodb", "strip_definers", "strip_restricted_grants"], "users": False, "ocimds": True})
Acquiring global read lock
Global read lock acquired
Gathering information - done
Global read lock has been released
Traceback (most recent call last):
  File "<string>", line 1, in <module>
mysqlsh.DBError: MySQL Error (1193): Util.dump_instance: Unknown system variable 'GTID_EXECUTED'

 

  • rahulsaha's avatar
    rahulsaha
    Brass Contributor
    Feb 13, 2025

    As confirmed over AzkAzureForMariaDB DL, you upgraded ubuntu version which resolved for you. Thank you for following our blog.