Permalink
Switch branches/tags
Nothing to show
Find file
Fetching contributors…
Cannot retrieve contributors at this time
50 lines (28 sloc) 1022 Bytes

CAP DB DUMP

Capistrano recipes for backing your production database and transferring it to your local machine.

INSTALLATION

  1. Install the gem in bundler's Gemfile:

gem 'cap_db_dump'

$ bundle install
  1. Require the gem in the cap file:

require 'cap_db_dump/recipes'

Finally, add the :db_dump => true flag on the server where you'd like the mysqldump to run:

task :staging do
  role :web,                  'example.com'
  role :app,                  'example.com'
  role :db,                   'example.com', :primary => true, :db_dump => true
end

USAGE

Create a dump:

cap database:dump

Create a dump, and transfer it with scp:

cap database:dump_and_transfer

Only dump the schema for a given set of tables (don't dump the data):

set :schema_only_tables, [:sessions, :my_large_table]

Contributors:

Conor Hunt (conorh)
Stephen Schor (nodanaonlyzuul)

COPYRIGHT

Copyright © 2008 Scott Taylor / Eastmedia <scott@eastmedia.com> Released under the MIT + GPL licenses