Asked by:
how to export Azure Database for MySQL server to blob and can i keep the backup for over 35 days in blob and still be able to restore it?

Question
-
how to export Azure Database for MySQL server to blob from azure cli ?
can i keep the backup for over 35 days in blob and still be able to restore it ? if so how to do ut from azure cli ?
i have tried via az sql db export command but i am confused about what is : storage-key-type, name and storage-key that it seems to be obligatory parameters in this command
- Moved by SadiqhAhmed-MSFTMicrosoft employee Thursday, August 8, 2019 10:48 AM Better suited in mysql forum
All replies
-
i want to save the Azure Database for MySQL server backup in my storage account so that it will be available for restore , the main goal is to save db for more than 35 days
- Merged by SadiqhAhmed-MSFTMicrosoft employee Thursday, August 8, 2019 10:53 AM Similar query
-
Hello omer_a
Exporting a back up to blob storage is currently not supported.
If you have a VM running in Azure, you can follow the instructions here and copy the back up file to a storage account.
If you want to export specific tables, I would recommend Azure Data Factory. A tutorial is here.
Please let us know if you have further questions.
- Proposed as answer by Kalyan Chanumolu-MSFTMicrosoft employee, Moderator Tuesday, August 13, 2019 4:31 PM
- Unproposed as answer by Kalyan Chanumolu-MSFTMicrosoft employee, Moderator Monday, September 9, 2019 4:43 AM
-
Just checking in to see if the above answer(s) helped.
If this answers your query, do click “Mark as Answer” and Up-Vote for the same which might be beneficial to other community members reading this thread .
And, if you have any further query do let us know.
-
Does this help? https://techcommunity.microsoft.com/t5/Azure-Database-for-MySQL/Backup-Azure-Database-for-MySQL-to-a-Blob-Storage/ba-p/803830
Thanks,
Andrea Lam
Program Manager, Azure DB for MySQL
- Edited by Andrea LamMicrosoft employee Monday, August 19, 2019 8:31 PM
- Proposed as answer by Kalyan Chanumolu-MSFTMicrosoft employee, Moderator Monday, September 9, 2019 4:43 AM
-