mysql逻辑备份脚本

#File Name: mysql逻辑备份脚本
#Version: V1
#Author: yy
#CREATED  DATE: 2021/02/20
#!/bin/bash
####################################################################################
[ $(id -u) -gt 0 ] && echo -e "\e[31m 请用root用户执行此脚本！\e[0m" && exit 1
###################################定义变量###########################################
#用户信息
user=root
password=vany_mysql@123
dbname=("yanghaoyu","mysql")
#备份日期
Yestaday=`date -d -1day  +"%Y-%m-%d"`
######################################自定函数#########################################
Back_Databases (){
source /etc/profile
for i in ${dbname[@]};
do
#检查目录
	Backup_Directory=/home/backup/$i
	if [ -d $Backup_Directory ];then
		echo "已有目录$i"
	else
		echo "创建目录$i"
		mkdir -p $Backup_Directory
	fi
#开始备份
mysqldump -u$user -p$password $i > $Backup_Directory/$i-$Yestaday.sql
[ $? -gt 0 ] && echo -e "\e[31m 备份失败退出，请检查原因！\e[0m" && exit 1
#删除7天前的旧备份
find $Backup_Directory -mtime +7 -name "*.sql" -exec rm -f {} \;
done
echo "脚本执行时间"
date
}
main (){
Back_Databases
echo "$?"
echo "------------------------------------------------------------------------------"
}
main >> /home/mysql_bak.log