Get backup of Azure Database for MySQL single server

Question

Azure Database for MySQL 単一サーバーからフレキシブルサーバーへの自動移行がされており、単一サーバーが停止状態になっています。

単一サーバーの起動ができないのですが、バックアップを取得する方法はあるでしょうか？

Answer 1

@翔太郎 梶
Thank you for the question and for using Microsoft Q&A platform. Microsoft Q&A platform provides support only in English.

As per my understanding you want to migrate your Single server to Flexible server.

As per the document https://learn.microsoft.com/en-us/azure/mysql/migrate/whats-happening-to-mysql-single-server :

Starting 17th September, non-responsive servers which have not yet migrated will be periodically stopped. You'll be required to come to the Azure portal, acknowledge the migration actions and start your server. Once you have started the server, proceed with using the Azure Database for MySQL Import CLI or Azure Data Migration Service to migrate to Azure Database for MySQL - Flexible Server. On the other hand if you wish to proceed with auto-migration, please raise an Azure Support ticket to get the auto-migration scheduled. Ensure to start the server and migrate to Flexible Server to avoid involuntary forced migration later which will lead to server unavailability as only limited features can be migrated.

There are two ways to get a backup of your Single Server:

1. By using the Azure Database for MySQL Import CLI
   https://learn.microsoft.com/en-us/azure/mysql/migrate/migrate-single-flexible-mysql-import-cli
2. You can migrate an instance of Azure Database for MySQL – Single Server to Azure Database for MySQL – Flexible Server by using Azure Database Migration Service (DMS)
   https://learn.microsoft.com/en-us/azure/dms/tutorial-mysql-azure-single-to-flex-online-portal

You can also raise a support ticket for the auto migration to get scheduled. In case if you don't have a support plan, please let us know here.

For more information please refer to the below links:
https://learn.microsoft.com/en-us/azure/mysql/migrate/migrate-single-flexible-mysql-import-cli
https://learn.microsoft.com/en-us/azure/mysql/flexible-server/concepts-migrate-dump-restore
https://learn.microsoft.com/en-us/azure/mysql/migrate/whats-happening-to-mysql-single-server

Hope this helps. Please let us know if you have any further questions.