backup_db.sh

#!/bin/bash

USER="root"
PASSWORD=""
OUTPUT="/tmp/dbbackup/"
DATE=`date +%Y-%m-%d_%H-%M`
FOLDER="$OUTPUT"

rm -rf "$FOLDER"
mkdir "$OUTPUT"
mkdir "$FOLDER"
#rm "$FOLDER/*gz" > /dev/null 2>&1

databases=`mysql -u $USER -e "SHOW DATABASES;" | tr -d "| " | grep -v Database`

for db in $databases; do
    if [[ "$db" != "information_schema" ]] && [[ "$db" != "performance_schema" ]] && [[ "$db" != "mysql" ]] && [[ "$db" != _* ]] ; then
        echo "Dumping database: $db"
        mysqldump -u $USER --databases $db > $FOLDER/$db.sql
        echo "Compressing database: $db"
        gzip $FOLDER/$db.sql
    fi
done