How to use mysqldump for a portion of a table?

mysqldump -uroot -p db_name table_name --where="id<1000000"

or you can use

SELECT * INTO OUTFILE 'data_path.sql' from table where id<100000