akonwi

# With these tasks you can:
#   - dump your production database and save it in shared_path/db_backups
#   - download most recent backup
namespace :db do
  task :backup_name, :roles => :db, :only => { :primary => true } do
    now = Time.now
    run "mkdir -p #{shared_path}/db_backups"
    backup_time = [now.year,now.month,now.day,now.hour,now.min,now.sec].join('-')
    set :backup_file, "#{shared_path}/db_backups/#{application}-snapshot-#{backup_time}.sql"
  end

akonwi

## Download
scp user@remote_host:remote_file local_file

## Upload
scp local_file user@remote_host:remote_file

akonwi

Run in command line:

  RAILS_ENV=production rake db:create db:schema:load