Push and pull databases with trellis and ansible playbooks
- set alias for host files
- run push or pull playbook
$ ansible-playbook db-push.yml -e "env=ENV site=SITE"
vagrant 192.168.50.5 ansible_connection=ssh ansible_user=vagrant ansible_user=vagrant ansible_ssh_private_key_file=.vagrant/machines/default/virtualbox/private_key
[development]
vagrant
[web]
vagrant
staging your_server_hostname
[staging]
staging
[web]
staging
production your_server_hostname
[production]
production
[web]
production