Complete gids voor backup en restore procedures in PMA v2.
PMA v2 biedt geintegreerde backup functionaliteit voor alle services. Backups omvatten:
- Database dumps
- Configuratie bestanden
- Uploaded content
- Service-specifieke data
flowchart TB
subgraph Trigger["Backup Triggers"]
manual[Manual: just backup]
scheduled[Scheduled: Cron]
preupgrade[Pre-upgrade]
end
subgraph Process["Backup Process"]
stop[Stop writes]
dump[Database dump]
files[File backup]
compress[Compress]
verify[Verify integrity]
end
subgraph Storage["Backup Storage"]
local[Local: backups/]
remote[Remote: S3/NFS]
end
manual --> stop
scheduled --> stop
preupgrade --> stop
stop --> dump --> files --> compress --> verify
verify --> local
verify --> remote
style Trigger fill:#e3f2fd
style Process fill:#fff3e0
style Storage fill:#e8f5e9
¶ Backup Commands
| Command |
Beschrijving |
just backup SERVICE |
Backup van specifieke service |
just backup redmine |
Backup Redmine database + files |
just backup n8n |
Backup n8n workflows + credentials |
just backup mattermost |
Backup Mattermost data |
just backup authentik |
Backup Authentik configuratie |
| Command |
Beschrijving |
just backup all |
Backup alle actieve services |
just backup ecosystem |
Volledige ecosystem backup |
| Service |
Database |
Files |
Config |
Command |
| Redmine |
PostgreSQL |
attachments |
settings |
just backup redmine |
| n8n |
PostgreSQL |
- |
workflows |
just backup n8n |
| Mattermost |
PostgreSQL |
uploads |
config |
just backup mattermost |
| Authentik |
PostgreSQL |
media |
flows |
just backup authentik |
| Grafana |
SQLite |
dashboards |
datasources |
just backup grafana |
| ERPNext |
MariaDB |
files |
config |
just backup erpnext |
| Zammad |
PostgreSQL |
storage |
- |
just backup zammad |
backups/
├── redmine/
│ ├── redmine-2024-01-15-1030.sql.gz
│ ├── redmine-2024-01-15-1030-files.tar.gz
│ └── latest -> redmine-2024-01-15-1030.sql.gz
├── n8n/
│ ├── n8n-2024-01-15-1030.sql.gz
│ └── latest -> n8n-2024-01-15-1030.sql.gz
├── ecosystem/
│ └── ecosystem-2024-01-15-1030.tar.gz
└── logs/
└── backup-2024-01-15.log
# Check service status
just status SERVICE
# Controleer disk space
df -h backups/
# Controleer vorige backups
ls -la backups/SERVICE/
# Start backup
just backup redmine
# Output voorbeeld:
# [INFO] Starting backup of redmine...
# [INFO] Dumping PostgreSQL database...
# [INFO] Backing up attachments...
# [INFO] Compressing backup...
# [INFO] Backup complete: backups/redmine/redmine-2024-01-15-1030.sql.gz
# [INFO] Size: 45MB
# Check backup integrity
gunzip -t backups/redmine/redmine-2024-01-15-1030.sql.gz
# List backup contents
tar -tzf backups/redmine/redmine-2024-01-15-1030-files.tar.gz | head
flowchart TB
start[Start Restore] --> select[Selecteer backup]
select --> confirm{Bevestig restore}
confirm -->|Ja| stop[Stop service]
confirm -->|Nee| cancel[Annuleren]
stop --> restore[Restore data]
restore --> verify[Verify data]
verify --> start_svc[Start service]
start_svc --> test[Test service]
test --> done[Klaar]
style start fill:#e3f2fd
style done fill:#e8f5e9
style confirm fill:#fff3e0
# Restore van laatste backup
just restore redmine
# Restore van specifieke backup
just restore redmine --file=backups/redmine/redmine-2024-01-14-0800.sql.gz
[WARN] This will overwrite current data!
[INFO] Backup: redmine-2024-01-15-1030.sql.gz (45MB)
[INFO] Created: 2024-01-15 10:30:00
Continue? [y/N]: y
[INFO] Stopping redmine...
[INFO] Restoring database...
[INFO] Restoring files...
[INFO] Starting redmine...
[INFO] Restore complete!
# Check service status
just status redmine
# Test connectivity
just health redmine
# Bekijk logs
just logs redmine
Complete backup van alle services en configuratie.
- Alle service databases
- Alle uploaded files
- Docker volumes
- Environment configuratie (excl. secrets)
- Service manifests
# Volledige ecosystem backup
just backup ecosystem
# Output:
# [INFO] Starting ecosystem backup...
# [INFO] Backing up: redmine, n8n, mattermost, authentik...
# [INFO] Backing up Docker volumes...
# [INFO] Backing up configuration...
# [INFO] Creating archive...
# [INFO] Ecosystem backup: backups/ecosystem/ecosystem-2024-01-15.tar.gz
# [INFO] Total size: 2.3GB
# Restore volledige ecosystem
just restore ecosystem
# Dit stopt ALLE services en herstelt alles
| Type |
Frequentie |
Retentie |
| Database |
Dagelijks |
7 dagen |
| Files |
Wekelijks |
4 weken |
| Ecosystem |
Maandelijks |
3 maanden |
| Pre-upgrade |
Voor elke upgrade |
Permanent |
- Test restore procedure regelmatig
- Monitor backup disk space
- Verifieer backup integriteit
- Documenteer restore procedures
- Offsite backup voor disaster recovery
# Check disk space
df -h
# Check permissions
ls -la backups/
# Check service status
just status SERVICE
# Check backup file
gunzip -t backup.sql.gz
# Check database connectivity
just health SERVICE
# Bekijk logs
just logs SERVICE