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

Rajesh V 0 Reputation points
2023-02-26T04:50:50.39+00:00

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.

User's image

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.

User's image

Thanks!

Not Monitored
Not Monitored
Tag not monitored by Microsoft.
35,959 questions
0 comments No comments
{count} votes

2 answers

Sort by: Most helpful
  1. Vinodh247-1375 11,046 Reputation points
    2023-02-26T12:13:59.45+00:00

    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.

    0 comments No comments

  2. Ronen Ariely 15,096 Reputation points
    2023-02-26T12:52:20.6333333+00:00

    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

    0 comments No comments