DB Tasks¶ ↑

Currently just a MySQL import script for copying from a MySQL server by SSHing into a production box.

Add the following line to your Gemfile. You probably want it inside a :development group.

gem 'db_tasks'

You get a db:import_production task. This requires that ssh_username and ssh_host keys are added to the production stanza of your config/database.yml.

This task SSHs to the host, then runs a mysqldump using the credentials defined for your production database. It bzips and stores the dump both on the server and locally, then sends the dump to your local database.

It’s assumed that there’s no password on your local database.