ar-backup

=ActiveRecord-backup

Using rake tasks, dump your schema and data into yml files. One folder gets created per SVN revision. You can then simply load any previous data using rake.

prerequisite: Your project must be under SVN.

==Usage:

rake backup:db:dump # create a backup folder containing your db schema and content data (see backup/{env}/build_{build number}) rake backup:db:extract_content # Create YAML fixtures from your DB content rake backup:db:extract_schema # Dump the db schema rake backup:db:load # load your backed up data from a previous build. rake backup:db:load BUILD=1182 or rake backup:db:load BUILD=1182 DUMP_ENV=production

==Example

rake backup:db:dump

rake backup:db:load BUILD=2547

==Capistrano 2 usage example

(you first need to create a backup folder)

set :backup_dir, "#{deploy_to}/backup"

before :deploy do
  db.backup
  db.move_backup
end

namespace :db do
  desc 'create the production database'
  task :create do
    run "cd #{current_release} && rake db:create RAILS_ENV=production"
  end

  desc 'dump the database schema and content'
  task :backup do
    run "cd #{current_release} && rake backup:db:dump RAILS_ENV=production"
  end

  desc 'timestamp the backup file'
  task :move_backup do
    run "cd #{current_release} && mv backup/production #{backup_dir}/production_#{Time.now.strftime("%Y-%m-%d_%H-%M")}"
  end
end

==Contributors Cyril Mougel : cyril.mougel@gmail.com (ar_backup windows compatible and the revision number is parsed in a more efficient way)

Copyright (c) 2007 Matt Aimonetti, released under the MIT license