Mysql - 自动备份脚本

Mysql - 自动备份脚本

Max.Bai

2019-05

 

自动备份数据库，每天备份一次，保留最近7天备份文件

#！/bin/bash
# mysqldump.sh

dbuser='root'   #数据库用户
dbpasswd='123123'   #数据库密码
dbname='dbname'     #需要备份的数据库

backup_dir=/home/data/backup/mysql/   # 备份路径
fileprefix=dbname-         # 备份文件名前缀
backup_file=$backup_dir$fileprefix`date -d now +%Y%m%d`.sql
tar_file=$backup_dir$fileprefix`date -d now +%Y%m%d`.tar.gz

logfile=/home/data/backup/mysql/mysqlbackup.log
logtmp=/home/data/backup/mysql/mybackup.tmp

[ ! -d $backup_dir ] && mkdir $backupdir     #check backup dir exists

echo $backup_file >> $logfile

# ----- start backup -----
echo "start backup..." >> $logfile
mysqldump -u$dbuser -p$dbpasswd $dbname -F >$backup_file
tar czvf $tar_file $backup_file
echo "backup success!" >> $logfile
rm -rf $bac