A Rails3 compliant gem which provides followings rake tasks

rake handy:db:backup

Creates a dump of data and structure which can been safely backed up

rake handy:db:restore file=xyz.sql.gz

restores the data and structure from file

rake handy:db:db2db

Restores the data from production database to staging database. More options can be specified.

rake handy:db:dump2s3

Creates a backup and then stores that backup on s3

rake handy:db:dump2s3:list

Prints a list of all files stored on s3

rake handy:db:dump2s3:restore file=xxxx.sql.gz

Restores the database with the data from s3.

Copyright (c) 2010 Neeraj Singh. See LICENSE for details.