#!/bin/bash

USER=’root’
PASSWORD=’pass’
OUTPUTDIR=’/path/mysql-backup’
MYSQLDUMP=’/usr/bin/mysqldump’
MYSQL=’/usr/bin/mysql’

# rm -f $OUTPUTDIR/*

databases=`$MYSQL -–user=$USER -–password=$PASSWORD -e ‘SHOW DATABASES;’ | grep -Ev ‘(Database|information_schema)’`

for db in $databases; do
$MYSQLDUMP -–opt -–hex-blob -–force -–user=$USER -–password=$PASSWORD $db | gzip > $OUTPUTDIR/$db.gz
done