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 

Answer 1

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 

Answer 2

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.

Answer 3

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. 

Answer 4

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

Answer 5

Thanks Andrea for the update.

omer_a, please check the latest article on this topic.

Do let us know if you have any questions.