mysql数据库备份shell脚本,珍藏,以备后用
这个会自动备份并压缩成gz格式,需要不压缩的请自行修改。
#/bin/bash
# author george zheng <xinhaozheng@gmail.com>
# 2012 – 03 – 12
# version 1.2
MYUSER=”username”
MYPASS=”password”
HOST=”localhost”
DATE=$(date -I)
NAME=$(date +%Y%m%d-%H%M%S)
BACKUPDIR=”/home/mysqlbak”
[ ! -d $BACKUPDIR ] && mkdir -p $BACKUPDIR
DBS=`mysql -u$MYUSER -p$MYPASS -Bse “show databases”|grep -v “information_schema” |grep -v “test” | grep -v “mysql” `
echo “Backuping mysql datebase , please waiting…”
for db_name in $DBS
do
echo “Backup datebase $db_name …”
[ ! -d $BACKUPDIR/$DATE ] && mkdir -p $BACKUPDIR/$DATE
mysqldump –default-character-set utf8 -u$MYUSER -p$MYPASS -h$HOST $db_name |gzip > $BACKUPDIR/$DATE/$db_name$NAME.sql.gz
done
echo “Backup mysql datebase finished.” |