I am facing an issue to create MYSQL single server from source server using Georestore with the help of Azure CLI

Question

When i am trying to create Mysql single server with Georestore in Azure CLI it was throwing error says that my subscription doesn't have the source server.

The Servers are showing up in the portal but still i am getting this error while creating another server.

Can anyone help me to sort this issue.

Thanks!

Answer 1

Hi

Thanks for reaching out to Microsoft Q&A.

Can you double check the subscription does contain the resource that it says is missing? the error states that its simply missing or there is a typo. Try creating the same from azure portal instead of CLI and if still the same issue I would suggest you to create a case with ms support.

Please Upvote and Accept as answer if the reply was helpful, this will be helpful to other community members.

Answer 2

Hi,

I notice two (potential) issues

(1) This command "az mysql server georestore" Geo-restore a MySQL server from backup, but the name of the source server to restore from in your command is testsqlserver012. It seems like you try to restore SQL Server backup to MySQL service and these are totally two different product (assuming that the name makes sense and related to the backup source).

https://learn.microsoft.com/en-us/cli/azure/mysql/server?view=azure-cli-latest&WT.mc_id=DP-MVP-5001699#az-mysql-server-georestore

(2) As the message informa you, you don't have any MySQL service backup with this name "testsqlserver012". If this is SQL Server backup then it makes sense that the command will not find it as MySQL, and other option is simply that you have no such backup.

Make sure that you have such backup for MySQL with that name