MySQL 自动备份脚本

来源：互联网发布：怎么查看占用的端口号编辑：程序博客网时间：2024/06/05 05:48

# vi /root/backup_mysql.sh #脚本在下方# chmod 744 /root/backup_mysql.sh# crontab -e# 0 */1 * * * /root/backup_mysql.sh

#!/bin/bashUSER="root"PASSWORD="mysql"DATABASE="test"HOSTNAME="192.168.1.50"OPTIONS="-h$HOSTNAME -u$USER -p$PASSWORD $DATABASE"# 备份路径BACKUP_PATH=/home/mysql_backup/# 备份记录路径BACKUP_INFO=/home/mysql_backup/backup_info.log# 备份文件名FILE_NAME=$DATABASE"_"`date '+%Y%m%d_%H%M%S'`.sql# 备份路径不存在则创建if [ ! -d $BACKUP_PATH ] ; thenmkdir -p "$BACKUP_PATH"fi# 开始备份echo " " >> $BACKUP_INFOecho "-----------------------------------------" >> $BACKUP_INFOecho "BACKUP DATE:" $(date +"%y-%m-%d %H:%M:%S") >> $BACKUP_INFOecho "-----------------------------------------" >> $BACKUP_INFOcd $BACKUP_PATHmysqldump $OPTIONS > $FILE_NAMEif [[ $? == 0 ]]; then    tar czvf $FILE_NAME.tgz $FILE_NAME >> $BACKUP_INFO 2>&1    echo "$FILE_NAME.tgz Backup Successful!" >> $BACKUP_INFO    rm -f $FILE_NAMEelse    echo "Database Backup Failed!" >> $BACKUP_INFOfiecho "BACKUP END :" $(date +"%y-%m-%d %H:%M:%S") >> $BACKUP_INFOecho " " >> $BACKUP_INFOecho "Backup Process Done!"

0 0