Azure – how to export Azure Database for MySQL server to blob

azureazure-sqldatabase

is there a way to export Azure Database for MySQL server to a blob or a container ? my main goal is to keep the backup for over 35 days in blob/container and still be able to restore it after?
i want to be able to save backups in the cloud and with azure tools , cli/power shell/ job so that i want need to do so on my own in common tools (mysqldump etc…)

Best Answer

You have built-in backup in Azure Database for MySQL https://docs.microsoft.com/en-us/azure/mysql/howto-restore-server-portal

But if you really want export to Azure Storage then I would recommend Data Factory.

Here is some documentation on connection Data factory and Azure MySQL. https://docs.microsoft.com/en-us/azure/data-factory/connector-azure-database-for-MySQL

You can then either run it on schedule or trigger it with .Net or Python SKD , REST api or Powershell.

Related Solutions

Mysql – How to sync a subset of tables between two databases on the same thesql database server

If your end goal is to separate the servers then I would suggest running a separate instance on a different port and using standard replicaton between the two

quick google turns out this

alternatively you can use triggers to replicate, something along the lines of

CREATE TRIGGER replicatetable AFTER INSERT ON db1.table
  FOR EACH ROW BEGIN
    INSERT INTO db2.table(field1,field2, ...) values (db1.table.field1,db1.table.field2, ...);
  END;

similar for UPDATE and DELETE

Linux – How to i create in incremental backups of thesql databases

Very simple: binlogging. Configure mysql to keep the binary log for at least one day (possibly longer). Then change your backup to not do mysqldump, but use something like xtrabackup.

That way you can reduce your backup schedule to once per day and still have the possibility to roll forward to any point in time using the binlog.

Best Answer

Related Solutions

Mysql – How to sync a subset of tables between two databases on the same thesql database server

Linux – How to i create in incremental backups of thesql databases

Related Topic