mysql-backup.sh

#!/bin/bash
BACKUP_DIR="/opt/backup/mysql-backup"

MYSQL_USR="root"
MYSQL_PWD="your-password"
MYSQL_CMD=/usr/bin/mysql
MYSQL_DMP=/usr/bin/mysqldump


databases=`$MYSQL_CMD --user=$MYSQL_USR -p$MYSQL_PWD -e "SHOW DATABASES;" | grep -Ev "(Database|information_schema|performance_schema)"`

for db in $databases; do
 echo "Dumping $db ..."
 $MYSQL_DMP --force --opt --user=$MYSQL_USR -p$MYSQL_PWD --databases $db | gzip > "$BACKUP_DIR/$db.gz"
done

echo "-- DONE!"