mysql++备份目录_mysql 文件夹 备份

引用

#!/bin/sh

USER=root

PASSWORD=admin

DATABASE=cms

WEBMASTER=XX@qq.com

CMS_DIR=/usr/apache-tomcat/webapps/cms

BACKUP_DIR=/var/wtcsg/Data_Backup/mysql/

BACKUP_DIR_TOMCAT=/var/wtcsg/Data_Backup/tomcat/

LOGFILE=/var/wtcsg/Data_Backup/mysql/data_backup.log

#DATE=date +%Y%m%d-%H%M

DATE=$(date +%Y%m%d)

DUMPFILE=DATE

OPTIONS=" --opt --host=127.0.0.1 -u$USER -p$PASSWORD -R --triggers --single-transaction --flush-logs --database $DATABASE "

if [ ! -d $BACKUP_DIR ] ;

then

mkdir -p "$BACKUP_DIR"

fi

if [ ! -d $BACKUP_DIR_TOMCAT ] ;

then

mkdir -p "$BACKUP_DIR_TOMCAT"

fi

echo " " >> $LOGFILE

echo " " >> $LOGFILE

echo "----------------" >> $LOGFILE

echo "BACKUP_MYSQL DATE:" $(date +"%y-%m-%d %H:%M:%S")  >> $LOGFILE

echo "---------------- " >> $LOGFILE

cd $BACKUP_DIR

mysqldump $OPTIONS > data$(date +%Y%m%d).sql

if [[ $? == 0 ]]; then

echo "[$ARCHIVE] Backup_mysql Successful!" >> $LOGFILE

fi

echo " " >> $LOGFILE

echo " " >> $LOGFILE

echo "----------------" >> $LOGFILE

echo "BACKUP_TOMCAT  DATE:" $(date +"%y-%m-%d %H:%M:%S")  >> $LOGFILE

echo "---------------- " >> $LOGFILE

#cp -rf /usr/apache-tomcat/webapps/cms    $BACKUP_DIR_TOMCAT

cd  $BACKUP_DIR_TOMCAT

tar -czf cms$(date +%F).tar.gz  $CMS_DIR

#cd /usr/apache-tomcat/webapps/cms

#tar -czf  BACKUP_DIR_TOMCATcms$(date +%F).tar.gz    $CMS_DIR

echo "[$ARCHIVE] Backup_tomcat Successful!" >> $LOGFILE

echo "Backup Process Done"

--------------------------

chmod +x backup.sh //授权

--------------------------

vi /etc/crontab // 定时服务

# run-parts

01 * * * * root run-parts /etc/cron.hourly

02 4 * * * root run-parts /etc/cron.daily

22 4 * * 0 root run-parts /etc/cron.weekly

42 4 1 * * root run-parts /etc/cron.monthly

--------------------------

service crond restart

----------------------

backup.7z (689 Bytes)

下载次数: 1

分享到：

2012-08-31 10:36

浏览 725

分类:数据库

评论