mysql全量备份脚本

最新推荐文章于 2024-08-16 14:30:25 发布

jimmylsp

最新推荐文章于 2024-08-16 14:30:25 发布

阅读量687

点赞数

本文链接：https://blog.csdn.net/jimmylsp/article/details/68489598

版权

#!/bin/sh
# Program
# use mysqldump to Fully backup mysql data per week!
# History
# 2013-04-27 guo first
# Path
# ....
BakDir=/drosin/backup/mysql
LogFile=/drosin/backup/mysql/bak.log
Date=`date +%Y%m%d`
DATA3=`date -d "3 days ago" +%Y%m%d`
rm -f $BakDir/$DATA3.sql.tgz
Begin=`date +"%Y年%m月%d日 %H:%M:%S"`
cd $BakDir
DumpFile=$Date.sql
GZDumpFile=$Date.sql.tgz
#/drosin/mysql/bin/mysqldump -uroot -pmysql --quick --all-databases --flush-logs --delete-master-logs --single-transaction > $DumpFile
/drosin/mysql/bin/mysqldump -uroot -pmysql --databases ylzhmh > $DumpFile
/bin/tar czvf $GZDumpFile $DumpFile
/bin/rm $DumpFile

scp $BakDir/$GZDumpFile root@10.176.4.104:$BakDir

Last=`date +"%Y年%m月%d日 %H:%M:%S"`
echo $GZDumpFile --- 开始:$Begin 结束:$Last $GZDumpFile >> $LogFile
#cd $BakDir/daily
#rm -f $GZDumpFile