centos下mysql自动备份

最新推荐文章于 2023-11-03 15:25:04 发布

weixin_30847271

最新推荐文章于 2023-11-03 15:25:04 发布

阅读量71

点赞数

CC 4.0 BY-SA版权

原文链接：http://www.cnblogs.com/song-wentao/p/10564992.html

博客主要讲述了创建脚本和定时任务进行MySQL备份时，出现备份文件为0kb的问题。经排查是mysqldump路径文件的问题，修改备份脚本后问题得以解决。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

创建脚本

#!/bin/bash
db_user="root"
db_passwd="root"
db_name="data_center"
#备份目录
backup_dir="/home/backup/mysql"
#时间格式
time=$(date +"%Y-%m-%d")
#mysql 备份的命令，注意有空格和没有空格
mysqldump -u$db_user -p$db_passwd $db_name  > "$backup_dir/$db_name"-"$time.sql"
echo "your database backup successfully completed"
#这里将7天之前的备份文件删掉
SevenDays=$(date -d -7day  +"%Y-%m-%d")
if [ -f /home/backup/mysql/$db_name-$SevenDays.sql ]
then
rm -rf /home/backup/mysql/$db_name-$SevenDays.sql
echo "you have delete 7days ago bak sql file "
else
echo "7days ago bak sql file not exist "
echo "bash complete"
fi

创建定时任务

crontab -e

0 2 * * * cd /root/ && ./data_center.sh

经过测试发现备份出来的文件都是0kb

经过排查是 mysqldump 路径文件

备份脚本改为

#!/bin/bash
db_user="root"
db_passwd="root"
db_name="data_center"
#备份目录
backup_dir="/home/backup/mysql"
#时间格式
time=$(date +"%Y-%m-%d")
#mysql 备份的命令，注意有空格和没有空格
/usr/local/mysql/bin/mysqldump -u$db_user -p$db_passwd $db_name  > "$backup_dir/$db_name"-"$time.sql"
echo "your database backup successfully completed"
#这里将7天之前的备份文件删掉
SevenDays=$(date -d -7day  +"%Y-%m-%d")
if [ -f /home/backup/mysql/$db_name-$SevenDays.sql ]
then
rm -rf /home/backup/mysql/$db_name-$SevenDays.sql
echo "you have delete 7days ago bak sql file "
else
echo "7days ago bak sql file not exist "
echo "bash complete"
fi