List:General Discussion« Previous MessageNext Message »
From:Dan Nelson Date:April 4 2001 8:58pm
Subject:Re: field separator
View as plain text  
In the last episode (Apr 04), John Smith said:
> I've searched manyh places and can't get a good answer .. i hope I can get 
> help here.
> 
> I'm trying to dump all the data in my database to separate files (per table) 
> and be able to specify a field separator character.
> 
> for example, I'd like to use || as my field separator, I did the following:
> 
> >mysqldump -u root -p --tab --fields-enclosed-by='||' --no-create-info  myDB 
> > > output_file.txt
> 
> I get the folowing error:
> mysqldump: Got error: 1: Can't create/write to file 
> '/home/website/--fields-enclosed-by=||/alloc.txt' (Errcode: 2)

--tab takes an argument.

-- 
	Dan Nelson
	dnelson@stripped
Thread
field separatorJohn Smith4 Apr
  • Re: field separatorDan Nelson4 Apr