注意:直接生成gz压缩文件,不会生成压缩前文件
1. db_backup.sh文件
(此处我把mysqldump使用的数据库用户名密码已填写在/etc/f中了,避免产生那个密码安全警告日志)
#!/bin/bash# crontab is very special for init $PATH, and python3 is in /usr/local/bin/. source /etc/profile can import it# or Absolute path (just like " /usr/local/bin/python3 ...... " )#echo $PATHsource /etc/profile# 定期备份sql文件db_name=dashboard_db#db_user=root#db_passwd=123456ip=`ifconfig eth0 | grep "inet" | awk '{ print $2}' | awk 'NR==1{print}'`today=`date -d today +%Y-%m-%d`sql_file_name=$ip"_dashboard_db_"$today".sql"gz_name=$sql_file_name".gz"dir=/root/dashboard/dashboard_db/cronjob_db_backup/#mysqldump -u$db_user -p$db_passwd $db_name | gzip > $dir$gz_namemysqldump $db_name | gzip > $dir$gz_name
在/etc/f中添加(不是立即生效的,需要重启(而且重启后如果起不来说明配置错了!!))
[mysqldump]user=rootpassword=123456
2. crontab -e 编辑
(每天凌晨3点备份)
# 定期备份sql文件0 3 * * * /root/dashboard/dashboard_cronjob/db_backup.sh 2>> /root/dashboard/dashboard_cronjob/db_backup.log