Scott Hamm wrote:
>
> Line 48:
>
> "48", "14.729606", "10.1.1.22", "10.182.167.209", "TCP", "pop3 >
> [SYN,
> ACK] Seq=0 Ack=1 Win=16384 Len=0 MSS=1460"
>
Is the line 48 is different than other lines?
-
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
I've been trying to import fields that contains the comma character ','
inside double quotes '"', with the results following:
mysqlimport --fields-optionally-enclosed-by=""" --fields-terminated-by=,
--lines-terminated-by="\r\n" --ignore-lines=1 --user=root --password shark
"c:\documents and set
> 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
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 tried yet, bu
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
Hi,
I been using mysqlimport for a long time with no problems.
But today when I try (as root)
mysqlimport admin /usr/local/systems/admin/data/person.txt -p
I get
mysqlimport: Error: Can't get stat of
'/usr/local/systems/admin/data/person.txt' (Errcode: 13), when using
table:
person
even thou
