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.
- How can I fix this error?
- Is there a better way to create a sandbox environment for testing WordPress plugins and code?
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
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
Hope you are getting well
For your case where you cannot restore your mysql server whose name is frogmd-wp.mysql.database.azure.com, 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.