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.
3 messages in com.mysql.lists.mysqlRe: Mysql -e "Select" Fields Enclosed...