Database Backups

Automated database backups with configurable schedules and multiple storage options. Database backups create portable dump files that can be stored off-site and restored to any compatible database server.

Overview

Database backups create dump files and upload them to cloud storage:

• Off-site storage - Independent from your infrastructure
• Portable - Standard dump formats work across platforms
• S3-compatible - Works with any S3-compatible storage provider

Supports both SQL databases (PostgreSQL, MySQL, MariaDB) and NoSQL databases (MongoDB, Redis).

Supported Databases

• ✅ PostgreSQL - Full database backups with pg_dump
• ✅ MySQL - Complete database dumps with mysqldump
• ✅ MariaDB - Comprehensive backups with mariadb-dump
• ✅ MongoDB - Database backups with mongodump
• ✅ Redis - RDB snapshots with redis-cli --rdb

Quick Setup

1. Navigate to database → Backup Settings
2. Enable backups and choose frequency (hourly/daily/weekly/monthly/custom)
3. Choose storage:
   • Local - Stored on server (lost if server deleted)
   • Cloud - S3-compatible storage (recommended)
4. Configure retention (number of backups to keep)

Storage Providers

Supports any S3-compatible provider:

• AWS S3 - Requires region and bucket
• DigitalOcean Spaces - Requires region and bucket
• Cloudflare R2 - Requires account ID and bucket
• Azure Blob Storage - Requires storage account and container
• Google Cloud Storage - Requires bucket and credentials
• Others - Wasabi, MinIO, Backblaze B2, or any S3-compatible endpoint

Backup Restoration

1. Download Backup - Get the backup file from cloud storage
2. Prepare Database - Ensure target database is ready
3. Restore - Use database-specific restore commands:
   • PostgreSQL: psql database_name < backup_file.sql
   • MySQL: mysql database_name < backup_file.sql
   • MariaDB: mariadb database_name < backup_file.sql
   • MongoDB: mongorestore --archive=backup_file.archive
   • Redis: Copy RDB file to Redis data directory and restart Redis

Related Documentation

• Server Backups - Complete server snapshots
• Backups Overview - Understanding backup types