mysql脚本备份

1.mysql备份脚本
#说明：此备份脚本是mysql部署在宿主机上，然后直接使用mysql命令备份。
#!/bin/bash
#mysql_backup####
dbuser="root"
dbpassword="123443"
dbserver="172.16.33.52"
dbname="openser"
#dbname_callcenter="callcenter"
# the directory for story your backup file.
back_dir="/app/mysql_backup/"
# date format for backup file (dd-mm-yyyy)
time="$(date +"%d-%m-%Y")"
# mysql, mysqldump and some other bin's path
MKDIR="/bin/mkdir"
RM="/bin/rm"
MV="/bin/mv"
GZIP="/bin/gzip"
# get all databases
cd /usr/bin
/usr/bin/mysqldump -u $dbuser -p$dbpassword --default-character-set=utf8 --opt -R -E $dbname | $GZIP -9 > "$back_dir$time$dbname.gz"
#/usr/bin/mysqldump -u $dbuser -p$dbpassword --default-character-set=utf8 --opt -R -E $dbname_callcenter | $GZIP -9 > "$back_dir$time$dbname_callcenter.gz"

###delete 7 days ago data
find $back_dir -name "*openser.gz" -mtime +7 -exec rm -rf {} \;
#find $back_dir -name "*callcenter.gz" -mtime +7 -exec rm -rf {} \;