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
mingqiCai's avatar
mingqiCai
Copper Contributor
Jul 22, 2025

Hi, I have some problems.

util.dumpInstance("/backup/mysqlsh/mariadb_backup", {threads: 16, showProgress: true, users:false})

NOTE: Backup lock is not supported in MySQL 5.6 and DDL changes will not be blocked. The dump may fail with an error if schema changes are made while dumping.
Acquiring global read lock
Global read lock acquired
Initializing - done
Global read lock has been released
get_string(4): index out of bounds (ArgumentError)

 

These are my system versions.

  • MariaDB: 10.3
  • MySQL: 5.7

(I am using local PC instead of VM on dev env)

 

mysqlsh --version
mysqlsh   Ver 9.3.0 for macos15 on x86_64 - for MySQL 9.3.0 (MySQL Community Server (GPL))

 

Sai_Kondapalli's avatar
Sai_Kondapalli
Icon for Microsoft rankMicrosoft
Jul 28, 2025

mingqiCai​ - Can you share any logs from the time you've run the dump utility? Also version 9.3 of mysqlshell may be incompatible with 10.3 MariaDB, so we suggest you to use MySQL shell version 8.0

Besides, can you try reducing the number of parallel threads from 16 to 4 to see if that alleviates the issue given that your local PC may be resource constrained.