Mysqldump INSERT statements (Was Mysqldump line endings)

2005-12-14 Thread Adam Lipscombe
>> (--result-file) option to save your output but use the > output redirector >> to map the output of mysqldump to a file you specify, you will get the >>CRLF line endings you seek. Many thanks. One more thing: by default mysqldump uses --extended-insert=TRUE. This results in all the VALUES

Re: Mysqldump line endings

2005-12-13 Thread SGreen
"Adam Lipscombe" <[EMAIL PROTECTED]> wrote on 12/13/2005 01:34:45 PM: > Folks > > By default mysqldump uses linefeed as the line ending. This results in the > data looking odd in a Windows text editor, as they expect \r\n. > > I have experimented with the --tab and --line-terminated-by option

Mysqldump line endings

2005-12-13 Thread Adam Lipscombe
Folks By default mysqldump uses linefeed as the line ending. This results in the data looking odd in a Windows text editor, as they expect \r\n. I have experimented with the --tab and --line-terminated-by options, but this results in a separate txt file for each table. Is there any way to persu