CRON - DOCKER - DUMP - DROPBOX

Why?

Just because I needed it.

Prerequisites:

• ubuntu or debian
• curl installed
• cron installed
• docker installed
• running MySQL docker container with some database
• gzip installed
• MySQL docker container ID (you can retrieve it by 'docker ps')
• your dropbox oAuth token

Description

This simple script will just set up cron to perform:

• mysqldump from running database
• store dump on your host
• send it to the dropbox folder
• remove dumps from your host

You will be prompted to enter:

• MySQL container ID
• MySQL database name
• MySQL user
• MySQL password
• dropbox oauth token
• path for storing dumps on host
• path for sending dumps to the Dropbox
• cron scheduling for dumping
• cron scheduling for sending
• cron scheduling for removing (optional)

Getting started

Download the script using this command:

curl "https://raw.githubusercontent.com/Czende/cron-docker-dump-dropbox/master/cddd.sh" -o cddd.sh

Then give the execution permission to the script and run it:

chmod +x cddd.sh
./cddd.sh

Thanks to this excelent Dropbox Uploader