List:General Discussion« Previous MessageNext Message »
From:Ow Mun Heng Date:October 27 2006 4:46pm
Subject:Re: Mysql -e "Select" Fields Enclosed By and NULL values
View as plain text  
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.

Thread
Mysql -e "Select" Fields Enclosed By and NULL valuesOw Mun Heng27 Oct
  • Re: Mysql -e "Select" Fields Enclosed By and NULL valuesGerald L. Clark27 Oct
    • Re: Mysql -e "Select" Fields Enclosed By and NULL valuesOw Mun Heng27 Oct