Dec 09

Import production SQL to your development box with Capistrano

I got sick of using Navicat to import production data to test locally so I whipped up the following Capistrano task. The task grabs data from your production DB and loads it into your local server.

It's a great way to debug problems that are happening on your production server without the risk of fucking up someone's important data...

Written by Seth Banks

Seth spends most of his days leading the design team at Green Bits and improving Cashboard. Occasionally he finds time to write about music, design, startups, and technology.

Tagged: capistrano, rails, mysql, database-administration, dbadmin