每日備份資料

每個人的習慣不盡相同 這裡僅記著老人家習慣的作法

Thank you for reading this post, don't forget to subscribe!

必竟程式寫好一次之後 後面都是COPY的

#!/bin/sh
#. ${HOME}/.bash_profile
t=`TZ=UTC-8 date +%Y%m%d`
t2=`TZ=UTC-8 date +%H`
projectName='專案目錄名稱'
dbName='資料庫名稱'
dbPassWd='資料庫的密碼'

echo $(date '+%Y-%m-%d %H:%M:%S') "--------------------------------------------------------"
cd /www/wwwroot
pwd
mysqldump -u root -p${dbPassWd} ${dbName} > ../wwwback/${projectName}.sql
echo "mysqldump -u root -p${dbPassWd} ${dbName} > ${projectName}.sql"
tar -zcvPf ../wwwback/${projectName}-db-${t}_${t2}.tar.gz ../wwwback/${projectName}.sql
echo "tar -zcvf ${projectName}-db-${t}_${t2}.tar.gz ${projectName}.sql"

if [ ${t2} -eq "03" ]; then
        tar -zcvPf ../wwwback/${projectName}-web-${t}_${t2}.tar.gz --exclude=/www/wwwroot/${projectName}/system/storage/logs ${projectName} >/dev/null 2>&1
        echo "tar -zcvf ${projectName}-web-${t}_${t2}.tar.gz /home/kmfun/www"
fi
rm -rf ../wwwback/${projectName}.sql
cd /www/wwwback
find *-db-*.gz -mtime +3 -exec /bin/rm -f {} \;
find *-web-*.gz -mtime +3 -exec /bin/rm -f {} \;

發佈留言

發佈留言必須填寫的電子郵件地址不會公開。 必填欄位標示為 *