mysql_backup.sh

#!/bin/bash

mysql_user=user
mysql_pwd=pwd

databases=$(echo "show databases;" | sudo mysql -u "$mysql_user" -p "$mysql_pwd" -B | tail -n +2)
date=$(date +%Y-%m-%d_%H-%M-%S)

for database in $databases;
do
        file=/var/db/backup/$database.$date.sql.gz
        mysqldump -u "$mysql_user" -p "$mysql_pwd" $database | gzip -9 > $file
done

find /var/db/backup/ -mtime +10 -exec rm {} \;