Limiting the number of records from mysqldump?
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.
mysqldump
MySQLDump one INSERT statement for each data row
Use: mysqldump –extended-insert=FALSE Be aware that multiple inserts will be slower than one big insert.