Create and restore database backups for tenants
Create point-in-time backups of tenant databases and restore from previous backups.
backend/backups/)SELECT * FROM <table>backups/<tenant-name>/
backup-<timestamp>.json
├── metadata: { tenant, database, timestamp, tables, rowCounts }
├── schema: { full schema snapshot }
└── data: { table_name: [rows...] }
lastBackupAt| Error | Recovery |
|---|---|
| Table query fails | Skip table, log warning, continue |
| Disk full | Abort backup, clean partial files |
| Schema mismatch on restore | Warn user, require confirmation |