title: How to dump a single table in MySQL without locking?
body: <p>When I run the following command, the output only consists of the create syntax for 'mytable', but none of the data:</p>
  
  <pre><code>mysqldump --single-transaction -umylogin -p mydatabase mytable &gt; dump.sql
  </code></pre>
  
  <p>If I drop --single-transaction, I get an error as I can't lock the tables.</p>
  
  <p>If I drop 'mytable' (and do the DB), it looks like it's creating the INSERT statements, but the entire DB is huge.</p>
  
  <p>Is there a way I can dump the table -- schema &amp; data -- without having to lock the table?</p>
  
  <p>(I also tried INTO OUTFILE, but lacked access for that as well.)</p>