Setting up automysqlbackup for backups everyday at 3AM and then saving with S3. Need to configure s3cmd with credentials and automysqlbackup. Assumes that all the backups are stored in `/backups`

INSTALL.md

$ sudo su
$ apt-get update
$ apt-get install s3cmd automysqlbackup
$ s3cmd --configure
# enter access key and secret and other details
$ vim /etc/default/automysqlbackup
# Set these variables
#   USERNAME
#   PASSWORD
#   DBNAMES
#   DBHOST
#   BACKUPDIR="/backups"
#   MAILCONTENT="stdout"
#   POSTBACKUP="/etc/mysql-backup-post"
$ automysqlbackup # verify it all works ;D

mysql-backup-post

#!/bin/bash

# save this file in /etc/mysql-backup-post
# make it executable chmod +x /etc/mysql-backup-post
# corresponds to the POSTBACKUP variable in /etc/automysqlbackup/automysqlbackup.conf

echo syncing backups now
s3cmd sync -r --delete-removed /backups s3://bucket-name/

root.crontab

# Edit this file to introduce tasks to be run by cron.
#
# Each task to run has to be defined through a single line
# indicating with different fields when the task will be run
# and what command to run for the task
#
# minute (m), hour (h), day of month (dom), month (mon),
# and day of week (dow) or use '*' in these fields (for 'any').#
# Notice that tasks will be started based on the cron's system
# daemon's notion of time and timezones.
#
# Output of the crontab jobs (including errors) is sent through
# email to the user the crontab file belongs to (unless redirected).
#
# For example, you can run a backup of all your user accounts
# at 5 a.m every week with:
# 0 5 * * 1 tar -zcf /var/backups/home.tgz /home/
#
# For more information see the manual pages of crontab(5) and cron(8)
#
# m h  dom mon dow   command
0 3 * * * automysqlbackup > /var/log/automysqlbackup.log 2>&1