OT : MySQL and OUTFILE

[StinkFinger]

All,
I have an app that creates a text file of ip addresses, in text format, 1 ip
per line, i.e.

10.10.10.10
10.10.10.15
10.10.10.20
etc.

I am trying to get MySQL to dump out info from the db in the same format,
however, it creates the file with each address on 1 line, i.e.
10.10.10.10|10.10.10.15|10.10.10.20|etc <-- note the | character is a tab
in the output file

I use a batch file to run mysql from the command line, which calls the SQL
statement from an external file.

//batch file
mysql -hlocalhost -uroot -ppassword --database=db < ip.sql

//contents of ip.sql
SELECT ip INTO OUTFILE 'ip_dump.txt' FROM iptable

Any ideas ? Missing mysql parameters ?
Thanks.

[StinkFinger]

Well,
I was able to use LINES TERMINATED BY and line breaks were created, however,
I have a new problem now.
The original file is created via WriteLine and each entry is on its own
line, and is read in via ReadLine. The MySQL text file, even though it
contains \n's, doesn't read properly into the .NET app.

So, I need to update the .NET app now to correctly handle \n's instead of
relying on each entry on its own line. Argh.