MySQL Dump command on Windows

[hawk sury]

Dear All,

I am running the following mysqldump command to backup one of the tables.

mysqldump -u root -p --compatible=db2 mydatabase mytable>C:\backup\mytable

It actually works fine and generates a backup file. The problem is that it un-necessarily adds a '\n'prefix to the every first column element of each row.
(Apart from the very first element of the first column)

The output is as following,

Insert into mytable Values (id, europe,100),(\nid2,europe,102),
(\nid3,europe,103) ........... and so on

The \n is added by mysql unnecessarily. I have come across something called --result-file option in mysqldump, but i am not sure if that will solve this and I also don't how to use --result-file option.

I would appreciate if you could help.

Thanks for reading,

hawksury