1.HTTP和MYSQL的日志及mysql的数据库备份

[root@best11 crontab]# vi wemy.sh
#!/bin/bash
a=`date +%Y_%m_%d`
b=`date +%Y_%m_%d –date ’7 days ago’`
service httpd stop
tar zcvf /web/backup/$a.web.tar.gz /date/web/
rm -rf /web/backup/$b.web.tar.gz
mysqldump -uuser -ppassword –opt AA > /date/backup/$a.AA.sql
rm -rf /web/backup/$b.AA.sql
service mysql restart
mysql -uuser -ppassword -e ‘PURGE MASTER LOGS BEFORE DATE_SUB( NOW( ), INTERVAL 7 DAY)’
service httpd start
sleep 60
rm -rf /date/apache_logs/error_log-$b
rm -rf /date/apache_logs/$b.access.log

注：http.conf
ErrorLog “|/usr/local/apache2/bin/rotatelogs /web/apache_logs/error_log-%Y_%m_%d 86400 480″
CustomLog “|/usr/local/apache2/bin/rotatelogs /web/apache_logs/%Y_%m_%d.access.log 86400 480″ combined