Provide self-hosted users with consistent SQL backups
- /e/ version: n/a
- Device model(s): n/a
Provide self-hosted users with a reliable SQL backup.
What is the current behavior?
Actually there is no proper SQL backup, only hosting provider entire VM backup.
As they merely are snapshots, SQL database(s) consistency is not ensured.
What is the improved behavior?
Users may have proper SQL backups (aka SQL dumps), so they could easily restore all or part of their database(s).
This may be integrated into the self-hosted installation, without the need of a manual add-on Docker image or backup scripts.
What does it bring?
Having faced many unrestorable SQL storage snapshot, I know the pain that gives an inconsistent backup.
Please see this thread : https://community.e.foundation/t/howto-properly-backup-self-hosted-e-cloud-databases/19423
Using Hetzner Cloud instances, this can be combined with cheap Volumes.
User could simply restore the whole database or a single table, using MariaDB well-known procedures & tools.