Azure Database for MySQL topics

Backup and restore the Azure Database for MySQL flexible server

CarwynLuong — Tue, 13 Jan 2026 02:19:17 GMT

Hi everyone,

I’m running into an issue while performing a geo-restore for an Azure MySQL Flexible Server using Azure CLI and Portal.

When executing the az mysql flexible-server geo-restore command, the restore process fails with the error “InvalidAdminLoginPassword: The AdministratorLoginPassword cannot be empty or null”. I don’t see any administrator password configuration option in the Azure Portal, and there is also no auto-populated argument in the CLI. According to the official documentation, geo-restore uses the source server as the restore point, so the administrator login configuration is expected to be derived from the source server. Are there any recommended best practices for handling admin credentials securely during geo-restore? Thanks in advance for your insights.

I used this official doc as a reference, flexible-server/how-to-restore-server-portal

Optimizing Azure Database for MySQL and Ensuring Compatibility with SIM-Based Authentication

chmianshahzaib — Thu, 30 Jan 2025 11:43:14 GMT

"I'm setting up Azure Database for MySQL and need some guidance on optimizing performance for high-traffic applications. Are there best practices for indexing and query optimization to avoid slowdowns?

Also, does anyone know if using a cloud-based MySQL instance affects SIM-based authentication methods? I'm specifically working with Dito SIM and want to ensure compatibility.

Any insights would be greatly appreciated!"

Read Replica for DR with Failback

Paul_Lynch — Fri, 24 Nov 2023 09:16:11 GMT

Hi,

I have been experimenting with Azure MySQL Flexible Server Read Replica as a DR scenario and it works really well. The manual failover process is successful.

However, I am now trying to configure a failback scenario whereby I reconfigure the now standalone MySQL Read Replica server in the DR region to enable geo-redundant backup storage and then I try to initiate a Universal Geo Restore of this server to a different Azure region.

The Geo Restore operation fails with the following error :

"The resource operation completed with terminal provisioning state 'Failed'"

The MySQL Flexible servers (source and Read Replica) are configured for Private Networking (VNet Integration not Private Endpoint) and the Virtual Networks are peered. They both use the same Private DNS Zone which is linked to both VNets as well.

It feels like this *should* work but I can't figure out why it is failing.

If anyone has any insight it would be appreciated.

Regards,

Paul Lynch

azure database MySQL

PabloMaboya — Wed, 16 Nov 2022 20:18:51 GMT

How do i link and my MySQL database locally and to the Microsoft Azure

Keep Previous RowCounts in a table - T-SQL

Wesley27 — Wed, 19 May 2021 11:06:04 GMT

I am currently able to get the rowcount for each table in a schema. On this particular database history is not stored, so each day when I run this script, the counts are likely to differ. What I need to do is somehow keep a record of what the counts for each table were on previous dates. Is there a way I can do this using T-SQL - I can't seem to figure out how to approach this. Also CDC is disabled - so I am limited to having to script a solution using T-SQL. The table I get daily simply lists schema, tablename and rowcount - rowcount is realtime. I would like to keep previous counts associated with a date so result will produce a table with - schema, tablename RowCount_19May, RowCount_18May, RowCount_17May, ... , RowCount_1May. Even if i need to start today and the append each new days counts as the days go by is expected and I'd be good with that.

Azure Web App Backup Failing

cooksiecooks — Mon, 04 May 2020 02:19:41 GMT

Good day

Would require help.

We do have a Web App that uses Azure DB for MySQL. When attempting to do a backup, we keep failing and getting this error message

MySqlDump exited with code -1 for db:db. See partial dump in storage account to diagnose the issue. Exception:-- Retrieving rows...

Check that Web App and DB are running.

Creating Database , Using SQL Or Java . How as I'm New

ايمان صديق — Wed, 15 Apr 2020 21:46:40 GMT

I hope to learn the way to create a database , using Azure SQL or Java , a s I'm new for using programming.

ETL from SQL Server into Azure SQL managed instance

pile_of_beans — Thu, 21 Nov 2019 21:20:30 GMT

Normally I use linked servers to connect my datawarehouse database to other databases to do my ETL using stored procedures that were scheduled. But now, we are moving to Azure managed SQL server. Is there an easy way to do things like run stored procedures that will pick data from source and move into destination SQL data warehouse database? If linked servers is not available then that makes it kind of hard to code SP's that pick from source. I started looking into Azure pipes, but was wondering if there is an easier way that is more compatible with the way I have been doing it in the past....

AWS RDS MySQL migration to Azure Database for MySQL

TrevineCooray — Mon, 22 Jul 2019 05:26:40 GMT

Hi,

The current setup of MySQL on AWS uses the following features/services, what are the possible ways to address the following requirements without third-party tools/services;

A way to execute backup and restore process, the relevant backups in Azure Database (SaaS) via automated restoration script.
A copy of the online database backup to be exported for on-premise restoration.
The database connectivity be able to Allow/Block port and IP.

Thank you.

Replicate datas from Azure DB for mysql to azure SQL DB

BenoitG — Fri, 29 Mar 2019 16:30:17 GMT

Hi,

First I'm happy to create the first new conversation there :)

We could not find on azure application or configuration to replicate and synchronize datas from Azure DB for mysql to azure SQL DB. It looks an option not available natively.

Does anyone have experience or can we recommend tools to implement this synchronization on azure?

Thank a lot,

Ben