备份应用和数据库相关

备份文件夹

# 备份数据库
#!/bin/bash
 
# 数据库配置
APP_SRC="/app/dir"
APP_NAME="app-dir"

# 备份配置
BACKUP_DIR="/app/bak/app"
TIMESTAMP=$(date +"%Y%m%d")
BACKUP_FILE="${BACKUP_DIR}/${APP_NAME}-${TIMESTAMP}.tar.gz"
 
# 创建备份目录
mkdir -p "$BACKUP_DIR"
 
# 备份app
tar -cvzf "$BACKUP_FILE" "$APP_SRC"

echo "App backup completed: ${BACKUP_FILE}"

备份数据库

# 备份数据库
#!/bin/bash
 
# 数据库配置
DB_HOST="localhost"
DB_NAME="db-name"
DB_USER="root"
DB_PASSWORD="password"
 
# 备份配置
BACKUP_DIR="/app/bak/sql"
TIMESTAMP=$(date +"%Y%m%d")
BACKUP_FILE="${BACKUP_DIR}/${DB_NAME}-${TIMESTAMP}.sql"
 
# 创建备份目录
mkdir -p "$BACKUP_DIR"
 
# 备份数据库
mysqldump -u "$DB_USER" -p"$DB_PASSWORD" -h "$DB_HOST" "$DB_NAME" > "$BACKUP_FILE"
 
# 压缩备份文件（可选）
gzip "$BACKUP_FILE"
 
echo "Database backup completed: ${BACKUP_FILE}.gz"

定时任务

0 22 * * 5 /bin/sh /app/bak-app.sh
0 23 * * 5 /bin/sh /app/bak-db.sh