title: Rails rake task for loading live (MySQL) database to local development database
body: <p>For years I've used a ssh pipe from <code>mysqldump</code> on the live server to <code>mysql</code> on my development machine for getting a copy of the current data.</p>
  
  <pre><code>ssh -C &lt;server&gt; mysqldump --opt &lt;live_database_name&gt; |mysql &lt;local_dev_database_name&gt;
  </code></pre>
  
  <p>Where <code>-C</code> enables ssh compression and <code>--opt</code> enables quickness and completeness.</p>
  
  <p>Does anyone have a rails-ish equivalent rake task for this? Ideally it'd take the database names from config/database.yml</p>