archive each DB and upload to onedrive (or other cloud storage) / archive and upload to onedrive (or other cloud storage) the whole /var/www folder

backup.sh

#!/bin/bash
# some inspiration https://mensfeld.pl/2013/04/backup-mysql-dump-all-your-mysql-databases-in-separate-files/
TIMESTAMP=$(date +"%F")
BACKUP_DIR="/root/backupdb/$TIMESTAMP"
MYSQL_USER=""
MYSQL=/usr/bin/mysql
MYSQL_PASSWORD=""
MYSQLDUMP=/usr/bin/mysqldump

mkdir -p "$BACKUP_DIR"

databases=`$MYSQL --user=$MYSQL_USER -p$MYSQL_PASSWORD -e "SHOW DATABASES;" | grep -Ev "(Database|information_schema|performance_schema|mysql)"`

for db in $databases; do
    $MYSQLDUMP --user=$MYSQL_USER -p$MYSQL_PASSWORD --single-transaction --skip-lock-tables --databases $db | gzip > "$BACKUP_DIR/$db.gz"
done

rclone copy /root/backupdb/ onedrive:backup/dbs/

rm -rf /root/backupdb/*

zip -rq "$TIMESTAMP".zip /var/www/*
rclone copy "$TIMESTAMP".zip onedrive:backup/files/
rm "$TIMESTAMP".zip