You can use quick snapshots if you are using LVM/ZFS snapshot backup.
Solution that you have suggested will also work. Please note that storing backups in the
MySQL server is not recommended.