创建目录
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执行备份任务