rclone_sqlbackup_cronjob.sh

#!/usr/bin/env bash

# drop into /usr/local/

# RUn rclone copy all incremental backups at (/home/backups) to remote cloud e.g. gdrive, mega etc.
# This file is dropped in by /~https://github.com/josephgodwinkimani/cyberpanel at /usr/local/CyberCP

TIMESTAMP=$(date +"%Y-%m-%d")

MYSQL=/usr/bin/mysql

MYSQLDUMP=/usr/bin/mysqldump

# edit me
MYSQL_USER=root

# Read MySQL password from the specified file
MYSQL_PASSWORD=$(< /etc/cyberpanel/mysqlPassword)

# Check if the password was read successfully
if [[ -z "$MYSQL_PASSWORD" ]]; then
    echo "Error: Unable to read MySQL password from /etc/cyberpanel/mysqlPassword."
    exit 1
fi

# edit me e.g. /home/backups/sql
BACKUP_DIR=""

$MYSQLDUMP --user=$MYSQL_USER -p$MYSQL_PASSWORD --all-databases | gzip > "$BACKUP_DIR/backup-$TIMESTAMP.sql.gz"

# If you are only copying a small number of files (or are filtering most of the files) and/or have a large number of files on the destination then 
# --no-traverse will stop rclone listing the destination and save time.

rclone copy --no-traverse "$BACKUP_DIR/backup-$TIMESTAMP.sql.gz" remote:backup/sql