ar-backup

Latest update: Nov 28 2007 ( patch submitted by Cyril Mougel)

fixed : ar-backup not working properly when the OS isn't in English (svn issues) fixed : can't create a backup folder on windows when the revision isn't defined enhanced : speed has been improved since we are now parsing the local svn files.

Active Record backup is a Rails plugin which lets you backup your database schema and content in a schema.rb file and fixtures.

Backups are organized by environments and SVN revision.

ar-backup is compatible with sake http://errtheblog.com/post/6069
To install in Rails:

Rails script:

ruby script/plugin install http://ar-backup.googlecode.com/svn/ar-backup

Piston:

piston import http://ar-backup.googlecode.com/svn/ar-backup vendor/plugins/ar-backup

SVN:

svn co http://ar-backup.googlecode.com/svn/ar-backup vendor/plugins/ar-backup

Sake:

sake -i http://ar-backup.googlecode.com/svn/ar-backup/tasks/ar_backup_tasks.sake

Prerequisites:Your project must be under subversion
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

Backup your database content and schema. (development environment)
rake backup:db:dump
Do the same thing but with the production environment (note that the previous backup won't be overwritten)
RAILS_ENV=production rake backup:db:dump
Restore the database content and schema backed up under BUILD=2547
rake backup:db:load BUILD=2547
Restore the production database backup into our development db
rake backup:db:load BUILD=2547 DUMP_ENV=production
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