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 on
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
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
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
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:
my
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
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 wi
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 cli