Limiting the number of records from mysqldump?

Phil picture Phil · Sep 25, 2008 · Viewed 62.3k times · Source

I am trying to load a small sample of records from a large database into a test database.

How do you tell mysqldump to only give you n records out of 8 million?

Thanks

Answer

Adam Bellaire picture Adam Bellaire · Sep 25, 2008

As skaffman says, use the --where option:

mysqldump --opt --where="1 limit 1000000" database

Of course, that would give you the first million rows from every table.