If you wish to exclude files under a particular directory, simply creating a
pertinent subvolume containing those files in place of the directory allows to
exclude them to be a part of the snapshot
operation.
Please consider to set 'no copy on write' (C) attribute recursively on the directory prior to placing files such as the database file in it. For example:
$ sudo chattr -R +C /var/lib/mysql
I suppose that you need to stop database program before making snapshot/backup of the filesystem containing it.
Maybe the same goes with the actively used disk image file.
To use rsync.net, we need to set up ssh keys.
For rsync.net service, following should help you recover the last data, use
rsync
as:
$ mkdir -p ~/oldrsync
$ cd ~/oldrsync
$ rsync -a [email protected]:rsync .
$ ls -laR
To recover the older backup data, use rsync
as:
$ rsync -a [email protected]:.zfs/snapshot/daily_2022-01-01 .
For list of available older backups
$ ssh [email protected] ls -lsa .zfs/snapshot