db_backup.sh

#!/bin/bash

DEST=/root/backup/databases
CURRDATE=$(date +"%F")

HOSTNAME=$(hostname)

USER="root"
PASS="$(cat /root/backup/pass)"

DATABASES=$(mysql -u $USER -p$PASS -e "SHOW DATABASES;" | tr -d "| " | grep -v Database)

if [ ! -d $DEST ]; then
	mkdir -p $DEST
fi

for db in $DATABASES; do
	FILE="${DEST}/$db-${CURRDATE}.sql.gz"
	FILEDATE=
	
	if [ -f $FILE ]; then
		FILEDATE=$(date -r $FILE +"%F")
	fi

	[ "$FILEDATE" == "$CURRDATE" ] && continue

	[ -f $FILE ] && mv "$FILE" "${FILE}.old"
	mysqldump --single-transaction --routines --quick -u $USER -p$PASS -B $db | gzip > "$FILE"
done