A gem providing a rake task for backing up and migrating databases and files between rails instances.
Failed to load latest commit information.
lib bump version to 0.0.12 May 7, 2012
.gitignore updating git ignore file Dec 13, 2011
Gemfile Changed project from 'db-backup' to 'rails-backup-migrate'. Jun 27, 2011
LICENSE Adding GNU GPL license file. Jun 29, 2011
README.textile Fix typo in readme. Aug 18, 2011
Rakefile initial commit, from "bundle gem" creation Jun 19, 2011
rails-backup-migrate.gemspec adding github site as homepage Feb 19, 2012


Rails Backup Migrate

A gem that provides a rake task for backing up your database and uploaded files to an archive and restoring them from an archive.

You can archive schema, schema+data, files, or schema+data+files. Each archive action has a restore counterpart. The data from the database is backed up to a .yml file for each table that is database independent.

So you can use Rails Backup Migrate to get data out of one kind of database and easily load it into another kind.

Quick Start

Installing the gem:

  $ gem install rails-backup-migrate

Add the following line to your rails application’s Rakefile

  require 'rails-backup-migrate'

To backup everything in a rails instance:

  $ rake site:backup

Everything is saved in an archive file, named by default ‘site-backup.tgz’. Copy/move this to another rails instance

  $ rake site:restore

More info

The backup file can be specified with a command line argument in rake’s (wierd) format:

  $ rake site:backup[/path/to/file.tgz]


Tested initially on ‘redmine’ using rails 2.3.11 and some simpler tests with rails 3. Has been tested with MySQL and Sqlite3 databases. Further testing with postgres to be done.

Also tested with a dummy rails 3.0 app using sqlite3 driver in ruby 1.8.7, 1.9.2 and jruby 1.6.2.

This requires a system with access to the `tar` command in your path. (Easy for Mac & *nixes, may require a posix environment such as cygwin under Windows.)

Known Issues:

- under ruby 1.9.2, the YAML export (in the `rake site:backup` task fails extended characters in ASCII to UTF8 conversion) (Github Issue #4) Changes made in 0.0.9 that look like this is fixed – any help regressing is welcome!


Matt Connolly – main author of gem
Tobias Lütke – wrote a `backup.rake` file that inspired the database backup portion.