Add backup support

[josecelano]

Overview

This epic tracks the implementation of roadmap section 7: Add backup support

Roadmap Reference

From docs/roadmap.md:

7. Add backup support

• 7.1 Research database backup strategies
  • Investigate SQLite backup approaches (file copy while service is running)
  • Investigate MySQL backup approaches (concurrency issues, locking, mysqldump vs hot backups)
  • Document findings and recommend approach for each database type
• 7.2-7.5 Implement backup support (consolidated)
  • Backup configuration schema
  • Configuration file backups
  • SQLite database backups
  • MySQL database backups

Tasks

• Research database backup strategies #310 - Research database backup strategies ✅ Completed
• Implement Backup Support #315 - Implement Backup Support (consolidates roadmap tasks 7.2-7.5)

Task Consolidation

The original roadmap tasks 7.2-7.5 have been consolidated into a single implementation issue (#315) following the research findings from #310. The maintenance-window hybrid approach was selected, and the implementation follows a vertical slice approach delivering:

1. Phase 1: Backup container image on Docker Hub
2. Phase 2: Backup service on first run
3. Phase 3: Scheduled backups via crontab
4. Phase 4: Documentation and final testing

See #315 for full implementation details and docs/issues/implement-backup-support.md for the complete specification.

Related

• Parent: Roadmap #1 (Project Roadmap)
• Research: Research database backup strategies #310 (completed)
• Implementation: Implement Backup Support #315

[josecelano]

All subtasks implemented.