目錄
- MySQL全庫備份腳本
MySQL全庫備份腳本
vim full_database_backup.sh
#!/bin/sh
PATH="/application/mysql/bin:$PATH"
BACKUP1=/backup1
BACKUP2=/backup2
TIME=$(date +"%F:%H:%M:%S")
USER=root
PASS=12345
MYSQL="mysql -u$USER -p$PASS"
MYDUMP="mysqldump -u$USER -p$PASS -A -B -R --master-data=https://www.cnblogs.com/yanyanqaq/p/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.gz $BACKUP2
echo "您好，您的MySQL資料已全庫備份到${BACKUP2}/FULL_${TIME}.tar.gz"
else
$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上定時運行
轉載請註明出處，本文鏈接：https://www.uj5u.com/caozuo/89797.html
標籤：Linux