Skip to content

Instantly share code, notes, and snippets.

@adeubank

adeubank/INSTALL.md

Last active Feb 3, 2018
Embed
What would you like to do?
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`
$ 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
#!/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/
# 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
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment