title: MYSQL Dump only certain rows
body: <p>I am trying to do a mysql dump of a few rows in my database. I can then use the dump to upload those few rows into another database. The code I have is working, but it dumps everything. How can I get mysqldump to only dump certain rows of a table?</p>
  
  <p>Here is my code:</p>
  
  <pre><code>
  mysqldump --opt --user=username --password=password lmhprogram myResumes  --where=date_pulled='2011-05-23' > test.sql
  
  </code></pre>