CODEWITHSUNDEEP
mysql
cwallenpoole
cwallenpoole

Reputation: 81988

Export subset of MySQL database

So my client has a database with a minimum of several million entries across several dozen tables. I don't need all of their information, and I don't want it. But, I do need to have data from each of their several dozen tables so that I can test their site locally. What can I do to export, say, the first five rows of every table?

Upvotes: 3

Views: 1083

Answers (1)

scwagner
scwagner

Reputation: 4005

Found this blog post which suggests the following:

mysqldump --opt --where="true LIMIT 100" dbname > dbname.sql

Upvotes: 2

Related Questions