On Fri, 2006-10-27 at 11:16 -0500, Gerald L. Clark wrote: > Ow Mun Heng wrote: > > Hi, > > > > I'm trying to load some data from a primary MySQL DB into a VMware image > > for R&D purposes. > > Instead of doing a mysqldump of nearly 10G of data, I would like to just > > select a subset of it and load it into the VMware image. > > > > > man mysqldump > You will find it supports a where clause.
I really missed that. This works now.. mysqldump database_name drive -u user -ppassword --extended-insert --single-transaction --skip-add-locks -n -t -w"table_name.column_name like'A3747' limit 10000" > /tmp/test.sql Then use the resultant file and do a $mysql -u user -ppassword database_name < /tmp/test.sql Many Thanks. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]