How to show the list of mysql restore points?

Category: azure database for mysql

Question

evilripper2017 on Mon, 05 Mar 2018 10:17:42


How to show the list of mysql restore-point-in-time from cli or web interface? In the result of show command there aren't the restore points! I read the doc but it's not clear!

https://docs.microsoft.com/en-us/azure/mysql/scripts/sample-pitr-restore

I found how to restore a db but how I retrieve for ex. the date? "2018-02-11T13:10:00Z", I need it to use --restore-point-in-time. I try to find the list of restore-point-in-time, where is?



Replies

Andrea Lam on Wed, 07 Mar 2018 06:18:41


Backups are taken automatically by the service (ref: https://docs.microsoft.com/en-us/azure/mysql/howto-restore-server-cli#backup-happens-automatically). The service restores to the closest backup available to the time you provide in your command. 

Thanks,

Andrea Lam

Program Manager

Azure Data Group