mysql-backup-restore-fs

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

How to use it

Create a directory on the filesystem to hold your backups
Supply all appropriate environment variables
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.

cd .../mysql-backup-restore-fs
mkdir ./mybackups
cp -p test/world.sql.gz ./mybackups
make db # creates the MySQL DB server
make restore # restores the DB dump file
docker ps -a # get the Container ID of the exited restore container
docker logs <containerID> # review the restoration log messages
make backup # create a new DB dump file
docker ps -a # get the Container ID of the exited backup container
docker logs <containerID> # review the backup log messages
make restore # restore the DB dump file from the new backup
docker ps -a # get the Container ID of the exited restore container
docker logs <containerID> # review the restoration log messages
make clean # remove containers and network
docker volume ls # find the volume ID of the MySQL data container
docker volume rm <volumeID> # remove the data volume
docker images # list existing images
docker image rm <imageID ...> # remove images no longer needed