What problem does it solve?
Prevents data loss and reduces downtime by providing clear procedures and tooling for creating, storing, and restoring MySQL database backups, including automated scheduling and retention policies.
Core Features & Use Cases
- Automated scheduled backups: Daily cron-driven mysqldump executed by a configured script to produce consistent database snapshots.
- Cloud archival to Cloudflare R2: Uploads backups to a Cloudflare R2 bucket (mybackup/backups/databases/) for off-host retention and retrieval.
- Manual restore and verification: Instructions and commands for downloading, decompressing, and restoring specific backups while enforcing safety checks such as confirming with the owner and backing up the current state first.
- Auditing and logs: Guidance to view backup logs and verify success, and retention enforcement for 30-day lifecycle.
Quick Start
Run the backup script to create an immediate mysqldump of the configured databases and confirm the uploaded file exists in Cloudflare R2 under mybackup/backups/databases/.