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
Phillip Mangwiro wrote:
Egor Egorov wrote:
"Phillip Mangwiro" <[EMAIL PROTECTED]> wrote:
I'm getting an Error 1130, ("MyDNSName is not allowed to connect to this
machine"), whenever I try to connect to MySQL server from any client by
using its IP or "friendly" DNS name other than 127.0.0.1 or local
Egor Egorov wrote:
"Phillip Mangwiro" <[EMAIL PROTECTED]> wrote:
I'm getting an Error 1130, ("MyDNSName is not allowed to connect to this
machine"), whenever I try to connect to MySQL server from any client by
using its IP or "friendly" DNS name other than 127.0.0.1 or localhost.
This has happen
"Phillip Mangwiro" <[EMAIL PROTECTED]> wrote:
> I'm getting an Error 1130, ("MyDNSName is not allowed to connect to this
> machine"), whenever I try to connect to MySQL server from any client by
> using its IP or "friendly" DNS name other than 127.0.0.1 or localhost.
> This has happened on three m
Is the MySQL server running? What OS are you using?
-Original Message-
From: Angela Howley
To: [EMAIL PROTECTED]
Sent: 6/24/04 7:13 AM
Subject: connection error
Hi,
I have spent the last two days trying to configure PHP 4.3.7 & MySQL
4.0.20 - none of which is successful.
The error I ha
At 8:08 PM +1200 9/13/03, Robert Morgan wrote:
I have created a user grant all privileges on *.* to user@"%"
=>identified by ' pword' with
grant option;
and grant all privileges on *.* to
[EMAIL PROTECTED]
Robert,
On Sat, Sep 13, 2003 at 08:08:48PM +1200, Robert Morgan wrote:
> I have created a user grant all privileges on *.* to user@"%"
> =>identified by ' pword' with grant option;
>
> and grant all privileges on *.* to [EMAI
At 14:37 -0800 3/10/03, DuSTiN KRySaK wrote:
Hi there - I'm truing to connect to a mysql server (redhat linux 8) with the
mysqlcc GUI (through a SSH session), and for some reason when I try to
connect I get the error:
[localhost] ERROR 2002: Can't connect to local MySQL server through socket
'/tmp/
On Thu, 11 Jan 2001, John W Cunningham wrote:
> Hi,
>
> I just installed MySQL via rpms on a fresh installation of Redhat 7 pro
> server. It seems fine at first and it seems to be running. When I check
> the process with: ps aux |grep mysql, I get:
> root 925 0.0 0.4 1516 588 pts/0
- Original Message -
From: "John W Cunningham" <[EMAIL PROTECTED]>
To: "MySQL List" <[EMAIL PROTECTED]>
Sent: Friday, January 12, 2001 12:48
Subject: Connection error with fresh installation on RedHat 7
> Hi,
>
> I just installed MySQL via rpms on a fresh installation of Redhat 7 pro
>
16 matches
Mail list logo