mysql-backup-restore-fs

Service to backup and/or restore a MySQL database to/from a local filesystem directory

How to use it

1. Create a directory on the filesystem to hold your backups
2. Supply all appropriate environment variables
3. Run a backup and check your directory for that backup

Environment variables

MODE Valid values: backup, restore

DB_NAME name of the database

MYSQL_USER user that accesses the database

MYSQL_PASSWORD password for the MYSQL_USER

MYSQL_DUMP_ARGS (optional) additional arguments to the mysqldump command, e.g., --max_allowed_packet=50M

BACKUP_DIR e.g., /path/to/database-backups NOTE: no trailing slash

Versioning of the backup file is left as an exercise for the user. This script will overwrite an existing backup file.

Docker Hub

This image is built automatically on Docker Hub as silintl/mysql-backup-restore-fs

Playing with it locally

You'll need Docker, Docker Compose, and Make.

1. cd .../mysql-backup-restore-fs
2. mkdir ./mybackups
3. cp -p test/world.sql.gz ./mybackups
4. make db # creates the MySQL DB server
5. make restore # restores the DB dump file
6. docker ps -a # get the Container ID of the exited restore container
7. docker logs <containerID> # review the restoration log messages
8. make backup # create a new DB dump file
9. docker ps -a # get the Container ID of the exited backup container
10. docker logs <containerID> # review the backup log messages
11. make restore # restore the DB dump file from the new backup
12. docker ps -a # get the Container ID of the exited restore container
13. docker logs <containerID> # review the restoration log messages
14. make clean # remove containers and network
15. docker volume ls # find the volume ID of the MySQL data container
16. docker volume rm <volumeID> # remove the data volume
17. docker images # list existing images
18. docker image rm <imageID ...> # remove images no longer needed