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} }
- Fork it ( https://github.com/[my-github-username]/mina-data_sync/fork )
- Create your feature branch (
git checkout -b my-new-feature
) - Commit your changes (
git commit -am 'Add some feature'
) - Push to the branch (
git push origin my-new-feature
) - Create a new Pull Request