Files
Agent 0dfe699cee feat: 构建优化+备份机制
- Docker 多阶段构建(减小镜像体积)
- HEALTHCHECK 健康检查
- 构建后等待健康状态而非日志匹配
- 数据库备份脚本(mysqldump/容器内双模式)
- 30天自动清理旧备份
2026-07-14 23:24:18 +08:00

52 lines
2.0 KiB
Bash

#!/bin/bash
# yx-nav 数据库备份脚本
# 用法: ./backup.sh [保存天数]
set -e
RETENTION_DAYS=${1:-30}
BACKUP_DIR="/opt/data/backups/yx-nav"
TIMESTAMP=$(date +%Y%m%d_%H%M%S)
DB_HOST="${DB_HOST:-110.42.189.169}"
DB_PORT="${DB_PORT:-9109}"
DB_NAME="${DB_NAME:-yx-nav}"
DB_USER="${DB_USER:-yx-nav}"
DB_PASS="${DB_PASS:-yx-nav}"
mkdir -p "$BACKUP_DIR"
echo "=== 开始备份 $DB_NAME ==="
# 使用 mysqldump 备份(如果可用)
if command -v mysqldump &>/dev/null; then
mysqldump -h "$DB_HOST" -P "$DB_PORT" -u "$DB_USER" -p"$DB_PASS" \
--databases "$DB_NAME" --single-transaction --routines --triggers \
| gzip > "$BACKUP_DIR/${DB_NAME}_${TIMESTAMP}.sql.gz"
echo "✅ mysqldump 备份完成: ${DB_NAME}_${TIMESTAMP}.sql.gz"
else
echo "⚠️ mysqldump 不可用,尝试容器内备份..."
# 通过 Docker 容器备份
docker exec yx-nav node -e "
const mysql = require('mysql2/promise');
const fs = require('fs');
(async()=>{
const c = await mysql.createConnection({host:'$DB_HOST',port:$DB_PORT,user:'$DB_USER',password:'$DB_PASS',database:'$DB_NAME'});
const [tables] = await c.execute('SHOW TABLES');
const out = [];
for (const t of tables) {
const [rows] = await c.execute('SELECT * FROM \`' + t[0] + '\`');
out.push({table: t[0], rows});
}
fs.writeFileSync('/tmp/backup_${TIMESTAMP}.json', JSON.stringify(out, null, 2));
await c.end();
})().catch(e=>{console.error(e);process.exit(1)});
" && docker cp "yx-nav:/tmp/backup_${TIMESTAMP}.json" "$BACKUP_DIR/${DB_NAME}_${TIMESTAMP}.json"
echo "✅ 容器内备份完成: ${DB_NAME}_${TIMESTAMP}.json"
fi
# 清理过期备份
find "$BACKUP_DIR" -name "${DB_NAME}_*.sql.gz" -mtime +$RETENTION_DAYS -delete 2>/dev/null
find "$BACKUP_DIR" -name "${DB_NAME}_*.json" -mtime +$RETENTION_DAYS -delete 2>/dev/null
echo "=== 备份完成,保留 ${RETENTION_DAYS} 天 ==="
echo "备份目录: $BACKUP_DIR"
ls -lh "$BACKUP_DIR" 2>/dev/null | tail -5