Categories
mysql mysqldump

How to use mysqldump for a portion of a table?

So I can export only a table like this:

mysqldump -u root -p db_name table_name > table_name.sql

Is there any way to export only a portion of a table with mysqldump? For example, 0 – 1,000,000 rows, 1,000,000 – 2,000,000 rows, etc.

Should I do this with mysqldump or a query?

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