Backup and Restore your Azure Database for MySQL - Flexible Server workload | Data Exposed

Imagine coming back after vacationing in Hawaii, all ready to show off the tons of pictures clicked there to friends/family, but only to find your phone malfunctioning. The horror! But thankfully the photos were backed up and you were able to restore them on your new device, all set to bask in the glory of Hawaii all over again. That's the beauty of backup and restore.

Backup and restore is the cornerstone for any enterprise's business continuity and disaster recovery plans. The backup functionality offered by Azure Database for MySQL Flexible Server serves as a doomsday vault safeguarding your data. On the other hand, the restore functionality serves as a life jacket protecting from accidental data deletions and data corruption. In this episode of Data Exposed with Aditi Gupta and Anna Hoffman, learn more about how to use the fastest restore points and geo-redundant backups to fortify your server workloads. Also, get a sneak peek into one of our upcoming feature launches for taking on-demand backups.

0:00 Introduction
1:16 Backup and restore overview
2:36 Demo: Backup and restore
4:53 Demo: Computer & storage
7:53 Demo: On-demand backups

✔️ Resources:

📌 Let's connect:

🔔 Subscribe to our channels for even more SQL tips:

#AzureSQL #AzureDB #mysql #AzureDBMySQL

[besratmekonnen]

For prod env, this is really bad. The issue is that when you restore, it creates a new db server with a new domain. each db domain is linked to its name And since all the webapps are linked using specific db domain, it becomes complicated. you cannot rename a db once its created so only option is to update all the wbapp env variables. it also deletes all your backup history on the newly restored server.

[MsAamirabbas]

Can we backup in one Subscription and restore in another Azure Subscription?

[philipmumford]

What is annoying about azure MySQL flexible server backups is that they can't be easily used to restore a prod DB to the prod instance as mentioned elsewhere. You have to restore to a new instance with a different name!!! What's the point of backups if they can't be used to

[prakashpengoria]

When is the 50 on demand backup gets renewed?