mysql dump of talble limit 100

Question

I want to take a dump of a database, but the condition is to have only 100 records from each table in the DB?

Lekensteyn · Answer 1 · 2010-08-24 10:24:48Z

up vote 3 down vote

I found a small hack for doing that in the MySQL manual (comment):

mysqldump -u [username] -p [dbname] {--opt} --where="true limit 100" > dump.sql

answered Aug 24 '10 at 10:24

	That's hideous and hilarious. Well-played. And here I was writing a script! – BMDan Aug 24 '10 at 10:26
	People can be really creative in finding solutions :D Like that proverb, all roads lead to Rome. – Lekensteyn Aug 24 '10 at 10:29
	I'm starting to believe that in shell every problem can be solved in one line. – Janne Pikkarainen Aug 24 '10 at 12:32

feedback

1 Answer