How can I make a mysql dump for table from a query?
I need something like this..
mysqldump -uroot -pxxxx mydb "select * from table where name='1';" > /tmp/a
mysqldump has a
--where parameter: Manual
Dump only rows selected by the given WHERE condition. Quotes around the condition are mandatory if it contains spaces or other characters that are special to your command interpreter.
I don’t know what they use, but phpMyAdmin can do this too, Just make the query, select all rows and choose the "export" button to the bottom.
Answered By – Pekka
Answer Checked By – Dawn Plyler (BugsFixing Volunteer)