cron定时备份数据库
1.定时备份数据库 shell 脚本
#!/bin/bash # export and backup the abgent_web database.sql mysqldump -uusername -ppassword wuxi_ltd_cn --skip-lock-tables > /home/www/ltd_cn/auto_backup/database.sql #zip the code and database.sql cd /home/www/ltd_cn/auto_backup/ tar -zcvf /home/www/ltd_cn/auto_backup/wuxi_ltd_cn$(date +%Y%m%d%H%M).tar.gz database.sql #delete the abgent_web database.sql rm -f /home/www/ltd_cn/auto_backup/database.sql #delete backup zip 90 days ago DAYS=90 find /home/www/ltd_cn/auto_backup/ -name "wuxi_ltd_cn*" -type f -mtime +$DAYS -exec rm {} \;
2.创建crontab
# crontab -e
0 0 * * * /home/ltden/auto_backup/ltden_backup.sh
# crontab -l