shell定時備份資料庫資訊

標籤：

#!/bin/sh# Database infoDB_USER="batsing"DB_PASS="batsingpw"DB_HOST="localhost"DB_NAME="timepusher"# Others varsBIN_DIR="/usr/bin"            #the mysql bin pathBCK_DIR="/mnt/mysqlBackup"    #the backup file directoryDATE=`date +%F`# TODO# /usr/bin/mysqldump --opt -ubatsing -pbatsingpw -hlocalhost timepusher > /mnt/mysqlBackup/db_`date +%F`.sql$BIN_DIR/mysqldump --opt -u$DB_USER -p$DB_PASS -h$DB_HOST $DB_NAME > $BCK_DIR/db_$DATE.sql#還原資料庫#用mysql-front匯入前一天的 *.sql 檔案即可恢複資料

 

shell定時備份資料庫資訊