ozeias / mysql_s3_backup_tool forked from zeke/mysql_s3_backup_tool

A ruby script and cron file that back up a MySQL database to S3

This URL has Read+Write access

name age
history
message
file .gitignore Loading commit data...
file README
directory config/
file mysql_tools.rb
file sample.cron
README
mysql_tools.rb
  - Uses config file ./config/settings.yml
  
USAGE:
mysql_tools.rb backup [database]
  - 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.