Using MySQL, Percona xtrabackup is very helpful. We do daily backups that are exported to multiple cloud and local storage via rsync and a commercial backup app

Using MySQL, Percona xtrabackup is very helpful. We do daily backups that are exported to multiple cloud and local storage via rsync and a commercial backup application. We have a fully automated script that can recreate the db from one of these backups in a single command so it can be tested on a regular basis.