mysql export with partial data
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