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