I've spent a lot of time searching around for an answer here, but have been unable to find one. What I'm looking to do is to use "mysqldump" to export two specific fields form a certain table, rather than exporting the entire table. This table contains near 20 fields, but I just need two. The command I'm using so far is:
mysqldump -u USERNAME -p DATABASE --tables TABLE --xml > fields.xml
I just need to know now how to fine-tune it so I can specifiy the two tables I need. I plan to use this command to regularly backup this particular part of the database, and I'm unsure if that can be done via another method or not.
Thanks for any help,