Backup ALL MySql

BackUpMysql

#!/bin/bash
#your db settings
USER="db_root"
PASS="db_pass"
PATH="/path/to/backup/folder"
HOST="mysql_host"
DATE=`date +%d%m%y%H%M`

#get databases list
databases=`mysql --host=$HOST --user=$USER --password=$PASS -e "SHOW DATABASES;" | tr -d "| " | grep -v Database`

#loop trough results
for db in $databases; do
    #exclude performance_schema and information_schema databases
    if [ "$db" != "performance_schema" ] && [ "$db" != "information_schema" ] ; then
        #dump database, and gzip
        mysqldump -u $USER -p${PASS} $db | gzip > ${PATH}dbbackup_${db}_${DATE}.bak.gz
    fi
done
#remove backups older than 7 days(+7) modify this value if you want.
find /path/to/backup/folder/db* -mtime +7 -exec rm {} \;