Re: [Fwd: search issue] mysqlimport problem with , inside fields

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? -- View this message in context: http://www.nabble.com/mysqlimport-problem-with-%2C-inside-fields

mysqlimport problem with , inside fields

I've been trying to import fields that contains the comma character ',' inside double quotes '', with the results following: code mysqlimport --fields-optionally-enclosed-by= --fields-terminated-by=, --lines-terminated-by=\r\n --ignore-lines=1 --user=root --password shark c:\documents and

Re: mysqlimport problem with , inside fields

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

mysqlimport problem.

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,

Re: mysqlimport problem

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

mysqlimport problem

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