«
»

Refresh data from production

Published on Sunday, November 30th, 2008 at 9:15 am.

When working on web apps, it can really useful to be able to load production data into your development environment.

I am a sucker for anything that reduces typing so I put together a mysql_tasks rails plugin for my MySQL backed applications which makes it as easy as

rake mysql:refresh_from_production

Which makes a tar gzipped snapshot of the production database, downloads it into my development box and loads it into my development environment.

If you want to give it a go yourself then read these installation instructions for the mysql_tasks plugin.

This was inspired by the real Nate Clark.

You can leave a response, or trackback from your own site.

One Response to “Refresh data from production”

  1. Jason Green Says:
    March 9th, 2009 at 4:18 pm

    That is a great idea, why did I never think of that! It’s all about automating these processes which you ultimately end up having to repeat over and over…

Leave a Reply