nikashitsa/mysql-backup

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