CENTOS 定时备份MYSQL数据库并压缩文件

创建目录

cd /home

mkdir backup

cd backup

创建备份脚本

vim DatabaseName.sh

name=helc_$(date +%Y%m%d_%H%M%S);
folder=$(date +%Y%m);
if [ ! -d "/home/backup/$folder/" ];then
mkdir /home/backup/$folder
/usr/local/mysql/bin/mysqldump -uUserName -pPassWord@ helc > /home/backup/$folder/$name.sql
cd /home/backup/$folder/
zip -r $name.zip ./$name.sql
rm -rf $name.sql
else
/usr/local/mysql/bin/mysqldump -uUserName -pPassWord@ helc > /home/backup/$folder/$name.sql
cd /home/backup/$folder/
zip -r $name.zip ./$name.sql
rm -rf $name.sql
fi

脚本定期运行

crontab -e

01   23 * * * root/home/backup/DatabaseName.sh

每天23点01执行备份任务