Hey Scott -
I dont think you can use , with mysqlimport as a field separator if it is
part of the data. use something else - I used the pipe | character...
This is what worked for me:
C:\>mysqlimport --fields-enclosed-by=""" --fields-terminated-by=|
--lines-terminated-by="\r\n" --ignore-lines=1
> Greetings,
>
> I have an application that creates an SQL file from the data it
> produces, but in some of that data, there might be a , or ' which
> mysqlimport does not like. I need to use the mysqlimport utility, and I am
> wondering if there is a way around this. I admit I have not tr
Scott,
Tuesday, April 9, 2002, 6:20:38 PM, you wrote:
SA> I been using mysqlimport for a long time with no problems.
SA> But today when I try (as root)
SA> mysqlimport admin /usr/local/systems/admin/data/person.txt -p
SA> I get
SA> mysqlimport: Error: Can't get stat of
SA> '/usr/local/syste
