Mysqldump by date range or first X entries?

If I have a large database with hundreds of tables, and I only want to mysqldump the data from the first month, how would I do that?

Also acceptable w开发者_JS百科ould be the first X entries in the DB.

Thanks

You can specify a "where" condition on the command line.

See the manual: --where