Creating True Database Backups with Dumps¶
Too often I see folks relying on copies of a persisted database volume mount. While it is great people are backing up their database volumes, backing up a database volume can easily result in a corrupted backup unless the docker container is properly turned off prior to the backup. We like our containers running 24/7 though!
In this post, let's introduce ourselves to the following:
fradelg/mysql-cron-backupfor MySQL / MariaDBprodrigestivill/postgres-backup-localfor Postgres
MySQL¶
Check the following link for usage: https://github.com/fradelg/docker-mysql-cron-backup
Postgres¶
Check the following link for usage: https://github.com/prodrigestivill/docker-postgres-backup-local