#!/bin/sh

PATH=/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin
BACKUP_PATH=/var/backups

umask 077

for i in $(mysql --defaults-file=/etc/mysql/debian.cnf -N --batch -e 'SHOW DATABASES;') ; do
	mysqldump --defaults-file=/etc/mysql/debian.cnf --opt "$i" | gzip -c > "$BACKUP_PATH/mysqldump_db_${i}.gz"
done

mysqldump --defaults-file=/etc/mysql/debian.cnf --all-databases | gzip -c > "$BACKUP_PATH/mysqldump_all.gz"

exit 0
