My VM Reset issue.
We have our webserver and database hosted on Azure VM machines, with MySQL installed on one of them. Recently, we encountered an issue where the database became corrupted. We requested Azure to restore a backup from a date when everything was functioning correctly. Azure performs daily backups of the entire machine and restored an old backup on a separate machine. We assumed the database would be intact since the backup was from an earlier date.
However, the issue persists.
So, my questions are:
How exactly does the VM take a backup of the entire machine?
Does it reference the existing machine while restoring on a new VM machine?
How can I obtain the correct restored database files?