#!/bin/bash

echo ">> Backup mysql start on " $(date)
echo "Full backup"

mysqldump --defaults-extra-file=./.my.cnf -u root --all-databases | gzip > /data/backup/weekly/db/all_databases-$(date +\%a).sql.gz

echo "Individual backup"

for DB in $(cat /data/backup/scripts/databases.txt)
do
    mysqldump --defaults-extra-file=./.my.cnf -u root $DB | gzip > /data/backup/weekly/db/$DB-$(date +\%a).sql.gz
done

echo "###### END #####"