[原创]MYSQL周期备份shell脚本

最新推荐文章于 2022-09-18 01:00:00 发布

weixin_30679823

最新推荐文章于 2022-09-18 01:00:00 发布

阅读量123

点赞数

CC 4.0 BY-SA版权

文章标签：数据库 shell

原文链接：http://www.cnblogs.com/wsjhk/p/6909393.html

本文介绍了一个用于阿里云MySQL数据库的全量周期备份Shell脚本，该脚本能够根据当前日期将备份文件存放到不同的目录下，并且每周的数据备份会按星期分开存放。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

这个脚本是实现阿里云mysql数据库全量周期备份的shell脚本，实现备份数据按一周星期几分开存放。一下是脚本内容：

#!/bin/bash

echo `date`
echo "backup begin!!!"

DATE1=`date +%Y%m%d%H%M%S`
DATE2=`date +%w`
BACKUPDIR="/data/backup/backupdir/"
BACKUPPATH="/data/backup"
BACKUPNAME="/data/backup/backup_${DATE1}.tar.gz"

NAME=`mysql -hrdsabcdefghijklmnopqrstuvwxyz.mysql.rds.aliyuncs.com -uusername -ppassword <<EOF
show databases;
exit
EOF`
for dbname in $NAME;do
	if [ "$dbname" = "Database" ];then
		echo "The 'Database' is not a database."
	else
		mysqldump -hrdsabcdefghijklmnopqrstuvwxyz.mysql.rds.aliyuncs.com -uusername -ppassword $dbname > $BACKUPDIR${dbname}.sql

	fi
done

cd $BACKUPDIR
tar zcf $BACKUPNAME *

echo `date`
echo "backup over!!!"

case $DATE2 in

1) mv $BACKUPNAME $BACKUPPATH/1;;
2) mv $BACKUPNAME $BACKUPPATH/2;;
3) mv $BACKUPNAME $BACKUPPATH/3;;
4) mv $BACKUPNAME $BACKUPPATH/4;;
5) mv $BACKUPNAME $BACKUPPATH/5;;
6) mv $BACKUPNAME $BACKUPPATH/6;;
0) mv $BACKUPNAME $BACKUPPATH/7;;
*) echo $DATE2;;

esac
cd $BACKUPDIR
rm -rf *

echo `date`
echo "Over!!!"

转载于:https://www.cnblogs.com/wsjhk/p/6909393.html