Azure database for MySQL restore function throwing errors

Category: azure database for mysql


FrogMD on Wed, 27 Dec 2017 18:04:31

I am trying to create a sandbox environment to test out code without affecting the users who are visiting our production site. I figured that I needed to duplicate my MySQL database to allow for this functionality. However, when I tried to "restore" the database to a previous version (I tried anywhere for 12 hours ago up till 5 minutes ago), I receive notifications that the process has failed.

  1. How can I fix this error?
  2. Is there a better way to create a sandbox environment for testing WordPress plugins and code?

Steve Hwang


MohitGarg_MSFT on Wed, 27 Dec 2017 23:54:08

Thanks for reaching out. I am able to repro the issue reported above. I am trying to contact required team to check on the error and will let you know once I have more information regarding it.

Saloni Sonpal on Thu, 28 Dec 2017 00:13:50

Hi Steve,

If you could share certain details with me, that would help us debug the issue. From the screenshot, it's hard to see the:

  • server name
  • SKU and compute units
  • creation time
  • restore attempt time

If you could email it to me on saloni(dot)sonpal(at)microsoft(dot)com, the engineering team here can take a look.



Hong Wang – MSFT on Fri, 29 Dec 2017 03:32:19

Hi frogmd


Hope you are getting well

For your case where you cannot restore your mysql server whose name is, actually this is one of our known bugs.


We found that the restored source server ‘frogmd-wp’ is not a newly created one, instead it is restored from other server. In such case, if you try to restore a new server from the ‘frogmd-wp’ server, it will hit our bug and fail.


We have done some mitigated steps for your server,  so the restore operation from ‘frogmd-wp’ with time point AFTER the 2017-12-28 11:06:02 UTC time.


If you still want to do the restore operation for ‘frogmd-wp’ BEFORE 2017-12-28 11:06:02 UTC time, please raise support case with the time point you want to restore, we will handle the restore for you.