title: Run MySQLDump without Locking Tables
body: <p>I want to copy a live production database into my local development database.  Is there a way to do this without locking the production database?</p>
  
  <p>I'm currently using:</p>
  
  <pre class="lang-none prettyprint-override"><code>mysqldump -u root --password=xxx -h xxx my_db1 | mysql -u root --password=xxx -h localhost my_db1
  </code></pre>
  
  <p>But it's locking each table as it runs.</p>