MySQL数据库备份脚本

#!/bin/sh

v_rm_day=`date -d "-5 days" +"%Y%m%d"`

rm -f /data/backupdb/mysql/back_mysql.$v_rm_day*.sql.gz
rm -f /alidata/projects/scripts/backup_shell/logs/remote_mysql/backup_$v_rm_day.log

today=`date -d today +"%Y%m%d"`
nowHour=`date -d today +"%Y%m%d%H"`
now=`date -d today +"%Y%m%d_%H_%M_%S"`

ip='127.0.0.1'
port=3306

user_mysql='admin'
user_password='123456'

##数据库名称

database='plan_admin'

gzip_file='/data/backupdb/mysql/back_mysql.'$nowHour'.sql.gz'
log_file='/alidata/projects/scripts/backup_shell/logs/remote_mysql/backup_'$today'.log'

 ##写入日志，打包成zip包

echo `date` >> $log_file
echo /alidata/server/mysql/bin/mysqldump --host=$ip --port=$port --user=$user_mysql --password=$user_password --databases $database >> $log_file

/alidata/server/mysql/bin/mysqldump --host=$ip --port=$port --user=$user_mysql --password=$user_password --databases $database | gzip > $gzip_file

echo >> $log_file