backup non system mysql databases for rsnapshot to pickup with a backup user

database_backup.sh

#!/bin/bash

OUTPUT_DIR=/root
BACKUP_USER=backupuser
BACKUP_DIR=/home/backupuser/

# Identify the databases on this server
databases=$(mysql -s -r -N -e 'show databases where `Database` not in("information_schema", "performance_schema", "accounts", "mysql", "sys")')

for database in $databases; do
    mysqldump --single-transaction --skip-lock-tables "$database" | gzip > "$OUTPUT_DIR/$database".sql.gz
    chown "$BACKUP_USER" "$OUTPUT_DIR/$database".sql.gz
    mv "$OUTPUT_DIR/$database".sql.gz "$BACKUP_DIR"
done