永不磨灭的番号

网站数据自动备份：一个脚本+一个计划任务搞定_我的网站

一 |     

　    一键部署OpenClaw        网站备份是出事之后最后悔没做的东西。    New Delhi, Oct 14 (UNI) The Election Commission of India is likely to announce dates for upcoming assembly polls today, sources said.

Assembly election are due in Himachal Pradesh, Gujarat as well as in Jammu and Kashmir where delimitation was recently concluded.



The ECI has not said which elections are likely to be announced today.

Teams of the poll panel have visited Himachal Pradesh and Gujarat to review poll preparedness in recent days.

Both Gujarat and Himachal Pradesh are presently ruled by BJP, with Congress as the main opposition. Aam Aadmi Party has made its entry in both states, making it a triangular contest.



UNI AO PRT。很多人服务器被黑后才发现数据库没备份，几年的内容一夜归零。

二 | 其实一个shell脚本加一个定时任务就能解决。

三 |     下面这个脚本同时备份MySQL数据库和网站源码，按日期命名，保留最近7天。

四 | Linux服务器直接放到/root/backup.sh，Windows可以改成PowerShell版本，或者把Linux脚本放在宝塔面板的Shell终端里执行。    

#!/bin/bash
SITE_DIR="/www/wwwroot/yoursite"
DB_NAME="yourdb"
DB_USER="root"
DB_PASS="yourpass"
BACKUP_DIR="/backup/$(date +%Y%m%d)"
 
mkdir -p $BACKUP_DIR
 
# 备份数据库
mysqldump -u$DB_USER -p$DB_PASS --single-transaction $DB_NAME | gzip > $BACKUP_DIR/db.sql.gz
 
# 备份网站文件
tar -czf $BACKUP_DIR/files.tar.gz -C $(dirname $SITE_DIR) $(basename $SITE_DIR)
 
# 删除7天前的备份
find /backup -maxdepth 1 -type d -mtime +7 -exec rm -rf {} \;

    脚本写好之后加一条crontab，每天凌晨3点执行。备份文件建议再同步一份到对象存储，比如阿里云OSS或腾讯云COS，做到异地容灾。    # crontab -e    0 3 * * * /bin/bash /root/backup.sh >> /var/log/backup.log 2>&1    数据来源：MySQL Reference Manual 8.0（mysqldump），Linux crontab官方文档             

申请创业报道，分享创业好点子。点击此处，共同探讨创业新机遇！。

五 |

Current article:http://8a8yl2r.feizengbubaipeirangnalouchuo.sbs/list_oh8l/bh23dwv.html

Published on:14:10:13