Sign inSign up

elementar/mysql-backup-to-s3

By elementar

•Updated almost 10 years ago

Backs up and restores MySQL instances to Amazon S3. Works with IAM Roles or explicit credentials.

Image
0

212

elementar/mysql-backup-to-s3 repository overview

⁠mysql-backup-to-s3

Backs up and restores MySQL instances. Works with IAM Roles or explicit credentials.

⁠Backup

Usage:

docker run --rm --link some_mysql_container:mysql \
           -e AWS_ACCESS_KEY_ID=... -e AWS_SECRET_ACCESS_KEY=... \
           -e MYSQL_HOST=mysql -e BUCKET=my-aws-bucket -e DB_NAME='db1 db2' \
           elementar/mysql-backup-to-s3

It will perform a backup of the specified databases using mysqldump, then compress using gzip and upload to S3.

⁠Restore

Usage:

docker run --rm --link some_mysql_container:mysql \
           -e BUCKET=my-aws-bucket -e AWS_ACCESS_KEY_ID=... -e AWS_SECRET_ACCESS_KEY=... \
           -e MYSQL_HOST=mysql -e MYSQL_USER=root -e MYSQL_PASSWORD=abc \
           FILE='mysql-backup-20161012T1803+0000.sql.gz' \
           elementar/mysql-backup-to-s3 restore

It will download the backup file from S3, decompress using gunzip, then load into the MySQL instance using the mysql command-line interface.

Tag summary

Content type

Image

Digest

Size

33.2 MB

Last updated

almost 10 years ago

docker pull elementar/mysql-backup-to-s3:1.0