-- Forwarded Message
From: John J. Rushford <[EMAIL PROTECTED]>
Date: Sun, 01 Sep 2002 00:04:08 -0600
To: <[EMAIL PROTECTED]>
Subject: Mysql 3.23.52 fails compile on OS X 10.2
Greetings,
Downloaded mysql 3.23.52 from the mysql web site and ran into compile
failures in the mysql client, the
Well I guess the first point to make is that you would not be so off topic
in the MyODBC list. I personally stay away from the "data" set of controls.
I stick to manually loading recordsets into boxes, and thus avoid problems
such as the one you point out. To do what you are doing, I would manuall
At 5:19 +0200 9/1/02, David Lloyd wrote:
>Paul et al,
>
>> At 18:59 -0400 8/31/02, qlarry wrote:
>> >here a file size limit in my sql
>>
>> What?
>
>I think that loosely should translate as "Where is a file size limit in
>MySQL" which I would then interpret as "Is there a file size limit in
>My
I am running version 3.23.51-log (built with -O3) on
FreeBSD-5.0-CURRENT on Alpha. InnoDB is on raw disk.
After a week of uptime it restarted by itself and the
message below was logged.
Looks like it was trying to allocate 4GB+0x1E bytes.
Machine has 2GB of physical memory + 1GB swap.
Database i
Paul et al,
> At 18:59 -0400 8/31/02, qlarry wrote:
> >here a file size limit in my sql
>
> What?
I think that loosely should translate as "Where is a file size limit in
MySQL" which I would then interpret as "Is there a file size limit in
MySQL".
All MyISAM tables are stored on the local fil
I've got a strange problem using VB to connect to a mysql database via ODBC.
The problem isn't with connecting, but rather with one particular control --
the "datalist/combo" control. In fact, the "problem" doesn't seem to have
anything to do with databases directly, BUT I figured that there is
s
Hi,
Perhaps try to upgrade first from 4.0.0 to 4.0.3 to see if the problem still
happens ? (many fixes have been introduced, especially on FT search)
Regards,
Jocelyn
- Original Message -
From: "Karl J. Stubsjoen" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, September 01,
Hello,
This is my 2nd post, not to sound pushy, just raising the urgency of my
dilemna. My table is crashing way to often (I'd like it to not crash at
all).
I'm not sure what to do, how to trouble shoot, and how to fix my problem. I
will post the structure of the table here, as well as the pert
Hi all,
does anyone have any experience with running MySQL on Red Hat Linux as a
back end to a web application written in Cold Fusion under VERY heavy load?
We're talking hundreds of thousands of hits per day.
I'm curious about how well the Merant MySQL ODBC driver performs under such
extreme co
Hey,
You can limit the size of the database by specifying a quota on the
directory created by MySQL for that database.
When you create a database, all MySQL does is create a directory under
the data directory for that database. You can then set a quota on that
directory using whatever tools you
On Sat, Aug 31, 2002 at 09:58:58AM -0400, Michael Bacarella wrote:
> We experienced a similar problem with 3.23.51 which went away
> once we compiled from source. Assume this is Linux 2.4?
I've also had good luck with 3.23.51 built from source. I build on a
Debian "testing" box and run the serve
Hi everyone,
I am running a FreeBSD server with MySQL 3.23
I want to let my virtual users create/drop tables and limit the size of each
table, and also the number of tables they can create.
Can someone please tell me how I can do this?
Is it possible wit applications such as webmin, or phpMyAdmin
At 18:59 -0400 8/31/02, qlarry wrote:
>here a file size limit in my sql
What?
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request
here a file size limit in my sql
> Wrong Sorting in arabic alphabets
>
> Hi,
>
> This bug is for Arabic alphabets.
>
> I am using mysql 32.23.52 under winxp
>
> The error is :
>
> When sorting a table ASC it puts the letter (mem
> ãíã)
> in the top.
>
> The letter (mem ãíã) is the 24 alphabets
>
> Exampl
Yes, Redhat's 2.4.18 kernel running on a Redhat 7.2 install.
I was going to try compiling from source, except that MySQL AB seems to warn
against that sort of thing on the releases page ("people experiencing data
corruption," etc.) and we also have a support contract with them which seems
to
At 13:37 -0700 8/31/02, [EMAIL PROTECTED] wrote:
>The 4.0.2 manual's mysqldump section says the mysqldump
>variables that can be set are "listed below", but I can't find them.
>
>Anybody know where they are, or what they are?
Just run mysqldump --help and it will show a list.
>Thanks
>
>Peter
>
The 4.0.2 manual's mysqldump section says the mysqldump
variables that can be set are "listed below", but I can't find them.
Anybody know where they are, or what they are?
Thanks
Peter
[filter fodder: sql, query]
-
Before po
On Fri, Aug 30, 2002 at 10:24:13PM -0700, Jefferson Cowart wrote:
> I just downloaded 3.23.52 from the mysql servers and the version of
> mysqlbinlog in there doesn't have the -d option you are talking about.
Yeah, looks like it's in 4.0.2 and later. I may have the patch still
floating around if
Just found a new one I really like. Does everything, create tables,
queries, etc. The best part is that you can create really nice formated
reports.
http://www.mysqlstudio.com/feature.php3
Jayne
- Original Message -
From: "neal" <[EMAIL PROTECTED]>
To: "mySQL" <[EMAIL PROTECTED]>
Sent: F
Here is the evil query:
SELECT DISTINCT * FROM b2posts WHERE 1=1 AND ID = 124 AND ((post_title
LIKE '%%') OR (post_content LIKE '') OR (post_title LIKE '%%') OR
(post_content LIKE '%%')) AND post_date < '2002-08-31 14:31:55' AND
post_category > 0 ORDER BY post_date DESC
Here's a structure dump of
Hello,
I was trying to create a simple perl program, where my domains where listed
followed by there DNS records.
But It loops once, and then ends with error DBD::mysql::st fetch failed:
fetch() without execute() at test.cgi line 61.
I thougt this was the easyest way to do so. But no.. Does anyo
Hello,
I was trying to create a simple perl program, where my domains where listed
followed by there DNS records.
But It loops once, and then ends with error DBD::mysql::st fetch failed:
fetch() without execute() at test.cgi line 61.
I thougt this was the easyest way to do so. But no.. Does anyo
At 18:16 +0930 8/31/02, David Lloyd wrote:
>H...
>
>( mysql, query )
>
>What permissions does a user need to issue:
>
>LOCK TABLES blah WRITE
>
>???
>
>I have a user which I have:
>
>GRANT ALL ON * TO user (blah blah)
>
>...but that user can't lock any tables. Only the mysql root user can...
>
I can supply a converter that will do this without having Access installed.
Contact my Sales Manager Joy Johnson at [EMAIL PROTECTED] who will let you have
a copy for £30.00 plus VAT (If in the EU)
Michael Johnson
Director
BPEnet Humphrey Consulting Limited
13 Austin Friars London EC2N 2JX
Tel +4
Michael, what compiler/version did you use?
Thanks,
--jeff
- Original Message -
From: "Michael Bacarella" <[EMAIL PROTECTED]>
To: "John Stanforth" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Saturday, August 31, 2002 6:58 AM
Subject: Re: 3.23.52 hitting system loads of 25+?
> We
Wrong Sorting in arabic alphabets
Hi,
This bug is for Arabic alphabets.
I am using mysql 32.23.52
The error is :
When sorting a table ASC it puts the letter (mem ãíã)
in the top.
The letter (mem ãíã) is the 24 alphabets
Example
1 ÌÑíÑ (first letter is jeem Ìíã - number 5 in
the al
On Sat, 2002-08-31 at 17:59, David Lloyd wrote:
> ( mysql, query )
> You have missed his point. He's asking Microsoft to support MySQL as a
> native backend.
I'm sorry if I was unclear, I'll try to clarify.
I created a db under Windows using Access, I backed the .mdb files up.
I have upgraded my
Andy,
( mysql, query )
> you could install MyODBC to write the tables directly from MS A. to MySQL
> via ODBC.
>
> Works ok and did a good job for me.
> > I've looked through the archives of this list but all methods of porting
> > a ms access db to mysql seem to require installing additional
At 16:17 +0200 8/31/02, Mertens Bram wrote:
>Hi,
>
>I've looked through the archives of this list but all methods of porting
>a ms access db to mysql seem to require installing additional software
>under Windows.
>
>Is there a tool available that converts an existing ms access db-file
>(*.mdb) int
you could install MyODBC to write the tables directly from MS A. to MySQL
via ODBC.
Works ok and did a good job for me.
Andy
- Original Message -
From: "Mertens Bram" <[EMAIL PROTECTED]>
To: "mysql mailing list" <[EMAIL PROTECTED]>
Sent: Saturday, August 31, 2002 4:17 PM
Subject: co
Hi,
I've looked through the archives of this list but all methods of porting
a ms access db to mysql seem to require installing additional software
under Windows.
Is there a tool available that converts an existing ms access db-file
(*.mdb) into something that can be imported into mysql?
I don'
We experienced a similar problem with 3.23.51 which went away
once we compiled from source. Assume this is Linux 2.4?
-M
On Sat, Aug 31, 2002 at 03:08:10AM -0700, John Stanforth wrote:
> Haven't been watching the list lately so forgive me if this has already been
> discussed here recently. Have
At 10:55 +0200 8/31/02, David Lloyd wrote:
>Paul,
>
>(mysql, query)
>
>> It *can* use TCP, but that's just the transport protocol through which
>> the replication information is processed. Replication can also be
>> done between two servers on the same host, using a UNIX socket or (on
>> a Wi
Hi,
I have two connections open to a mysql-nt server. I am using one
connection to add a field field to a table using the command
ALTER TABLE testtable ADD testfield int;
Now if I issue any query from the second connection, the mysql-nt daemon
crashes with a Dr.Watson error. The but if I
Christian Longberg wrote:
> I have just upgraded to mysql 4 to be able to perform delete queries
> with join statement. I have a simple query where I would like to delete
> a number of rows in tabel t1 depending on id's found in table t2. This
> doesn't seem to work and I just don't understand why
mos,
Friday, August 30, 2002, 7:04:25 PM, you wrote:
m> At 07:58 AM 8/30/2002, you wrote:
>>mos,
>>Thursday, August 29, 2002, 5:45:05 PM, you wrote:
>>
>> >>Start by looking at the MySQL documentation:
>> >>http://www.mysql.com/doc/en/Query_Cache.html
>> >>Read the entire 6.9 section.
>> >>
>> >>
Christian,
Saturday, August 31, 2002, 11:09:47 AM, you wrote:
CL> I have just upgraded to mysql 4 to be able to perform delete queries
CL> with join statement. I have a simple query where I would like to delete
CL> a number of rows in tabel t1 depending on id's found in table t2. This
CL> doesn't
Hi there,
Haven't been watching the list lately so forgive me if this has already been
discussed here recently. Have any of you seen an issue with MySQL 3.23.52
spiralling out of control after a minute or so of operation? We run a
fairly high-volume db, previously running 3.23.49a and upgradin
»ª±±ÆóÒµÃû¼http://www.rqhh.com
µÇ¼»ª±±ÆóÒµÍø£¬Äú¿ÉÒÔ
1.Ãâ·Ñ¼ÓÈëÆóÒµÃû¼
1.Ãâ·Ñ·¢²¼ÆóÒµÐÅÏ¢
2.Ãâ·Ñ·¢²¼¹©ÇóÐÅÏ¢
3.Ãâ·Ñ·¢²¼ÆóÒµÐÂÎÅ
´ËÍ⣬»ª±±ÆóÒµÍø»¹°üÀ¨£ºÊ±Ê±¨µÀ¡¢ÆóÒµ¶¯Ì¬¡¢Õþ²ß·¨¹æ¡¢ÐÅÏ¢²éѯµÈÀ¸Ä¿£¬ÊÇÄú¼°Ê±»ñÈ¡ÐÅÏ¢µÄ×î¼Ñ;¾¶¡£
Óʼ
Paul,
(mysql, query)
> It *can* use TCP, but that's just the transport protocol through which
> the replication information is processed. Replication can also be
> done between two servers on the same host, using a UNIX socket or (on
> a Windows box) a named pipe. The "replication protocol" i
H...
( mysql, query )
What permissions does a user need to issue:
LOCK TABLES blah WRITE
???
I have a user which I have:
GRANT ALL ON * TO user (blah blah)
...but that user can't lock any tables. Only the mysql root user can...
Version 4.0.2, built from source on RH 7.1.
DSL
--
Say
I have just upgraded to mysql 4 to be able to perform delete queries
with join statement. I have a simple query where I would like to delete
a number of rows in tabel t1 depending on id's found in table t2. This
doesn't seem to work and I just don't understand why!?
mysql> delete icl from ca_x_in
43 matches
Mail list logo
