本文是专题：建站日记中的第4篇，共12篇

建站日记

曾经提到过，需要重视系统备份了。这不，倒腾了一个自动备份数据库的bash脚本，那出来晒一晒，欢迎大家批评指正哈。

View Code BASH
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25

#!/bin/sh
backup ()
{
    DBName=$@
    BackupPath="/DBbackup/"${DBName}
    BackupName=${DBName}-`date "+%Y-%m-%d-%H-%M-%S"`".sql"
        if [[ -d "${BackupPath}" ]] || mkdir ${BackupPath};
        then
                if      mysqldump -uroot(I like easy way-:) -p*****(Hide N passwd-:) \
                        --default-character-set=utf8 --opt --master-data=1 \
                        --single-transaction --flush-logs \
                        ${DBName} > ${BackupPath}"/"${BackupName};
                then
                        echo ${BackupName}"Backup success!"
                        bzip2 -q -s  ${BackupPath}"/"${BackupName};
                else
                        echo ${BackupName}"Backup Failed@@@@@@@@@@@@@@@@@@@@@@@@"
                fi
        fi
        find ${BackupPath}"/" -ctime +7 -exec rm {} \;
}
#Call the function to backup database assigned below
backup  ***_db
backup  ***_db
***
专题导航前一篇后一篇