#!/bin/bash
#-----------------------------------------------------------------------------
# Author:Bathing
# Function:This script will be used for mysql backups,It was created by Bathing.
# Date:2021-07-22
# QQinfo:576590916
# work on Mysql_5.7
#-----------------------------------------------------------------------------
#设置颜色显示
SETCOLOR_SUCCESS="echo -en \\033[0;32m"
SETCOLOR_FAILURE="echo -en \\033[0;31m"
SETCOLOR_WARNING="echo -en \\033[0;33m"
SETCOLOR_NORMAL="echo -en \\033[0;39m"
#设置登陆变量
MY_USER=""
MY_PASS=""
MY_PORT=""
MY_HOST="localhost"
#mysql安装目录
name=/www/server/mysql
#user
USER=`whoami`
#备份的数据库名,可定义多个数据库,中间以空格隔开,如: (test test1 test2)
dbname=()
#备份路径
backpath=${name}/backup
#备份的时间
DATA=$(date +%Y%m%d-%H%M)
#日志备份路径
logpath=${name}/log
#脚本运行账号为root账户
ACCOUNT_JUDGE_FUN () {
if [ "$(whoami)" != "root" ];then
${SETCOLOR_WARNING} && echo "warning:please use root account install cloudroom system!" && ${SETCOLOR_NORMAL}
exit 1
fi
}
ACCOUNT_JUDGE_FUN
#创建备份路径
mkdir -p ${logpath}
chown -R mysql:mysql ${logpath}
mkdir -p ${backpath}
touch ${logpath}/mysqlbackup.log
#开始备份数据库
for db in ${dbname[*]}; do
/usr/bin/mysqldump -u${MY_USER} -h${MY_HOST} -P${MY_PORT} -p${MY_PASS} --single-transaction ${dbname} > ${backpath}/${db}-${DATA}.sql 2>/dev/null
#备份成功以下操作
if [ "$?" == 0 ];then
cd ${backpath}
#备份日志记录
echo ================================================ >> ${logpath}/mysqlbackup.log
echo 备份时间为${DATA},开始备份${db}数据库...>> ${logpath}/mysqlbackup.log
#为节约硬盘空间，将数据库压缩
tar zcf ${db}${DATA}.tar.gz ${db}-${DATA}.sql > /dev/null
#删除原始文件，只留压缩后文件
rm -f ${backpath}/${db}-${DATA}.sql
echo The mysql database is backed up successfully!! >> ${logpath}/mysqlbackup.log
echo ================================================ >> ${logpath}/mysqlbackup.log
else
#备份失败则进行以下操作
echo Failed to back up the mysql database. Procedure!! >> ${logpath}/mysqlbackup.log
echo ================================================ >> ${logpath}/mysqlbackup.log
fi
done
#保留7天的数据备份
find ${backpath} -mtime +7 -name "*.gz" -exec rm -rf {} \;