BackupDB

#!/bin/bash
PATH=/etc:/bin:/sbin:/usr/bin:/usr/sbin:/usr/local/bin:/usr/local/sbin

alias mysql='mysql --defaults-file=/root/.my.cnf'
alias mysqldump='mysqldump --defaults-file=/root/.my.cnf'

dest="/root/backup_mysql"
date=$(date +%d-%m-%Y)
time=$(date +%H-%M-%S)

find $dest -type d \( -name "*-1[^5]" -o -name "*-[023]?" \) -ctime +30 -exec rm -R {} \; 2>&1
find $dest -type d -name "*-*" -ctime +180 -exec rm -R {} \; 2>&1
mkdir $dest/"$date" 2>&1

for dbname in $(echo show databases | mysql | grep -v Database); do
    case $dbname in
        information_schema)
            continue ;;
        mysql)
            continue ;;
        performance_schema)
            continue ;;
        test)
            continue ;;
        *) mysqldump --databases --skip-comments --default-character-set=utf8mb4 "$dbname" > $dest/"$date"/"$dbname".sql ;;
# Если нужно архивировать
#         *) mysqldump --databases --skip-comments -u$userDB -p$passwordDB $dbname | gzip > $dest/$fdate/$dbname.sql.gz ;;
    esac
done;

cd $dest/$date || exit
tar -cjpf "$time".tar.bz2 --remove-files --absolute-names "$time"
#rm -rf "${time:?}"/
find $dest/*.tar.bz2 -mtime +30 -delete