Thank you for the idea. It fixed my date problem, but my numeric column is
still 0 and NOT NULL. Here's what I did:
create table a (
d date default null,
e smallint default null );
CREATE TEMPORARY TABLE tmp (
d TEXT not NULL,
e TEXT not NULL );
LOAD DATA LOCAL INFILE
Stupid filter fodder: sql,query,queries,smallint
-Original Message-
From: Dean Householder [mailto:[EMAIL PROTECTED]]
The problem is with the new glibc-2.2.5-40 package released
on October 3,
2002. Apparently its a known issue, and people are aware of
it. The best
David,
Wednesday, November 06, 2002, 10:00:45 PM, you wrote:
DAF - Original Message -
DAF From: Victoria Reznichenko [EMAIL PROTECTED]
DAF To: [EMAIL PROTECTED]
DAF Sent: Wednesday, November 06, 2002 11:47 AM
DAF Subject: re: Problem creating InnoDB tables.
David,
Tuesday, November
Hello Lance,
Wednesday, October 23, 2002, 4:16:16 PM, you wrote:
LU I have /tmp symlinked to /var/tmp, and /var is a writable partition,
while /
LU is readonly. When / is readonly mysqld is not able to run.
LU I've tracked down the problem to the safe_mysqld script. The problem is it
LU does:
Lance,
Wednesday, October 23, 2002, 3:23:10 AM, you wrote:
LU I have /tmp symlinked to /var/tmp, and /var is a writable partition, while /
LU is readonly. When / is readonly mysqld is not able to run.
LU I've tracked down the problem to the safe_mysqld script. The problem is it
LU does:
LU
At 03:29 PM 10/23/02 +0300, Egor Egorov wrote:
Lance,
Wednesday, October 23, 2002, 3:23:10 AM, you wrote:
LU I have /tmp symlinked to /var/tmp, and /var is a writable partition,
while /
LU is readonly. When / is readonly mysqld is not able to run.
LU I've tracked down the problem to the
Tam,
Thursday, July 25, 2002, 7:35:20 PM, you wrote:
T Hi Victoria,
T Thanks. Does this mean in the future the -max version would be merged into
T one release or just for the 4.0.2a??
Most likely yes.
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email
PROTECTED]
Subject: Re: RE: Problem downloading MySQL4.0.2a for windows
Tam,
Tuesday, July 23, 2002, 9:38:17 PM, you wrote:
T Hi Victoria,
TDo you know when the 4.0.2a-MAX would be available for download then?
T Thank you.
Use mysql-win-4.0.2-alpha.zip instead. It the same as with -max
Tam,
Tuesday, July 23, 2002, 9:38:17 PM, you wrote:
T Hi Victoria,
TDo you know when the 4.0.2a-MAX would be available for download then?
T Thank you.
Use mysql-win-4.0.2-alpha.zip instead. It the same as with -max.
--
For technical support contracts, goto
Neville,
Tuesday, May 28, 2002, 11:23:06 AM, you wrote:
NL this is the error message I get
NL Can't connect to local MySQL server through socket
NL '/var/lib/mysql/mysql.sock' (2)
NL Why is this ?
Check permissions on the MySQL datadir. Look also into the .err file
in the MySQL data dir you
At 23:34 -0500 4/20/02, Darren Vollmer wrote:
Both files are world readable.
How do you know this?
Because FTP tells me they are.
Also, when you say client machine, what do you mean? In particular,
are the web server and the MySQL servers running on the same machine?
Client
Darren,
Saturday, April 20, 2002, 1:23:54 PM, you wrote:
DV The file does exist. The file and its directory are 0777 permission.
Such permissions are setting on all dirs, that contain path to your
dir?
Don't forget that you should have permissions to go through dirs ...
DV Darren
--
For
Darren,
Saturday, April 20, 2002, 2:34:06 PM, you wrote:
DV The file is in a world readable directory tree.
DV Shouldn't the LOCAL qualifier make mysql read the file from the client
DV running and not the host?
DV I tried to LOAD DATA LOCAL INFILE on using the name (and no path) of a mysql
DV
Subject: Re: Re: problem with load data local infile
Darren,
Saturday, April 20, 2002, 1:23:54 PM, you wrote:
DV The file does exist. The file and its directory are 0777 permission.
Such permissions are setting on all dirs, that contain path to your
dir?
Don't forget that you should
Message -
From: Fiasco [EMAIL PROTECTED]
To: Paul DuBois [EMAIL PROTECTED]
Sent: Saturday, April 20, 2002 7:28 PM
Subject: Re: Re: problem with load data local infile
The error I receive is:
Can't stat file 'filename' (errcode 2)
It can't stat *filename*? Don't make up error
Both files are world readable.
How do you know this?
Because FTP tells me they are.
Also, when you say client machine, what do you mean? In particular,
are the web server and the MySQL servers running on the same machine?
Client machine is the machine running the webserver and MySQL
PROTECTED]; [EMAIL PROTECTED]
Subject: Re: Re: Problem with MySQL, ODBC, MS Access
Hi,
Can anyone help me please? I´m writing my diploma and this database is my
project. I´m running out of time and when this problem doesn´t
disappear...
Please help me.
I´ve created a small database
PROTECTED]
Subject: Re: Re: Problem with MySQL, ODBC, MS Access
Sorry I´ve tried it but I didn´t succeed. When writing: update
tPruefBesch set fdatetime = fTimestamp, datetime and timestamp wont have
the same value. I don´t know why, but there is the same fault.
I´ve created a small database
Sorry I´ve tried it but I didn´t succeed. When writing: update
tPruefBesch set fdatetime = fTimestamp, datetime and timestamp wont have
the same value. I don´t know why, but there is the same fault.
I´ve created a small database to show my problem.
That´s my table in MySQL 3.23.41.
create
Arjen == Arjen G Lentz [EMAIL PROTECTED] writes:
Arjen Hi,
Arjen - Original Message -
Arjen From: AJ [EMAIL PROTECTED]
Ver 11.15 Distrib 3.23.46, for pc-linux-gnu (i686)
The problem that has cropped up I have is that in all GROUP BY column
DESC
statements, the DESC is now
Hi,
- Original Message -
From: AJ [EMAIL PROTECTED]
Ver 11.15 Distrib 3.23.46, for pc-linux-gnu (i686)
The problem that has cropped up I have is that in all GROUP BY column
DESC
statements, the DESC is now not being recognized, and the query is being
returned in ascending
Tried doing isamchk on the .ISM files and got that following error
The Exception Integer division by zero
(0xc094) occured in the application at the location 0x0040224a.
thanks
- Original Message --
indrek siitan [EMAIL PROTECTED] wrote:
To:Prachi Nadgouda [EMAIL
Hi,
Tried doing isamchk on the .ISM files and got that following error
The Exception Integer division by zero
(0xc094) occured in the application at the location 0x0040224a.
getting such errors usually means you've got hardware (bad memory?)
or some serious software installation
Can you please elaborate on how can I correct this problem. I have windows nt on my
machine. OR is there and problem with the installation of my sql
bye
p
- Original Message --
indrek siitan [EMAIL PROTECTED] wrote:
To:Prachi Nadgouda [EMAIL PROTECTED], [EMAIL
24 matches
Mail list logo