title: Dump sql file to ClearDB in Heroku
body: <p>I have a sql file that I want to be dumped into a MySQL database that I have in Heroku using the ClearDB addon.  When dumping in local I do the following:</p>
  
  <pre><code>mysql -u my_user -p mydatabasename &lt; my_dump_file.sql
  </code></pre>
  
  <p>However, I don't have any clue on how to dump it to the Heroku MySQL database. All I know is this address:</p>
  
  <pre><code>mysql://b5xxxxx7:37xxxad@us-cdbr-east.cleardb.com/heroku_xxxxxx?reconnect=true
  </code></pre>
  
  <p>But if I try to do:</p>
  
  <pre><code>mysql://b5xxxxx7:37d8faad@us-cdbr-east.cleardb.com/heroku_xxxxxx?reconnect=true &lt; my_dump_file.sql
  </code></pre>
  
  <p>I get <code>No such file or directory</code>.</p>
  
  <p>How am I supposed to do it?</p>