You can sync your production and local database


  • rsync
  • mina (Duh)


Add this line to your application's Gemfile:

gem 'mina', require: false
gem 'mina-data_sync', require: false

And then execute:

$ bundle

Or install it yourself as:

$ gem install mina-data_sync

Require it in your deploy script:

# config/deploy.rb
require 'mina/data_sync'


mina data_sync:pull # pulls remote to local
mina data_sync:push # pushes local to remote

You can use the only parts of the sync:

mina data_sync:dump_remote
mina data_sync:dump_local
mina data_sync:copy_local_to_remote
mina data_sync:copy_remote_to_local
mina data_sync:restore_remote
mina data_sync:restore_local


configurable variables with defaults

set :database_path, "config/database.yml"
set :remote_backup_path, 'tmp'
set :local_backup_path, -> { ENV['DATA_SYNC_BACKUP_PATH'] || 'tmp' }
set :backup_file, -> { %{#{fetch(:repository).split('/').last.split('.').first}-#{fetch(:rails_env)}-#{Date.today}.sql} }


  1. Fork it ( https://github.com/[my-github-username]/mina-data_sync/fork )
  2. Create your feature branch (git checkout -b my-new-feature)
  3. Commit your changes (git commit -am 'Add some feature')
  4. Push to the branch (git push origin my-new-feature)
  5. Create a new Pull Request