partial dump
by kalai[ Edit ] 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