Capistrano Tasks for dumping and transfering production databases
Ruby
Pull request Compare This branch is 1 commit ahead, 8 commits behind smtlaissezfaire:master.
Fetching latest commit…
Cannot retrieve the latest commit at this time.
Permalink
Failed to load latest commit information.
recipes
.gitignore
GPL_LICENSE
MIT_LICENSE
README.rdoc
VERSION

README.rdoc

CAP DB DUMP

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

INSTALLATION

Install the plugin in vendor/plugins:

# FROM RAILS_ROOT
git submodule add git://github.com/smtlaissezfaire/cap_db_dump.git vendor/plugins/cap_db_dump

Or without submodules:

# FROM RAILS_ROOT
ruby script/plugin install git://github.com/smtlaissezfaire/cap_db_dump.git

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)

COPYRIGHT

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