mysql export with partial data How do I export the structure of a mysql database I have, keeping the structure for all the tables but only exporting the data for some of the tables?
After exporting how do I import it into another mysql database on a different machine.

I can have the list of table names if it helps and I would prefer it if the solution will use command line but GUI is also acceptable (on windows). 

Thanks
1. To dump only table structures

a. dump

mysqldump -d -u root -p"password" --all-databases &gt; /tmp/dumpfile.sql


b. restore

mysql -u root -p "password" "dbname" &lt; /tmp/dumpfile.sql


2. To dump only data not structure

a. dump  

mysqldump -uroot -p"password" --no-create-info "Db" "TableName"&gt; /tmp/dumpfile.sql


b. restore

mysql -u root -p password "dbname" &lt; /tmp/dumpfile.sql


3. To dump inserts only for specific Columns

a.dump

mysqldump -t -uroot -p"pawword" "Db" "TableName" --where =”Columnname in (1,2)” &gt; /tmp/dumpfile.sql


b. Restore

mysql -u root -p password "dbname" &lt; /tmp/dumpfile