rikdc
commented
1 year ago - Thinking about this, creating a custom Docker image that has the mysql commands available to run the backup.
- This should be on the same network as the mysql server container.
- Since its on the same network, I can create a backup user that's passwordless but from the same network.
- Alternatively, encrypt the credentials before storing in the backup script.
Basic mysql_dump and transfer to the NAS for backup. Configurable schedule Maybe replicate to backup? Probably overkill. gpg encyrpt the backup for added security