#! /Bin/bash
# Shell command for backup MySQL database everyday automatically by crontab
# Author: linsong
# Date: 2011-10-11
Service mysqld stop
Filedate = 'date + % Y % m % d'
Mkdir-P/home/backup/$ filedate
Tar-zcvf/home/backup/$ filedate/web.tar.gz/var/www/html/web/
Tar-zcvf/home/backup/$ filedate/mysql.tar.gz/var/lib/MySQL/
Chown-r www: www/home/backup/$ filedate
Rm-RF/etc/httpd/CONF/httpd-for-backup.conf
Echo "<virtualhost *: 80>">/etc/httpd/CONF/httpd-for-backup.conf
Echo "serveradmin webmaster@dummy-host.example.com">/etc/httpd/CONF/httpd-for-backup.conf
Echo "DocumentRoot/home/backup/$ filedate">/etc/httpd/CONF/httpd-for-backup.conf
Echo "servername download.web.com">/etc/httpd/CONF/httpd-for-backup.conf
Echo "errorlog logs/download.web.com-error_log">/etc/httpd/CONF/httpd-for-backup.conf
Echo "customlog logs/download.web.com-access_log common">/etc/httpd/CONF/httpd-for-backup.conf
Echo "</virtualhost>">/etc/httpd/CONF/httpd-for-backup.conf
Service mysqld start
Service httpd restart