MySQL / MSSQL can produce database backups to the local disk using built in tools. How to make Duplicati backup those backup files to the remote server?
Is it possible to run pre-backup scripts to backup the SQL databases and then send them to the remote server?
Basically, How to do SQL backups with Duplicati? Thank you.
That is what I do. A small bash script that calls mysqldump is run using the --before-script (I think that’s the option flag) flag. I also ended up increasing the script timeout.
So if you need to create an MS SQL backup you just need to check the appropriate database from the sources and you are care-free for flushing buffers etc?
Aren’t there any extra options involved apart from snapshot policy → required to be sure that the backup is taken correctly?