城市猎人

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

千王之王重出江湖

A |

　一键部署OpenClaw 网站备份是出事之后最后悔没做的东西。 A 38-year-old tribal woman is battling for her life days after being set on fire by a group of people in the Guna District of India's Madhya Pradesh state, which allegedly began over a land dispute.,The woman, Rampyari Bai, belongs to the Saharia tribe that comes under the particularly vulnerable tribal groups (PVTGs) denomination, Indian daily The Hindu reported.,The accused persons not only set her on fire but also filmed it and shared it over social media.,The footage shows Bai crying in pain after the accused allegedly poured diesel over her and set her ablaze on the farmland.,Warning: the following video is disturbing and may offend sensibilities,⚠️TRIGGER WARNING⚠️In MP's Guna, 03 caste Hindus burnt alive a tribal woman for opposing against encroachment of her land. She suffered 80% burn injuries. This is sickening.Why are the people so silent? Wake up. pic.twitter.com/gdU5lrshH1— Mission Ambedkar (@MissionAmbedkar) July 3, 2022,The woman has now reportedly been admitted to a hospital in the state capital Bhopal, and is in a critical condition, with about 70 to 80 percent burns. The victim was rescued by her husband Arjun Saharia.,The woman told her husband that six people, including two women, burned her for 6 bighas (0.66 hectare) of land, which was allocated to Saharia's family under the state government welfare scheme many years ago.,Saharia has told local reporters that on 23 June, he had reportedly visited the police station and sought protection from the police claiming that his life was in danger as he was getting repeated threats from the same people. However, no action was taken.,Guna District's senior police officer Pankaj Shrivastava said that five people, including two women, have been arrested.,Kamal Nath, a senior member of Congress - the main opposition party in Madhya Pradesh - and a former state chief has accused the state's Bharatiya Janata Party government, led by Shivraj Singh Chouhan, of harboring "hostile attitudes" towards the tribals.,Another senior Congress politician, Jairam Ramesh, wrote on Twitter: "On the one hand, this party puts up (tribal) Draupadi Murmu for the presidential election, and on the other allows such a terrible atrocity on a tribal woman.",Want to know more? Check out our Koo & Telegram accounts!,Koo: https://www.kooapp.com/profile/sputniknews,Sputnik India: https://t.me/sputniknewsindia。很多人服务器被黑后才发现数据库没备份，几年的内容一夜归零。其实一个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官方文档

申请创业报道，分享创业好点子。