Linux Ask!

Linux Ask! is a Q & A web site specific for Linux related questions. Questions are collected, answered and audited by experienced Linux users.

Feb 012010
 

Export only a subset of table using mysqldump

Answer:

Dump a subset of table is possible with mysqldump

E.g.

# mysqldump my_db my_table -w"id>10"

The above command will dump all the rows in the table "my_table", where the field id is greater than 10.

 Leave a Reply

(required)

(required)

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>