partial dump

by kalai 2009-07-21 11:07:26

You can create dump of partial table by using where condition in mysql.

Syntax:
mysqldump -u root -p database-name table-name -w"condition" > database-name

Example:
mysqldump -u root -p conif_new sitemap -w"sid<10000" > conif_new

Tagged in:

3320
like
3
dislike
0
mail
flag

You must LOGIN to add comments