OSEC

Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email hr@neohapsis.com
 
Mysqldump line endings

From: Adam Lipscombe (adam.lipscombequcs.co.uk)
Date: Tue Dec 13 2005 - 12:34:45 CST


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

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql