"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 options, but > this results in a separate txt file for each table. > > Is there any way to persuade mysqldump to produce one file (with "insert > into" statements) and also use Windows style line endings? > > > TIA - Adam > The manual explains that using the -r option will avoid exactly what you are trying to create. If you reverse that and not use the -r (--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. mysqldump (options) > dumpfile.txt An alternative is to use ANY other text editor than NOTEPAD.EXE (wordpad, word, visual studio, etc.) and it won't matter if you get the LF or not. Shawn Green Database Administrator Unimin Corporation - Spruce Pine
