mysqldump定时备份数据库

Black:)

已于 2024-06-28 15:24:36 修改

阅读量243

点赞数 3

分类专栏：中间件文章标签：数据库

于 2024-06-28 15:20:14 首次发布

本文链接：https://blog.csdn.net/Black794/article/details/140044013

版权

中间件专栏收录该内容

6 篇文章 0 订阅

订阅专栏

mysqldump定时备份数据库

#!/bin/bash  
CONTAINER_NAME_OR_ID='mysql'  
MYSQL_USER='root'
MYSQL_PASSWORD='123456' 
DB_NAME='XXX'
SAVE_TIME=$(date "+%Y%m%d%H%M")
DIR="/opt/backup_mysql"
if [ ! -d "$DIR" ];then
	mkdir $DIR
	echo "创建文件夹成功"
else
	echo "文件夹已经存在"
fi
BACKUP_FILE="/opt/backup_mysql/${DB_NAME}_${SAVE_TIME}.sql"
echo $MYSQL_PASSWORD | docker exec -i $CONTAINER_NAME_OR_ID mysqldump -u$MYSQL_USER -p $DB_NAME > $BACKUP_FILE
if [ $? -eq 0 ]; then
	echo "Backup completed successfully: $BACKUP_FILE"
else
	echo "Backup failed"
fi

添加定时任务crontab -e

*    *    *    *    *
-    -    -    -    -
|    |    |    |    |
|    |    |    |    +----------星期中星期几 (0 - 6) (星期天 为0)
|    |    |    +---------------月份 (1 - 12) 
|    |    +--------------------一个月中的第几天 (1 - 31)
|    +-------------------------小时 (0 - 23)
+------------------------------分钟 (0 - 59)

添加定时任务(每天06:18执行)
18 6 * * * /opt/backup_mysql/backup_mysql.sh