cron定时备份数据库

#!/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 {} \; 

# crontab -e

0 0 * * * /home/ltden/auto_backup/ltden_backup.sh

# crontab -l