import { DatabaseSync } from 'node:sqlite'; import { cpSync, existsSync, mkdirSync } from 'node:fs'; if (existsSync('.env')) process.loadEnvFile('.env'); const DB_PATH = process.env.DB_PATH ?? 'data/app.db'; const UPLOADS = process.env.UPLOADS_DIR ?? 'data/uploads'; const stamp = new Date().toISOString().replace(/[:.]/g, '-'); const dir = `backups/${stamp}`; mkdirSync(dir, { recursive: true }); // VACUUM INTO 产出一致性快照,比直接拷贝 db 文件安全(WAL 模式下也有效) const db = new DatabaseSync(DB_PATH); db.exec(`VACUUM INTO '${dir}/app.db'`); db.close(); if (existsSync(UPLOADS)) { cpSync(UPLOADS, `${dir}/uploads`, { recursive: true }); console.log(`已复制 uploads -> ${dir}/uploads`); } console.log(`备份完成:${dir}`);