-- mysqldump.txt

> mysqldump --where="state='NV'" --tab=. classfiles person

This produces two files:
  person.sql - contains SQL statements to recreate the table layout for the "person" table.
  person.txt - contains tab separated fields of the selected records from the "person" table.

Since the "--where" option was provided, the data only contains records for people in Nevada.

> rename person.txt person2

mysql> CREATE TABLE person2 LIKE person;

> mysqlimport --local classfiles person2

This reads the file "person2", and dumps the data into the table with the same name.

mysql> SELECT * FROM person2;