Google Drive MySQL Dumper

Small script which exports a MySQL database to a file and uploads it to Google Drive.

By default, the script works on a 14 day retention policy. That is, local and remote backups are kept for up to 14 days, any local backup files the script finds in the backup directory will be gzipped before the newest backup is exported and uploaded.

Requirements

Requires the gdrive command line utility for Google Drive.

Installation

Download the gdrive utility from its GitHub page and follow its installation guide.
Clone this repository
Make the db-dump.sh script executable, and link it somewhere it can be called from any directory e.g:
```
$ chmod +x /path/to/db-dump.sh
$ sudo ln -s /path/to/db-dump.sh /usr/local/bin/db-dump
```

Set up your db-dump.conf file, either manually by copying db-dump.conf.dist, or by typing db-dump config at the command line:

$ db-dump config
Generating config file...
Enter Database Name: mydatabase    
Enter Google Drive Folder ID: abc123def456
Config file generated.

Run the script

$ db-dump
Uploading /var/spool/db-dump/mydatabase-2016-11-09_17:09:51.sql
Uploaded 0BwvPrE-VPdlkb7BhLGVJZUxST1z at 356.8 KB/s, total 683.5 KB

Configuration

The following options must be set and do not have default values:

Option	Description
db_name	Name of the database to export
gdrive_folder_id	Google Drive folder ID where files get uploaded

The following options do have default values and can be tweaked as desired:

Option	Description	Default
date_format	Date format for dates appended to export files	`%Y-%m-%d_%H:%M:%S`
dump_dir	The local directory where export files will be stored	`/var/spool/db-dump`
retention_days	The number of days to retain local export files	`14`
delete_remote_exports	Whether to delete remote exports after $retention_days (0 for false)	`1` (true)
mysql_opts	Options to pass to `mysqldump` e.g: "-uroot -p"	(None)

Options can be changed in the main db-dump.conf file or can be overridden on a per user basis by creating a config file within your home directory: $HOME/.config/db-dump.conf

Automation

The easiest way to automatically run the script over a given interval is to link it into one of the /etc/cron.* directories, e.g:

sudo ln -s /path/to/db-dump.sh /etc/cron.daily/db-dump

The above command will cause the script to be run once every 24 hours.

Licence

Permission is hereby granted, free of charge, to any person obtaining a copy of this software and associated documentation files (the "Software"), to deal in the Software without restriction, including without limitation the rights to use, copy, modify, merge, publish, distribute, sublicense, and/or sell copies of the Software, and to permit persons to whom the Software is furnished to do so, subject to the following conditions:

The above copyright notice and this permission notice shall be included in all copies or substantial portions of the Software.