• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1045
  • Last Modified:

mysqldump Only Some Records Because Database is So Large

I am setting up a development system and need some critical tables, many of them which only contain 100 or less rows. Some of the tables contain GB of info that I don't wan to copy over. I have done mysqldump to get just the schema, is there any way to limit the table data dump to let's say 1000 rows for each table? Or maybe just grab the info from the tables that contain less than 1000 rows?
0
dignified
Asked:
dignified
1 Solution
 
Muhammad WasifCommented:
If you know the table names which contain less rows, mention them in when taking dump.

If you have phpmyadmin then you can dump your required rows. But you have to  perform this operation on each table separately.
0
 
dignifiedAuthor Commented:
Yeah I was afraid of this. Since the databases are on the same system it isn't too bad. Just have to write a php script or something to do it.
0

Featured Post

Become an Android App Developer

Ready to kick start your career in 2018? Learn how to build an Android app in January’s Course of the Month and open the door to new opportunities.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now