Well I was able to fix the problem by doing a Select into Outfile and specifying in my select list and using IF...
thanks ----- Original Message ----- From: "Paul DuBois" <[EMAIL PROTECTED]> To: "David M. Peak" <[EMAIL PROTECTED]>; "MySQL List" <[EMAIL PROTECTED]> Sent: Thursday, March 21, 2002 4:24 PM Subject: Re: Can you Change Nulls in the MySQLDump from \N? > At 12:11 -0800 3/21/02, David M. Peak wrote: > >Is there a way to tell MySQL to put a blank space instead of \N in the > >tab-delimited files when it does a dump? > > Nope. You'll have to postprocess the files somehow. > > > I'm working on a MySQL to SQL > >Server migration and having problems with the output files. I'm doing this > >all in batch fellas so I'm not finding a good search and replace utility. > >(perl, c++, and other langs are not an option..) > > > >Thanks > > > >David > > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php