#!/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 "" >> /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 "" >> /etc/httpd/conf/httpd-for-backup.conf
service mysqld start
service httpd restart
本文介绍了一个使用Shell脚本自动备份MySQL数据库及网站文件的方法。通过crontab定时任务,该脚本能够每天自动执行,备份内容包括数据库和网站文件,并将其压缩存档。此外,还配置了Apache服务器以便访问这些备份文件。
33万+

被折叠的 条评论
为什么被折叠?



