mysqldump备份脚本一例

最新推荐文章于 2025-09-06 22:56:13 发布

weixin_30268921

最新推荐文章于 2025-09-06 22:56:13 发布

阅读量60

点赞数

CC 4.0 BY-SA版权

文章标签：数据库

原文链接：http://www.cnblogs.com/Clark-cloud-database/p/7813362.html

本文分享了一个MySQL全库备份的Shell脚本，该脚本能够实现完整的数据库备份，并自动清理过期备份文件。脚本中包含了详细的参数配置，如备份路径、日志文件等。

参考三思老师书中所写，感觉挺好用，记录下来，虽然是抄袭，但是手抄还是很累的,其中用到的其他脚本，在博客中已经记录：

mysql_full_backup.sh
#!/bin/sh
#Created by Clark 201710131716

source /data/mysqldata/scripts/mysql_env.ini

DATA_PATH=/data/mysqldata/backup/mysql_full
DATA_FILE=${DATA_PATH}/dbfullbak_`date +%F`.sql.gz
LOG_FILE=${DATA_PATH}/dbfullbak_`date +%F`.log
MYSQL_PATH=/usr/local/mysql/bin
MYSQL_DUMP="${MYSQL_PATH}/mysqldump -u${MYSQL_USER} -p${MYSQL_PASS} -S /data/mysqldata/${HOST_PORT}/mysql.sock -A -R -x --default-ch
aracter-set=utf8"

echo > $LOG_FILE
echo -e "=== Jobs started at `date +%F' '%T' '%w` ====\n" >>$LOG_FILE
${MYSQL_DUMP} | gzip > $DATA_FILE
echo -e "*** Excuted finshed at `date +%F' '%T' '%w`====" >>$LOG_FILE
echo -e "*** Backup file size: ` du -sh ${DATA_FILE}`====\n" >>$LOG_FILE

echo -e "---- Find expired backup and delete those files ----" >>${LOG_FILE}
for tfile in $(/bin/find $DATA_PATH/ -mtime +6)
do
if [ -d $tfile ] ; then
rmdir $tfile
elif [ -f $tfile ] ; then
rm -f $tfile
fi
echo -e "---- Delete file:$tfile -----" >> ${LOG_FILE}
done

echo -e "\n==== Jobs ends at `date +%F' '%T' '%w` ====\n" >> $LOG_FILE