Mysql -e Select Fields Enclosed By and NULL values

2006-10-27 Thread Ow Mun Heng
Hi, I'm trying to load some data from a primary MySQL DB into a VMware image for RD 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. I'm facing a snag with regard to NULL values. I've tried doing $mysql

Re: Mysql -e Select Fields Enclosed By and NULL values

2006-10-27 Thread Gerald L. Clark
Ow Mun Heng wrote: Hi, I'm trying to load some data from a primary MySQL DB into a VMware image for RD 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

Re: Mysql -e Select Fields Enclosed By and NULL values

2006-10-27 Thread Ow Mun Heng
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 RD 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