I am using mysqlimport to import files into mysql under windows. I don't know what operating system the files were created. They look like tab delimited files in notepad but I notice they contain the \N character a lot. Here is some data from the file
I am guessing the files were written in unix and the \N is an end of line character. Will mysqlimport running on windows interpret the \N as a new line? Perhaps I need to use a flag in the import command? I know there are some flags to handle end of line characters.
What does the -L flag do? The manual says it means 'read all input through the client'
Is that flag relevant to this issue?