Dear Guys,
I have been stucked in loading file using load data local infile command.
At first it is loading a null value on my first record followed with
one record from my input file. The rest are ignored and i've been
receiving lots of warnings.
I tried converting the text file into a csv
Your syslog8.txt file has two problems:
1. The first field, log_date, is in m/d/ format. It will not be
converted by MySQL automatically. It needs to be in -mm-dd format.
For this reason, all records will have the default value of '-00-00'
for that field.
2. The primary key
Hello.
Send an example of your file and your table's definition
(use SHOW CREATE TABLE for this purpose). Please, next time
send your replies to the list.
Hope you're doing great today. Back to my question last week, I've
been encountering this problem of loading my file using the
Dear Gleb,
Thanks, i will try that as well, so far my program can access the
server now by using the old password. Now my problem is when i load
file, its only reading the first line and some more insert a null
record before the ist record.
here is the result i get after loading the text file:
Hello.
What 'SHOW WARNINGS' reports?
Elizabeth Bonifacio [EMAIL PROTECTED] wrote:
Dear Gleb,
Thanks, i will try that as well, so far my program can access the
server now by using the old password. Now my problem is when i load
file, its only reading the first line and some more
Dear All,
I'm new into mysql and has been encountering huge problem in
connecting to the database from the c application. The code execute
with an error message :
Failed to connect to database: Error:
Client does not support authentication protocol requested by server;
consider upgrading MySQL
I guess this is a problem with the version of the C client Libraries
that you are using, because of the way 4.1.x version of mysql stores
the hash value of the password using the PASSWORD( ) function, so when
you are giving the password embedded in the C code, may be the server
does not match it
Hello.
I've compiled your code using libraries and includes from
MySQL-4.1.6 (yes, my testing environment isn'tperfect :) and
successfully connected to MySQL-4.1.10. Old passwords was off,
so I used a 4.1. authorization protocol.
Elizabeth Bonifacio [EMAIL PROTECTED] wrote:
Dear All,
Hi all,
I am connecting to mysql through an application and I get this error
message:
java.sql.SQLException: Server configuration denies access to data source
Can anyone point me in the right direction?
Thanks in advance,
-Scott