#!/bin/bash
# databases=( '__DATABASE_1__' '__DATABASE_2__' )
databases=()
db_host="localhost"
db_port="3306"
db_user="backups"
db_pass=""
backups_dir="/home/backups/db/"
backups_user="backups"

datetime=$(date +'%Y-%m-%dT%H:%M:%S')

for db_name in ${databases[@]}; do
        mysqldump -u $db_user -h $db_host -P $db_port --password=$db_pass $db_name | gzip -9 > $backups_dir$db_name--$datetime.sql.gz
done

chown $backups_user:$backups_user $backups_dir*--$datetime.sql.gz
chmod 0400 $backups_dir*--$datetime.sql.gz