title: Forking/Copying Heroku ClearDB to development environment
body: <p>I'm setting up a development environment on heroku for my app and I'm having an issue copying over the DB. My current DB is ClearDB and I usually connect to it via Workbench. However, if I try to export the DB and iimport into my staging environment I get a credential issue.</p>
  
  <p>I found this post on SO with regards to this issue:
  <a href="https://stackoverflow.com/questions/12334938/moving-copying-one-remote-database-to-another-remote-database">Moving/copying one remote database to another remote database</a></p>
  
  <p>And the solution is here:</p>
  
  <pre><code>mysqldump --single-transaction -u (old_database_username) -p -h (old_database_host) (database_name) | mysql -h (new_host) -u (new_user) -p -D (new_database)
  </code></pre>
  
  <p>But even if I run this, I'm still running into an issue with credentials. The execution wants both passwords at the same time, for old DB and new DB so it keeps failing.</p>
  
  <p>I tried to inline the -p but it still asks for password. What am I missing?</p>