哞丫哞

建立一script,設權限為755

#!/bin/bash

#要備份的DB清單

BACKUP_LIST="/home/back_list"

#要備份到什麼地方

BACKUP_PATH="/home/Backup_DB"

BACKUP_TIME=`date +%Y%m%d_%H`
BACKUP_FOLDER=BACKUP_PATH/BACKUP_TIME

if [! -d BACKUP_FOLDER ]; then
    /bin/mkdir -p BACKUP_FOLDER
fi

#== LOG ==
echo BACKUP_TIME >> BACKUP_PATH/log

TIME_START=`date +%s` #現在時間換算成秒數

cat BACKUP_LIST while read DB
do

                                        #-p 後面接密碼為123456 設定為utf8格式
    /usr/bin/mysqldump -u root -p123456 --default-character-set=UTF8 DB > BACKUP_FOLDER/DB.sql
    if [ ? -ne "0" ]; then
        #== LOG ==
        echo "  [ERROR] "DB  >> BACKUP_PATH/errorlog
    fi
done

TIME_END=`date +%s`
TIME_TOTAL=((TIME_END-TIME_START))

#== LOG ==
echo "  [TIME] "TIME_TOTAL" /sec" >> BACKUP_PATH/log

cd BACKUP_PATH
tar zcvf BACKUP_TIME.tar.gz BACKUP_TIME &> /dev/null (如果有錯誤訊息送到虛無設備/dev/null 直接丟棄不會顯示在營幕上)
if [ ? -eq "0" ]; then
    if [ -d BACKUP_TIME ]; then
        rm -rf BACKUP_TIME
    fi
fi

======================================

接著就設定排程讓它跑吧