Provide self-hosted users with consistent SQL backups

• /e/ version: n/a
• Device model(s): n/a

Summary

Provide self-hosted users with a reliable SQL backup.

Description

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?

Safety, first.

Then reliability.

Having faced many unrestorable SQL storage snapshot, I know the pain that gives an inconsistent backup.

Examples

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.

Validation

User could simply restore the whole database or a single table, using MariaDB well-known procedures & tools.