mysql backup

gistfile1.sh

bin/      bind.sql
root@syzyf:~# cat /root/bin/mysql-backup.sh
#!/bin/bash -x

NOW=$(date +"%F")
NOWT=$(date +"%T")

## Backup path ##
BAK="/var/spool/mysql_local/$NOW"
[ -d $BAK ] || mkdir $BAK

MUSER=""
MPASS=""
MHOST=""

MYSQL="/usr/bin/mysql"
MYSQLDUMP="/usr/bin/mysqldump"
GZIP="/bin/gzip"

DBS="$($MYSQL -u $MUSER -h $MHOST -Bse 'show databases')"
#DBS="oauth"
for db in $DBS
do
 FILE="$BAK/$db-$NOWT.sql.gz"
 $MYSQLDUMP -u $MUSER -h $MHOST $db | $GZIP -9 > $FILE
done