DB2S3 - A rails plugin to backup Mysql to Amazon S3

---

Dependencies:

gem install aws-s3

Usage:

./script/plugin install git://github.com/xaviershay/db2s3.git
# In config/initializers/db2s3.rb
DB2S3::Config.instance_eval do
  S3 = {
    :access_key_id     => 'yourkey',
    :secret_access_key => 'yoursecretkey',
    :bucket            => 'yourapp-db-backup'
  }
end
# DB credentials are read from your rails environment

# Add to your crontab or whatever
rake db2s3:backup:full
rake db2s3:backup:incremental # Unimplemented

# Handy tasks
rake db2s3:metrics         # Estimated costs
rake db2s3:backup:restore  # You should be testing this regularly

Caveats:

Currently only stores the latest backup

Kudos:

http://github.com/pauldowman/blog_code_examples/tree/master/mysql_s3_backup