Transitioning from Database Dump Files to Restic for More Efficient Backups

What I used to do in order to back up some MariaDB databases for example was to have a script something like this called regularly

!!! Insecure file overwrite problem here if attacker can create their own /srv/backup/mariadb/all.sql.gz.new file. Should use secure temp file instead

The old way involves creating intermediary dump files which are then backed up, creating unnecessary storage overhead and potential security issues

Restic allows backing up database files directly without the intermediate dump step, improving both security and efficiency