mysql---数据库备份脚本

CHY2403

已于 2024-01-26 15:22:36 修改

阅读量390

点赞数 13

分类专栏： mysql 文章标签：数据库 mysql adb

于 2024-01-11 17:59:20 首次发布

本文链接：https://blog.csdn.net/caohaiye/article/details/135535833

版权

mysql 专栏收录该内容

1 篇文章 0 订阅

订阅专栏


ADDRESS="ip"

PORT="端口"

USER="用户名"

PASSWORD="密码"

DATABASE1="数据库名"

DATE=`date +%Y%m%d-%H%M`  

DEL_DATE=$(date -d -7days '+%Y%m%d-%H%M')  

cur_month_time=$(date '+%Y-%m')          

BACKUP_DIR="{保存路径}/$cur_month_time"  

LOGFILE="{错误日志}"    

DUMPFILE1="数据库名-$DATE.sql"              

ARCHIVE1="$DUMPFILE1.gz"                

DEL_ARCHIVE="数据库名-$DEL_DATE.sql.gz"    



if [ ! -d $BACKUP_DIR ];      

then

mkdir -p "$BACKUP_DIR"

fi



echo -e "\n" >> $LOGFILE  

echo "------------------------------------" >> $LOGFILE  

echo "BACKUP DATE:$DATE">> $LOGFILE  

echo "------------------------------------" >> $LOGFILE  



cd $BACKUP_DIR                            

mysqldump -h$ADDRESS -P$PORT -u$USER -p$PASSWORD $DATABASE1 > $DUMPFILE1    



if [[ $? == 0 ]]; then

tar czvf $ARCHIVE1 $DUMPFILE1 >> $LOGFILE 2>&1          

echo "$ARCHIVE1 BACKUP SUCCESSFUL!" >> $LOGFILE  

rm -f $DUMPFILE1

echo "$DUMPFILE1 DEl SUCCESSFUL!" >> $LOGFILE

rm -f $DEL_ARCHIVE

echo "$DEL_ARCHIVE DEl SUCCESSFUL!" >> $LOGFILE  

else  

echo "$ARCHIVE1 Backup Fail!" >> $LOGFILE  

fi