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. file is backuped at tmp directory like this tmp/2011-02-10-22-05-40.sql.gz
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.
s3 login information can be passed as per http://gist.github.com/619432 .
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. Sweet!!
rake handy:web:ping site=www.page41.com
Pings a site.
Copyright (c) 2010 Neeraj Singh. See LICENSE for details.