Skip to content

database backups

Stanislav Katkov edited this page Sep 15, 2017 · 5 revisions

Get one from production here: https://app.cloud66.com/stacks/47322/managed_backups/4303

!!! Make sure that backup is not binary!

Connecting to Staging via SSH:

  • cx ssh -s "Staging Service Alliance" web

or Read here for other options

locally:

  • cp ... tmp/latest.dump
  • rake db:drop
  • rake db:create
  • rake db:rebuild

to staging:

  • psql -U rails --no-password servpro_production < latest.dump
Clone this wiki locally