背景说明
网上有很多教程，写的都是从零搭建一个什么什么，基本上都是从无到有的教程，但是，很少有文章提及搭建好之后如何备份，这次通过请教GitHub Copilot Chat，生成几个备份脚本，以备后用。
注：本文涉及的所有脚本默认仅针对Linux环境。
备份MySQL
#!/bin/bash
# Set the database name, backup directory, host, username, and password
database="<database>"
backup_directory="<backup_directory>"
host="<host>"
username="<username>"
password="<password>"
# Create the backup directory if it doesn't exist
mkdir -p $backup_directory
# Create a timestamped backup file name
backup_file="$backup_directory/$database-$(date +%Y-%m-%d-%H-%M-%S).sql"
# Backup the database to the backup file
mysqldump -h $host -u $username -p$password $database > $backup_file
# Delete backups older than 7 days
find $backup_directory -type f -name "$database-*.sql" -mtime +7 -delete
echo $backup_file
备份SQLite
#!/bin/bash
# Set the database file path and backup directory
database="<database>"
backup_directory="<backup_directory>"
# Create the backup directory if it doesn't exist
mkdir -p $backup_directory
# Create a timestamped backup file name
backup_file="$backup_directory/$(basename $database)-$(date +%Y-%m-%d-%H-%M-%S).db"
# Backup the database to the backup file using SQLite's .backup command
sqlite3 $database ".backup $backup_file"
# Delete backups older than 7 days
find $backup_directory -type f -name "*.db" -mtime +7 -delete
echo $backup_file
备份目录
#!/bin/bash
# Set the directory to backup and backup directory
directory="<directory>"
backup_directory="<backup_directory>"
# Create the backup directory if it doesn't exist
mkdir -p $backup_directory
# Create a timestamped backup file name
backup_file="$backup_directory/$(basename $directory)-$(date +%Y-%m-%d-%H-%M-%S).tar.gz"
# Backup the directory to the backup file
tar -czf $backup_file $directory
# Delete backups older than 7 days
find $backup_directory -type f -name "*.tar.gz" -mtime +7 -delete
echo $backup_file
上传至对象存储
#!/bin/bash
read file
prefix=$1
bucket=$2
coscli cp $file "cos://$bucket/$prefix/$(basename $file)"
COSCLI 是腾讯云对象存储（Cloud Object Storage，COS）提供的客户端命令行工具。具体安装、配置参考官方文档。
划重点
上面的内容都平平无奇，我主要想说的是最后这一段。
上文中的备份脚本有个细节，最后都会输出备份文件的路径，结合最后一个脚本上传至对象存储。
整体使用逻辑是：备份脚本分别写，上传脚本共用同一个。
这里测试备份 /data/test/目录至对象存储的/test/路径下：
backup.sh
#!/bin/bash
directory="/data/test"
backup_directory="/data/backup/test"
mkdir -p $backup_directory
backup_file="$backup_directory/$(basename $directory)-$(date +%Y-%m-%d-%H-%M-%S).tar.gz"
cd $directory
tar -czf $backup_file .
find $backup_directory -type f -name "*.tar.gz" -mtime +7 -delete
echo $backup_file
upload.sh
#!/bin/bash
read file
prefix=$1
bucket=$2
coscli cp $file "cos://$bucket/$prefix/$(basename $file)"
备份命令如下：
./backup.sh | ./upload.sh test temp
结合crontab就可以实现定时备份了。
另外，对于对象存储上的内容，可以设置生命周期，自动删除旧的备份。如下图，设置了备份保留30天。
