The DB Content Rails plugin adds tasks to save and restore database content. read more »
Usage
— dump the development database to db/archive/development-content.sql.gz
rake db:content:dump
— load the dumped database, and apply any necessary migrations
$ rake db:content:load
— dump the production database to db/archive/production-content.sql.gz
$ RAILS_ENV=production rake db:content:dump
— save the development database to db/archive/{timestamp}.sql.gz
$ rake db:content:save
— save the (compressed) database to my-data.sql.gz
$ rake db:content:save FILE=my-data.sql.gz