求一个自动恢复MYSQL的脚本
7813
- lonefly2018-11-30金牌会员62530
根据军哥的自动备份脚本,再备份机上自动恢复MYSQL数据库的脚本
- #!/bin/bash
- - #Funciont: Backup website and mysql database
- #Author: licess
- #Website: https://lnmp.org
- - #IMPORTANT!!!Please Setting the following Values!
- - Backup_Home="/home/backup/"
- MySQL_Dump="/usr/local/mysql/bin/mysqldump"
- ######~Set Directory you want to backup~######
- Backup_Dir=("/home/wwwroot/vpser.net" "/home/wwwroot/lnmp.org")
- - ######~Set MySQL Database you want to backup~######
- Backup_Database=("lnmp" "vpser")
- - ######~Set MySQL UserName and password~######
- MYSQL_UserName='root'
- MYSQL_PassWord='yourrootpassword'
- - ######~Enable Ftp Backup~######
- Enable_FTP=0
- # 0: enable; 1: disable
- ######~Set FTP Information~######
- FTP_Host='1.2.3.4'
- FTP_Username='vpser.net'
- FTP_Password='yourftppassword'
- FTP_Dir="backup"
- - #Values Setting END!
- - TodayWWWBackup=www-*-$(date +"%Y%m%d").tar.gz
- TodayDBBackup=db-*-$(date +"%Y%m%d").sql
- OldWWWBackup=www-*-$(date -d -3day +"%Y%m%d").tar.gz
- OldDBBackup=db-*-$(date -d -3day +"%Y%m%d").sql
- - Backup_Dir()
- {
- Backup_Path=$1
- Dir_Name=
echo ${Backup_Path##*/} - Pre_Dir=
echo ${Backup_Path}|sed 's/'${Dir_Name}'//g' - tar zcf ${Backup_Home}www-${Dir_Name}-$(date +"%Y%m%d").tar.gz -C ${Pre_Dir} ${Dir_Name}
- }
- Backup_Sql()
- {
- ${MySQL_Dump} -u$MYSQL_UserName -p$MYSQL_PassWord $1 > ${Backup_Home}db-$1-$(date +"%Y%m%d").sql
- }
- - if [ ! -f ${MySQL_Dump} ]; then
- echo "mysqldump command not found.please check your setting."
- exit 1
- fi
- - if [ ! -d ${Backup_Home} ]; then
- mkdir -p ${Backup_Home}
- fi
- - if [ ${Enable_FTP} = 0 ]; then
- type lftp >/dev/null 2>&1 || { echo >&2 "lftp command not found. Install: centos:yum install lftp,debian/ubuntu:apt-get install lftp."; }
- fi
- - echo "Backup website files..."
- for dd in ${Backup_Dir[@]};do
- Backup_Dir ${dd}
- done
- - echo "Backup Databases..."
- for db in ${Backup_Database[@]};do
- Backup_Sql ${db}
- done
- - echo "Delete old backup files..."
- rm -f ${Backup_Home}${OldWWWBackup}
- rm -f ${Backup_Home}${OldDBBackup}
- - if [ ${Enable_FTP} = 0 ]; then
- echo "Uploading backup files to ftp..."
- cd ${Backup_Home}
- lftp ${FTP_Host} -u ${FTP_Username},${FTP_Password} 复制代码