zeke / mysql_s3_backup_tool
watch download tarball
public
Forks3Right
Watchers9Right
Description: A ruby script and cron file that back up a MySQL database to S3
Homepage:
Clone URL: git://github.com/zeke/mysql_s3_backup_tool.git
name age
history
message
file .DS_Store Tue Oct 07 12:40:30 -0700 2008 first commit [zeke]
file README Tue Oct 07 12:40:30 -0700 2008 first commit [zeke]
directory mysql_quickdump/ Tue Oct 07 12:40:30 -0700 2008 first commit [zeke]
file mysql_tools.rb Tue Oct 07 12:40:30 -0700 2008 first commit [zeke]
file sample.cron Fri Nov 07 11:36:03 -0800 2008 Fixed a missing argument in the sample cron file [zeke]
file settings.yml Fri Mar 20 13:21:31 -0700 2009 cleaned up the settings [zeke]
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.