MySQL全库备份脚本

目录

mysql全库备份脚本

vim full_databa_backup.sh#!/bin/shpath="/applica公车使用管理制度tion/mysql/bin:$path"backup1=/backup1backup2=/backup2time=$(date +"%f:%h:%m:%s")ur=rootp异常数据挖掘ass=12345mysql="mysql -u$ur 怎样提升自己的语言表达能力-p$pass"mydump="mysqldump -u$ur -p$pass -a -b -r --master-data=2 --single-transaction"if [ ! -d $backup1 -o ! -d $backup2 ];then    mkdir $backup1    mkdir $backup2    $mydump |gzip >/$backup1/full_${time}.tar.gz    cp $backup1/full_${time}.tar.g张开反义词z $backup2    echo "您好，您的mysql数据已全库备份到${backup2}/full_${time}.tar.gz"el    $mydump |gzip >/$backup1/full_${time}.tar.gz    cp $backup1/full_${time}.tar.gz $backup2    echo "您好，您的mysql数据已全库备份到${backup2}/full_${time}.tar.gz"fi自住房申请条件#生产环境：cp换成rsync再扔到crontab上定时运行