Files
SQLWorkbench/docs/PHASE61-BACKUP-CATALOG.md
2026-10-18 15:41:16 +01:00

18 lines
1.2 KiB
Markdown

# DBSyn Phase 61 — Backup Catalog and Recovery
- Recent SQL backups are recorded automatically after successful export, including SHA-256 checksum and manifest generation.
- Backup catalog remembers up to 20 local file paths across app launches; no backup contents are copied or uploaded.
- Select a backup to reveal it in Finder, verify its SHA-256 sidecar, or initiate restore through the existing confirmation dialog.
- Missing backup files are visibly identified and cannot be selected for verification or restore.
- Clearing the history does not delete backup files.
- Existing export snapshot consistency, backup verification, manifest validation, and import safeguards are retained.
- Includes `scripts/build-run-dbsyn.sh` for the established Debug build-and-launch workflow.
## Caveats
Restores are not transactional. Back up the destination database and verify the chosen backup before restoring. The catalog stores file paths rather than security-scoped bookmarks; files outside permitted locations may require re-selection through the standard file picker.
## Validation
Swift syntax parsed with `swiftc -frontend -parse` where available. Full Xcode build and MySQL integration tests must be run on macOS.