Sign inSign up

nikashitsa/mysql-backup

By nikashitsa

•Updated almost 9 years ago

MySQL backup to S3 under cron

Image
1

868

nikashitsa/mysql-backup repository overview

⁠nikashitsa/mysql-backup

License MIT

Provides mysql backup to S3⁠ under cron (based on Alpine Linux).

⁠Install

Please have a look at docker-compose.example.yml

...
    environment:
      REMOTE_URL: 's3://s3.eu-central-1.amazonaws.com/bucket-name/backups'
      MYSQL_DUMP_PARAMS: '--add-drop-table --databases mydatabase --password=YOUR_PASSWORD_HERE'
      MYSQL_RESTORE_PARAMS: '--password=YOUR_PASSWORD_HERE'
      AWS_ACCESS_KEY_ID: 'PUT YOUR VALUE HERE'
      AWS_SECRET_ACCESS_KEY: 'PUT YOUR VALUE HERE'
...
  1. You need to change REMOTE_URL with your value
  2. Change mydatabase in MYSQL_DUMP_PARAMS to your database name
  3. Replace YOUR_PASSWORD_HERE with your root user password
  4. Set your AWS_ACCESS_KEY_ID and AWS_SECRET_ACCESS_KEY values
⁠Start
docker-compose up -d
⁠Manual Exec

Additional scripts are provided to make it easier to manually invoke backups.

docker exec -it mysqlbackup backup
docker exec -it mysqlbackup status
docker exec -it mysqlbackup restore

You can restore backup to specified time. More info here⁠.

docker exec -it mysqlbackup restore -t 1D

Tag summary

Content type

Image

Digest

Size

32.1 MB

Last updated

almost 9 years ago

docker pull nikashitsa/mysql-backup