sql - MySQL dump by query - Stack Overflow

not mysqldump, but mysql cli... mysql -e "select * from myTable" -u myuser -pxxxxxxxxx mydatabase you can redirect it out to a file if you want : ... you could just create a new table for the query (CREATE TABLE SELECT), and then dump that table with ...

stackoverflow.com