backup-db.sh 419 B

123456789101112131415161718
  1. #!/usr/bin/env bash
  2. set -euo pipefail
  3. ROOT_DIR="$(cd "$(dirname "$0")/.." && pwd)"
  4. DB_PATH="${DB_PATH:-$ROOT_DIR/data/okr-performance.db}"
  5. BACKUP_DIR="${BACKUP_DIR:-$ROOT_DIR/data/backups}"
  6. if [[ ! -f "$DB_PATH" ]]; then
  7. echo "数据库文件不存在: $DB_PATH" >&2
  8. exit 1
  9. fi
  10. mkdir -p "$BACKUP_DIR"
  11. TS="$(date +%Y%m%d-%H%M%S)"
  12. TARGET="$BACKUP_DIR/okr-performance-$TS.db"
  13. cp "$DB_PATH" "$TARGET"
  14. echo "$TARGET"