Linux实现定时备份网站到网盘

1
#!/bin/bash
2

3
web_path="/var/www" # 数据路径
4
date_time=$(date +"%Y_%m_%d") # 日期格式
5
year=$(date +"%Y") #年份
6
aliyunpan="/var/script/aliyunpan/aliyunpan" #阿里云盘可执行文件路径
7

8
# 激活百度网盘环境
9
source "/var/script/venv/bin/activate"
10

11
for item in "$web_path"/*; do
12
    item_name=$(basename "$item")
13
    # 切换到网站目录进行压缩
14
    cd "$item" || exit
15
    tar -czf "${item_name}_${date_time}.tar.gz" .
16
    # 上传到百度网盘存储
17
    bypy upload "${item_name}_${date_time}.tar.gz" "/${item_name}/"
18
    # 上传到阿里云盘
19
    $aliyunpan upload "${item_name}_${date_time}.tar.gz" "/网站/${item_name}/${year}/"
20
    # 删除文件
21
    rm "${item_name}_${date_time}.tar.gz"
22
done

1
#!/bin/bash
2

3
web_path="/var/www" # 数据路径
4
web_arry=("alist" "bitwarden" "blog") # 网站根目录名称
5
mysql_arry=("blog") # 数据库名称
6
date_time=$(date +"%Y_%m_%d") # 日期格式
7
year=$(date +"%Y") #年份
8
user="root" # 数据库用户名
9
password="lsy22.com" # 数据库密码
10
original_dir=$(pwd) # 记录原始目录
11

12
# 激活百度网盘环境
13
source ~/myvenv/bin/activate
14

15
# 组合备份
16
for item in "${mysql_arry[@]}"; do
17
    # 创建SQL备份
18
    mysqldump -u $user -p$password ${item} > "${item}_${date_time}.sql"
19

20
    # 检查是否有同名的网站目录
21
    if [[ " ${web_arry[@]} " =~ " ${item} " ]]; then
22
        # 切换到网站目录进行压缩
23
        cd "${web_path}/${item}/" || exit
24
        zip -r "${item}_web_${date_time}.zip" .
25
        # 将数据库SQL文件和网站压缩包一起压缩
26
        zip "${item}_${date_time}.zip" "${item}_${date_time}.sql" "${item}_web_${date_time}.zip"
27
        # 删除临时的网站压缩包
28
        rm "${item}_web_${date_time}.zip"
29
        # 返回原始目录
30
        cd "$original_dir" || exit
31
    else
32
        # 否则，只压缩数据库
33
        zip "${item}_${date_time}.zip" "${item}_${date_time}.sql"
34
    fi
35
    rm "${item}_${date_time}.sql"
36
    # 上传到云存储
37
    bypy upload "${item}_${date_time}.zip" "/${item}/${year}/"
38
    # 上传到百度网盘存储
39
    bypy upload "${item}_${date_time}.zip" "/${item}/"
40
    # 上传到阿里云盘
41
    aliyunpan upload "${item}_${date_time}.zip" "/网站/${item}/${year}/"
42
    # 删除文件
43
    rm "${item}_${date_time}.zip"
44
done
45

46
# 单独备份那些没有同名数据库的网站目录
47
for item in "${web_arry[@]}"; do
48
    if [[ ! " ${mysql_arry[@]} " =~ " ${item} " ]]; then
49
        # 切换到网站目录进行压缩
50
        cd "${web_path}/${item}/" || exit
51
        zip -r "${item}_${date_time}_data.zip" .
52
        # 上传到百度网盘存储
53
        bypy upload "${item}_${date_time}.zip" "/${item}/"
54
        # 上传到阿里云盘
55
        aliyunpan upload "${item}_${date_time}.zip" "/网站/${item}/${year}/"
56
        # 删除文件
57
        rm "${item}_${date_time}_data.zip"
58
        # 返回原始目录
59
        cd "$original_dir" || exit
60
    fi
61
done

1
#!/bin/bash
2

3
web_path="/var/www"  # 数据路径
4
web_arry=("alist" "bitwarden" "blog")  # 网站根目录名称
5
mysql_arry=("blog" "study") # 数据库名称
6
date_time=$(date +"%Y_%m_%d")
7
year=$(date +"%Y")
8
user=""  # 数据库用户名
9
password="" # 数据库密码
10

11
for item in ${mysql_arry[@]};do
12
    mkdir -p "$item/$year"
13
    mysqldump -u $user -p$password ${item} > "${item}_${date_time}.sql"
14
    zip "./$item/$year/${item}_${date_time}.zip"  "./${item}_${date_time}.sql"
15
    rm "./${item}_${date_time}.sql"
16
done
17

18
for item in ${web_arry[@]};do
19
    mkdir -p "./$item/$year"
20
    zip -r "./${item}_${date_time}_data.zip" "${web_path}/${item}"
21
    if [ -f "./$item/$year/${item}_${date_time}.zip" ];then
22
        zip -u "./$item/$year/${item}_${date_time}.zip" "./${item}_${date_time}_data.zip"
23
    else
24
         zip "./$item/$year/${item}_${date_time}.zip" "./${item}_${date_time}_data.zip"
25
    fi
26
    rm "./${item}_${date_time}_data.zip"
27
done

1
0 0 1 * * /var/script/backups.sh  # 每个月的第一天的午夜（00:00）执行