MYSQL Dump only certain rows

Question

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?

Here is my code:

mysqldump --opt --user=username --password=password lmhprogram myResumes  --where=date_pulled='2011-05-23' > test.sql

Answer 1

Try fixing your --where option. But, it should be a valid SQL WHERE clause like this:

--where="date_pulled='2011-05-23'"

As you have the column name outside of the quotes.