capistrano-mysqldump

Capistrano extension to run mysqldump remotely, download, and import into your local Rails development database.

WARNING: This will blow away your development database (duh)

Note: For capistrano v2, see version 1

Installation

gem install capistrano-mysqldump

Usage

require 'capistrano/mysqldump'
cap production mysqldump

Or whatever environment you want to take the mysqldump from

Configuration

Override these defaults in deploy.rb if necessary

set :mysqldump_bin, "/usr/local/mysql/bin/mysqldump"
set :mysqldump_remote_tmp_dir, "/tmp"
set :mysqldump_local_tmp_dir, "/tmp"
set :mysqldump_location, :local
set :mysqldump_ignore_tables, %w(logs page_views)
set :mysqldump_tables, %w{cool_info totally_awesome_rows}

(default is all tables)

set :mysqldump_options, {'no-data' => true, 'port' => 3307 }}

Equivalent to running

$ mysqldump --no-data --port=3308

Contributing to capistrano-mysqldump

Copyright © 2011 Alex Farrill. See LICENSE.txt for further details.