基于CentOS的MySQL学习补充五--使用Shell备份(mysqldump)MySQL数据库

时间仓促，直接给出Shell脚本：

#!/bin/bash

##########################################################################
# FileName:		back_nursing.sh
#
# Description:	full back-up database 'nursing'
#
# Author:		chisj
#
# Created Date:	2015.12.31
##########################################################################

#The username of mysql database
USER="root"

#The password of mysql database
PASS="123456"

#The database name will be granted 
DATABASE="test"

#The host name of whii be created use for database
HOST="localhost"

#备份路径
BackDir="/develop/chisj/mysql_backup"

#备份全路径
FullBackup=$BackDir/full_backup

#备份的文件名
BackFile=${DATABASE}.sql

#备份日志的文件名
BackLog="full_backup.log"

#创建备份文件夹
mkdir -p $FullBackup/$(date +%Y%m%d)

#开始备份，记录备份开始时间
echo '=========='$(date +"%Y-%m-%d %H:%M:%S")'=========='"备份开始">>$FullBackup/$BackLog

`which mysqldump` -u $USER -p$PASS --single-transaction --flush-logs \
	--databases $DATABASE > $FullBackup/$(date +%Y%m%d)/$BackFile


#压缩备份文件
gzip $FullBackup/$(date +%Y%m%d)/$BackFile

#备份完成，记录备份完成时间
echo '=========='$(date +"%Y-%m-%d %H:%M:%S")'=========='"备份完成">>$FullBackup/$BackLog