mysql数据库备份与恢复脚本-创新互联

#!/bin/bash

#mysql database backup and restore the script

# define config variable

host=localhost

user=root

passwd=xxxxx

#this variable for grant

mainHostIp="127.0.0.1"

base_path=/opt/disk-webData/mysqlBackup

# base_path=/media/sf_website/yii/disk-webData/mysqlBackup

### backup

backupdb() {

 bak_path=$base_path/$(date +%Y%m%d)/data

 log_path=$base_path/$(date +%Y%m%d)/log

 [ ! -d $bak_path ] && mkdir -p $bak_path

 [ ! -d $log_path ] && mkdir -p $log_path

 dblist=($(mysql -u$user -p$passwd -e "show databases;"|awk -F "|" '{print $1}'|grep -Ev "Database|mysql|information_schema|performance_schema"))

 i=1

 for dbname in "${dblist[@]}"

 do

  echo -e "\n$i --> Backup database $dbname ..."

  file=$bak_path/"$dbname.sql"

  mysqldump -h$host -u$user -p$passwd -B $dbname > $file

  if [ -f $file ];then

   success="$i --> $dbname backup success!"

   echo $success;

   echo $success >> $log_path/backupLog.log

   echo "GRANT ALL PRIVILEGES ON $dbname.* TO admin@localhost;" >> $log_path/grant.log

   echo "GRANT ALL PRIVILEGES ON $dbname.* TO admin@$mainHostIp;" >> $log_path/grant.log

  fi

  let i++

 done

}

#restore

expr 1 + $1 &>/dev/null

if [ $? -eq 0 ];then

 bak_path="$base_path"/$1/data

 log_path="$base_path"/$1/log

 #restore

 cd $bak_path

 dblist=($(ls))

 i=1

 for dbname in "${dblist[@]}"

 do

  echo -e "\n$i --> Restore database $dbname ..."

  mysql -h$host -u$user -p$passwd < $dbname

  success="$i --> $dbname restore success!"

  echo $success

  echo $success >> $log_path/restoreLog.log

  let i++

 done

 #grant

 # if [ -f $log_path/grant.log ];then

  echo "Please ensure that [admin] user exist @[localhost & 127.0.0.1 & mainHostIp]";

  sleep 15s

  ii=1

  cat $log_path/grant.log | while read line

  do

   echo "$ii --> $line"

   mysql -h$host -u$user -p$passwd -e "$line"

   let ii++

  done

 # fi

elif [ "$1" == backup ];then

 backupdb

else

 cd $base_path

 dblist=($(ls))

 i=1;

 echo "Backup history ..."

 for dbname in "${dblist[@]}"

 do

  echo "$i --> $dbname"

  let i++

 done

fi

另外有需要云服务器可以了解下创新互联scvps.cn，海内外云服务器15元起步，三天无理由+7*72小时售后在线，公司持有idc许可证，提供“云服务器、裸金属服务器、高防服务器、香港服务器、美国服务器、虚拟主机、免备案服务器”等云主机租用服务以及企业上云的综合解决方案，具有“安全稳定、简单易用、服务可用性高、性价比高”等特点与优势，专为企业上云打造定制，能够满足用户丰富、多元化的应用场景需求。