Skip to content

HTTPS clone URL

Subversion checkout URL

You can clone with
or
.
Download ZIP
A ruby script and cron file that back up a MySQL database to S3
Branch: master
Pull request Compare This branch is even with zeke:master.

Fetching latest commit…

Cannot retrieve the latest commit at this time

Failed to load latest commit information.
mysql_quickdump
.DS_Store
README
mysql_tools.rb
sample.cron
settings.yml

README

mysql_tools.rb
  - Uses config file ./settings.yml
  
USAGE:
mysql_tools.rb backup
  - does a mysqldump on localhost, gzips it and stores to S3 in the configured bucket/folder

mysql_tools.rb restore [filename]
  - Must be run from the machine you wish to restore to.
  - gets the latest mysql backup data from S3 and imports it into mysql
  - takes an optional filename argument for a specific backup file from S3 in the configured bucket/folder

To use cron to daily backup the DB, copy the sample.cron file into /etc/cron.daily, and make sure the path is correct.
Something went wrong with that request. Please try again.