在低性能Linux主机上冷备份数据库到腾讯COS

本文链接：https://blog.csdn.net/joyanhui/article/details/123686200

基于宝塔, 宝塔虽然自带数据库备份,但是是导出,非常吃性能,所以自己弄了一个冷备份

首先安装在宝塔面板安装腾讯云COSFS 然后按照提示挂载到服务器

然后找一个可以临时关闭网站的方法,简单粗暴的就是

/etc/init.d/nginx stop

因为我的项目多数是基于thinkphp , 那么还有一个办法就是用一个友好提示的 index_close.php 替换每一个项目的index.php,

关闭
mv index.php  index_default
mv index.close.php  index.php

打开

mv index.php  index.close.php 
mv index_default  index.php

但是有几个站是基于maccms二次开发的会员系统,那就更简单了

sed -i "s/'site_status' => '1'/'site_status' => '0'/g"  /www/www/auto.dev/application/extra/maccms.php

直接替换maccms的配置文件里面的关闭站点提示就好了,也是不用重复造轮子了.

完整代码如下,然后在计划任务里面添加每天执行一次,

#! /bin/bash
# 冷备份Mysql 数据库
# 热备份 太占用系统资源
# sh /www/wwwroot/backupMysql.sh

#备份到的哪个目录 目录最好是挂载的云盘或者对象储存等
MysqlBackupDir="/www/cosfs/储存桶名字/bt_backup/database"

#关闭网站 适合maccms

sed -i "s/'site_status' => '1'/'site_status' => '0'/g"  /www/wwwroot/site_all/application/extra/maccms.php
sed -i "s/'site_status' => '1'/'site_status' => '0'/g"  /www/wwwroot/site_all_debug/application/extra/maccms.php
sed -i "s/'site_status' => '1'/'site_status' => '0'/g"  /www/wwwroot/site_g/application/extra/maccms.php
sed -i "s/'site_status' => '1'/'site_status' => '0'/g"  /www/wwwroot/site_ba/application/extra/maccms.php
sed -i "s/'site_status' => '1'/'site_status' => '0'/g"  /www/wwwroot/site_tk/application/extra/maccms.php
#关闭数据库
/etc/init.d/mysqld stop

#备份 并删除10天以前的
DATE=$(date +%Y%m%d)
DATE_RM=$(date -d "3 days ago" +%Y%m%d)

cd $MysqlBackupDir
tar -cPf ./all_$DATE.tar.gz /www/server/data
rm -rf ./all_$DATE_RM.tar.gz

#打开数据库
/etc/init.d/mysqld start
#打开网站

sed -i "s/'site_status' => '0'/'site_status' => '1'/g"  /www/wwwroot/site_all/application/extra/maccms.php
sed -i "s/'site_status' => '0'/'site_status' => '1'/g"  /www/wwwroot/site_all_debug/application/extra/maccms.php
sed -i "s/'site_status' => '0'/'site_status' => '1'/g"  /www/wwwroot/site_g/application/extra/maccms.php
sed -i "s/'site_status' => '0'/'site_status' => '1'/g"  /www/wwwroot/site_ba/application/extra/maccms.php
sed -i "s/'site_status' => '0'/'site_status' => '1'/g"  /www/wwwroot/site_tk/application/extra/maccms.php