Re: Auto-configuration of my.cnf?

[Mike Wexler]

Jeremy Zawodny wrote:

>On Tue, Apr 23, 2002 at 08:26:23PM -0500, JW wrote:
>
>>-BEGIN PGP SIGNED MESSAGE-
>>Hash: SHA1
>>
>>Hello,
>>
>>Some time ago I set up a rather large mySQL server with InnoDB and
>>had a hard time customising my.cnf.
>>
>>At the time there was some discussion of createing a tool that
>>someone could enter their hardware info into and get a customised
>>configuration i.e. a my.cnf "calculator".
>>
>
>I remember that, yes.
>
>>Has any work been done on that?
>>
>
>Yes. :-)
>
>>I'm setting up an even bigger server this time (Quad Xeon, 8GB RAM)
>>and I must be figuring something wrong, because I'm comming up with
>>nearly the same figures I had for my dual PIII/2GB RAM.
>>
>
>Wow, that's a hard-core server.
>
>>If no ones working on the conf generator, is there any interest in
>>it still?
>>
>>If anyone is working on it, who? :-)
>>
>
>Me.
>
>If you'd like to chat about this off-list, just let me know.
>
I'd like to.

>
>
>Jeremy
>




-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

FW: MySQL with Delphi 5.0

[RBRoa]

R.B.Roa
PhilCom Corporation
Tel. No. 858-
Mobile No. (63) (919-xxx)



-Original Message-
From:   Roa, Rosel B. 
Sent:   Wednesday, April 24, 2002 2:01 PM
To: '[EMAIL PROTECTED]'
Subject:RE: MySQL with Delphi 5.0

Use WinZEOZits free and friendly...I use it too...

MySQL+DELPHI 6.0+WinZEOZ=high speed client development



R.B.Roa
PhilCom Corporation
Tel. No. 858-
Mobile No. (63) (919-xxx)



-Original Message-
From:   [EMAIL PROTECTED] 
[SMTP:[EMAIL PROTECTED]]  
Sent:   Wednesday, April 24, 2002 1:34 PM
To: José
Cc: MySQL
Subject:RE: MySQL with Delphi 5.0


Hi Jose,

In the portal and contrib section of the MySQL website there is
several direct API's to MySQL.  I propose you use one of these, although
dbExpress is a nice idea it is not dedicated and developed only for MySQL
and thus works poorly.

Our own components is also available at:
http://www.scibit.com/MySQLCOMPONENTS
  and is working ONLY with MySQL,
v3.21.x to v4, since December 1999.  Today it is Single Source and you thus
use the same source code for Delphi 5/6 and Kylix 1/2.  We and our users
uses these components for a number of years now and it is implemented in
many production systems and real-time systems, etc.

Kind Regards
SciBit MySQL Team

> 
> -Original Message-
> From: "José" <[EMAIL PROTECTED]
 >
> To: "[EMAIL PROTECTED]  "
<[EMAIL PROTECTED]  >
> CC: 
> Subject: MySQL with Delphi 5.0
> Sent: Tue, 23 Apr 2002 13:51:42 GMT
> Received: Tue, 23 Apr 2002 14:07:46 GMT
> Read: Sat, 30 Dec 1899 00:00:00 GMT
> I've installed MyODBC and then I've set up ODBC and I saw the
driver for 
> MySQL DB, when I try to create a new alias wiht MySQL it does not
apear to 
> select the DB, acording a book wich is guiding it should has to
appear.
> 
> Can anybody help to set up the ALIAS with MySQL 
> 
> Thanks 
> 
>  
> 
> José Haroldo Filho
>  Gerência de TI
> 
>
-
> Before posting, please check:
>http://www.mysql.com/manual.php
(the manual)
>http://lists.mysql.com/ 
(the list archive)
> 
> To request this thread, e-mail <[EMAIL PROTECTED]
 >
> To unsubscribe, e-mail
<[EMAIL PROTECTED]
 >
> Trouble unsubscribing? Try:
http://lists.mysql.com/php/unsubscribe.php
 
> 
> 



-
Before posting, please check:
   http://www.mysql.com/manual.php 
(the manual)
   http://lists.mysql.com/ (the
list archive)

To request this thread, e-mail <[EMAIL PROTECTED]
 >
To unsubscribe, e-mail
<[EMAIL PROTECTED]
 >
Trouble unsubscribing? Try:
http://lists.mysql.com/php/unsubscribe.php
 

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Circular replication

[Heikki Tuuri]

Hi!

- Original Message -
From: ""Madscientist"" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.mysql
Sent: Tuesday, April 23, 2002 10:44 PM
Subject: Circular replication


> Hi,
>
> We're doing something weird (what else is new). We're hoping to use
> MySQL as the base of a distributed database with peer replication. Most
> of the peering and control mechanisms will be in the core application
> code, but we're counting on MySQL's ability to replicate for some of the
> lower-level peer synchronization mechanisms. It appears from the docs
> that most of this will be straightforward, however it is not clear (or I
> missed it) if replication works with all table types.
>
> This is important because the issue of complex transactions has recently
> come up and we may need to use innodb tables.
>
> It is not entirely clear wether replication will work with innodb
> tables.
> We're hoping to use MySQL 4.x

MySQL replication works with InnoDB tables. Currently MySQL replication does
not support transactions completely, because commit marks are not written to
the binlog and the slave runs in the auto-commit mode. Thus a reader on the
slave may see half a transaction in his query. This restriction may be
removed soon because a potential license customer wants the commit marks to
the binlog.

> Can we build reliable, circular replication with innodb tables in MySQL?
>
> We will have the application pick a single master node for any
> particular table and/or database until all nodes are synchronized...
> Then the app will vote for a new master if needed.
>
> For example.
>
>NODE1   NODE2NODE3
>MASTER OF A MASTER OF B  MASTER OF C
>
> ...--->[ ABC ]>[ ABC ]->[ ABC ]...
>
> Will this work with innodb.
> If not directly, then how?

If circular replication requires that several nodes are updated at the same
time, then you will bump into the inherent consistency/performance problems
of distributed databases. These problems are not specific to MySQL or
InnoDB, but to distributed transactions in general.

> Thanks in advacnce,
> _M

Best regards,

Heikki Tuuri
Innobase Oy
---
InnoDB - transactions, row level locking, and foreign key support for MySQL
See http://www.innodb.com, download MySQL-Max from http://www.mysql.com




-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

RE: MySQL with Delphi 5.0

[[EMAIL PROTECTED]]

Hi Jose,

In the portal and contrib section of the MySQL website there is several direct API's 
to MySQL.  I propose you use one of these, although dbExpress is a nice idea it is not 
dedicated and developed only for MySQL and thus works poorly.

Our own components is also available at: http://www.scibit.com/MySQLCOMPONENTS and is 
working ONLY with MySQL, v3.21.x to v4, since December 1999.  Today it is Single 
Source and you thus use the same source code for Delphi 5/6 and Kylix 1/2.  We and our 
users uses these components for a number of years now and it is implemented in many 
production systems and real-time systems, etc.

Kind Regards
SciBit MySQL Team

> 
> -Original Message-
> From: "José" <[EMAIL PROTECTED]>
> To: "[EMAIL PROTECTED]" <[EMAIL PROTECTED]>
> CC: 
> Subject: MySQL with Delphi 5.0
> Sent: Tue, 23 Apr 2002 13:51:42 GMT
> Received: Tue, 23 Apr 2002 14:07:46 GMT
> Read: Sat, 30 Dec 1899 00:00:00 GMT
> I've installed MyODBC and then I've set up ODBC and I saw the driver for 
> MySQL DB, when I try to create a new alias wiht MySQL it does not apear to 
> select the DB, acording a book wich is guiding it should has to appear.
> 
> Can anybody help to set up the ALIAS with MySQL 
> 
> Thanks 
> 
>  
> 
> José Haroldo Filho
>  Gerência de TI
> 
> -
> Before posting, please check:
>http://www.mysql.com/manual.php   (the manual)
>http://lists.mysql.com/   (the list archive)
> 
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail <[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
> 
> 


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Auto-configuration of my.cnf?

[Jeremy Zawodny]

On Tue, Apr 23, 2002 at 08:26:23PM -0500, JW wrote:
> -BEGIN PGP SIGNED MESSAGE-
> Hash: SHA1
> 
> Hello,
> 
> Some time ago I set up a rather large mySQL server with InnoDB and
> had a hard time customising my.cnf.
> 
> At the time there was some discussion of createing a tool that
> someone could enter their hardware info into and get a customised
> configuration i.e. a my.cnf "calculator".

I remember that, yes.

> Has any work been done on that?

Yes. :-)

> I'm setting up an even bigger server this time (Quad Xeon, 8GB RAM)
> and I must be figuring something wrong, because I'm comming up with
> nearly the same figures I had for my dual PIII/2GB RAM.

Wow, that's a hard-core server.

> If no ones working on the conf generator, is there any interest in
> it still?
> 
> If anyone is working on it, who? :-)

Me.

If you'd like to chat about this off-list, just let me know.

Jeremy
-- 
Jeremy D. Zawodny, <[EMAIL PROTECTED]>
Technical Yahoo - Yahoo Finance
Desk: (408) 349-7878   Fax: (408) 349-5454   Cell: (408) 685-5936

MySQL 3.23.47-max: up 75 days, processed 1,981,714,827 queries (303/sec. avg)

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

New Setup

[Ian Phillips]

Using the commands you have offered...

Egor> Your 'root' user doesn't have GRANT privilege ...
Egor>
Egor> You should change Grant_priv to 'Y'
Egor> You can do this using UPDATE statement:
Egor>  UPDATE user SET Grant_priv='Y' WHERE user='root';

I get this response..

ERROR 1017: Can't find file: 'user.frm' (errno: 2)

---
Endeavouring to run mysqld as per...

Egor> or you run mysqld with "--skip-grant-tables" option and set Grant_priv
Egor> using GRANT statement:
Egor>   GRANT ALL ON *.* to 'root'@'localhost' identified by
Egor>   'password_obscured' WITH GRANT OPTION;

myslqd tells me it's it is ready for input.
But I'm not sure what to input?

Ian




-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

RE: MySQL 3.23.44 not using indexes

[Steven Roussey]

> >The corollary to the above quote is that MySQL can not use indexes
with
> >an OR clause at the base level.
> >
> MySQL *does* use the index on a different server, though, it just
> doesn't use the index on that server.  Compare the results of EXPLAIN
> queries on the two servers (after ANALYZE TABLE was run):
[Steven Roussey] 

Yes, I retract my corollary. MySQL can not use indexes on an OR clause
if there is no common prefix to the same index. It can have base level
OR and use an index but only if all the clauses in the OR use the same
index (specificly some prefix of the index). My bad. Always read the
manual -- its better than me!

[The situation that could be optimized in MySQL for some future TODO is
the case where you would be asking it to use multiple indexes for the
query.]

However, my guess is that either you need to run analyze on the other
table on the other server, or that it is returning too many rows, so
MySQL does a table scan because it determines it is faster. Indeed the
EXPLAIN tends to bear that out.

Are the tables defined the same on both servers? Is the data the same?
Is the query the same? Are both analyzed?
 




-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

RE: mysqld

[Land, Christopher]

http://www.mysql.com/udmsearch/index.php?ps=10&q=safe_mysqld&ps=20&m=and

1. MySQL Manual | 4.7.2 safe_mysqld, the Wrapper Around mysqld MySQL Manual
[2162694]
MySQL Manual Search: Up Previous Next Chapters Sections Functions
Concepts

  4.7.2 safe_mysqld, the Wrapper Around mysqld
safe_mysqld is the recommended way to start a mysqld daemon on Unix.
safe_mysqld adds some safety features such a...

http://www.mysql.com/doc/s/a/safe_mysqld.html 

C:~

-Original Message-
From: Ian Phillips [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 23, 2002 6:40 PM
To: [EMAIL PROTECTED]
Subject: mysqld


I have run mysqld - and it tells me it is ready for connections - what
syntax is it looking for? (is it the same as mysql ie commands and then a
';' to finish?

Ian


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail
<[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

mysqld

[Ian Phillips]

I have run mysqld - and it tells me it is ready for connections - what
syntax is it looking for? (is it the same as mysql ie commands and then a
';' to finish?

Ian


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Auto-configuration of my.cnf?

[JW]

-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

Hello,

Some time ago I set up a rather large mySQL server with InnoDB and had a hard time 
customising my.cnf.

At the time there was some discussion of createing a tool that someone could enter 
their hardware info into and get a customised configuration i.e. a my.cnf 
"calculator".

Has any work been done on that?

I'm setting up an even bigger server this time (Quad Xeon, 8GB RAM) and I must be 
figuring something wrong, because I'm comming up with nearly the same figures I had 
for my dual PIII/2GB RAM.

If no ones working on the conf generator, is there any interest in it still?

If anyone is working on it, who? :-)


- -- 

- 
Jonathan Wilson
System Administrator
Clickpatrol.com
Cedar Creek Software http://www.cedarcreeksoftware.com

-BEGIN PGP SIGNATURE-
Version: GnuPG v1.0.6 (GNU/Linux)
Comment: For info see http://www.gnupg.org

iD8DBQE8xgm/Q5u80xXOLBcRAmdGAKCUhgP0IDk9HqA+t/zn7B//HNEhKACg2Fa0
HoIsqzl5lNegfdAxYVXG3sk=
=JES3
-END PGP SIGNATURE-


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

RE: I thought MySQL Supported Relationships

[Land, Christopher]

http://www.google.com/search?hl=en&q=Views+Mysql
...

MySQL Manual | 1.7.4.6 Views
... It is planned to implement views in MySQL Server around Version
4.1. Views are mostly
useful for letting users access a set of relations as one table (in
read ... 
www.mysql.com/doc/A/N/ANSI_diff_Views.html - 17k - Cached - Similar
pages

MySQL Manual | 1.7.3.7 Views
... One doesn't need views in MySQL to restrict access to
columns as MySQL has a very
sophisticated privilege system. See section 4.2 General
Security Issues and ... 
www.mysql.com/doc/M/i/Missing_Views.html - 9k - Cached -
Similar pages
[ More results from www.mysql.com ]
...

C:~


-Original Message-
From: Arthur Fuller [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 23, 2002 5:57 PM
To: Jonathan Hilgeman; [EMAIL PROTECTED]
Subject: Re: I thought MySQL Supported Relationships


Perhaps I fail to catch the humour in your response, or the flavour of this
newsgroup, but I find your answer in no way helpful, and beyond that quite
insulting to Access.

1. I have developed applications in Access comprising over 1000 tables, some
of which contain millions of rows, with numerous complex relationships and
C++ components that interfaced to instruments such as scales, scanners, etc.
I am not the only one to push Access that far.

2. To answer Andrew's question, the answer is No. MySQL does not support
defined relationships. The InnoDB extension provides this support.

3. Unfortunately, as of this writing neither MySQL nor InnoDB supports
defined queries (Oracle and SQL Server call them Views). Allegedly, MySQL
4.1 will support stored procedures (and I for one hope that views make it
into the build).

Arthur

- Original Message -
From: "Jonathan Hilgeman" <[EMAIL PROTECTED]>
To: "'Andrew Kuebler'" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Tuesday, April 23, 2002 2:43 PM
Subject: RE: I thought MySQL Supported Relationships


> Actually, no. The addiction to MySQL has caused many relationship
break-ups.
> There's probably even a database with that information out there
somewhere.
> Probably a MySQL database, too. Meanwhile Access supports relationships
> because it blows so hard that people can't wait to get away from it and
home
> to their families.
>
> - Jonathan
>
> -Original Message-
> From: Andrew Kuebler [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, April 23, 2002 11:35 AM
> To: [EMAIL PROTECTED]
> Subject: I thought MySQL Supported Relationships
>
>
> Hello Everyone.
>
> I'm still fairly a newbie to MySQL, but I could have sworn I read
> somewhere that MySQL supported relationships just like Access. I've
> searched the entire manual, and cannot find anything on the subject.
> Does MySQL support relationships, and if so does anyone know where I can
> find any info on the topic? Thanks!
>
> Andrew
>
>
>
>
> -
> Before posting, please check:
>http://www.mysql.com/manual.php   (the manual)
>http://lists.mysql.com/   (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
<[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
> -
> Before posting, please check:
>http://www.mysql.com/manual.php   (the manual)
>http://lists.mysql.com/   (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
<[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail
<[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: I thought MySQL Supported Relationships

[Arthur Fuller]

Perhaps I fail to catch the humour in your response, or the flavour of this
newsgroup, but I find your answer in no way helpful, and beyond that quite
insulting to Access.

1. I have developed applications in Access comprising over 1000 tables, some
of which contain millions of rows, with numerous complex relationships and
C++ components that interfaced to instruments such as scales, scanners, etc.
I am not the only one to push Access that far.

2. To answer Andrew's question, the answer is No. MySQL does not support
defined relationships. The InnoDB extension provides this support.

3. Unfortunately, as of this writing neither MySQL nor InnoDB supports
defined queries (Oracle and SQL Server call them Views). Allegedly, MySQL
4.1 will support stored procedures (and I for one hope that views make it
into the build).

Arthur

- Original Message -
From: "Jonathan Hilgeman" <[EMAIL PROTECTED]>
To: "'Andrew Kuebler'" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Tuesday, April 23, 2002 2:43 PM
Subject: RE: I thought MySQL Supported Relationships


> Actually, no. The addiction to MySQL has caused many relationship
break-ups.
> There's probably even a database with that information out there
somewhere.
> Probably a MySQL database, too. Meanwhile Access supports relationships
> because it blows so hard that people can't wait to get away from it and
home
> to their families.
>
> - Jonathan
>
> -Original Message-
> From: Andrew Kuebler [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, April 23, 2002 11:35 AM
> To: [EMAIL PROTECTED]
> Subject: I thought MySQL Supported Relationships
>
>
> Hello Everyone.
>
> I'm still fairly a newbie to MySQL, but I could have sworn I read
> somewhere that MySQL supported relationships just like Access. I've
> searched the entire manual, and cannot find anything on the subject.
> Does MySQL support relationships, and if so does anyone know where I can
> find any info on the topic? Thanks!
>
> Andrew
>
>
>
>
> -
> Before posting, please check:
>http://www.mysql.com/manual.php   (the manual)
>http://lists.mysql.com/   (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
<[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
> -
> Before posting, please check:
>http://www.mysql.com/manual.php   (the manual)
>http://lists.mysql.com/   (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
<[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

RE: alternative to intersect in mySQL

[Roger Baklund]

* Thomas Moore
> The issue has to do with relating a PRODUCT table and ATTRIBUTE table so
> that one product is related to multiple attributes. In the
> shopping cart, I
> want to show multiple select menus. After a user selects all of them, only
> the parts related to those attributes will be displayed.
>
> Example:
>
> PRODUCT (product_id, etc.)
> Part #100 - has attributes 1, 2
> Part #200 - has attribute 1
>
> ATTRIBUTE (product_id, attribute_id)
> Part_ID, Attribute - GREEN (1)
> Part_ID, Attribute - Aluminum (2)
>
> Want to select all products from PRODUCT that are both Green and Aluminum.
> In Oracle, I can do this using the INTERSECT command.
>
> select product_id from PRODUCT P, ATTRIBUTE A where P.product_id =
> A.product_id and Attribute = 1
> INTERSECT
> select product_id from PRODUCT P, ATTRIBUTE A where P.product_id =
> A.product_id and Attribute = 2

In mysql you can use two joins to the ATTRIBUTE table:

  SELECT P.product_id
FROM PRODUCT P, ATTRIBUTE A1, ATTRIBUTE A2
WHERE
  P.product_id = A1.product_id AND A1.Attribute = 1 AND
  P.product_id = A2.product_id AND A2.Attribute = 2

> A temporary table may work, but I do not like this as a solution
> as I would have to maintain an extra table with non-relevant data
> (need to constantly insert and delete data).

No, that's the point with a TEMPORARY table... it's a special kind of table,
it is automatically removed when the connection is closed, and separate
connections have separate temporary tables...

http://www.mysql.com/doc/C/R/CREATE_TABLE.html >

Usefull in many cases, but I do not think you need it in this case.

> I tried playing with outer joins, but I don't know
> how to get it to do this.

The commas in the above select statement is a short form of 'INNER JOIN'.

--
Roger


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: MySQL 3.23.44 not using indexes

[Myk Melez]

Steven Roussey wrote:

>The corollary to the above quote is that MySQL can not use indexes with
>an OR clause at the base level.
>
MySQL *does* use the index on a different server, though, it just 
doesn't use the index on that server.  Compare the results of EXPLAIN 
queries on the two servers (after ANALYZE TABLE was run):

Broken server:

mysql> EXPLAIN SELECT bug_id FROM bugs WHERE bug_status IN ('NEW', 
'ASSIGNED', 'REOPENED');
+---+--+---+--+-+--+++
| table | type | possible_keys | key  | key_len | ref  | rows   | 
Extra  |
+---+--+---+--+-+--+++
| bugs  | ALL  | bug_status| NULL |NULL | NULL | 139425 | where 
used |
+---+--+---+--+-+--+++

Working server:

mysql> EXPLAIN SELECT bug_id FROM bugs WHERE bug_status IN ('NEW', 
'ASSIGNED', 'REOPENED');
+---+---+---++-+--+---++
| table | type  | possible_keys | key| key_len | ref  | rows  | 
Extra  |
+---+---+---++-+--+---++
| bugs  | range | bug_status| bug_status |   1 | NULL | 20502 | 
where used |
+---+---+---++-+--+---++

My initial hunch was a bug in 3.23.44 (the working server was running 
3.23.41 and the broken server was running 3.23.44)), but that doesn't 
seem to be the case, since I upgraded the working server to 3.23.44 and 
found that it continues to correctly use the index for this query. 
 Other possibilities include platform (the working server is Redhat 
Linux 7.2 while the broken server is SunOS 5.7) and configuration, but 
I'm not sure how to diagnose further or what to look for in the 
configuration files.

Note that although this particular query is trivial, it is a base for 
more complex queries with one-to-many joins selecting large numbers of 
records, and narrowing the range of records to join can significantly 
increase query performance in those situations.

-myk



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Remove Mysql: New Setup

[Ian Phillips]

I seem to have done something that has crashed mysql on my server

and I would really like to completely remove it and start again

It's running on freebsd & is version 3.23.43 I think.

Is there a safe procedure that will not crash my server? I can't seem to
find any documentation on the msyql.org site?

Ian




-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: MySQLdb Exception Documentation

[Opus]

Yeah, the docs on that are a bit sparse.

On 22 Apr 2002 at 12:05, Tim Johnson wrote:

> Hello All:
> I'm just learning to use Andy Dustman's MySQLdb for Python. 
> Very easy for this mysql-dummy to learn!
> 
> It would be very helpful for me to find documentation
> on the Exceptions thrown by Python for this API.
> 
> Any advice would be greatly appreciated.
> TIA
> -- 
> Tim Johnson <[EMAIL PROTECTED]>
>   http://www.alaska-internet-solutions.com
>   http://www.johnsons-web.com
> 


--Opus--

Treat a man as he is, and he will stay as he is. Treat him as what he
could be and he will become all that he can be.
- Goethe


Get added to my Humor list:
mailto:[EMAIL PROTECTED]?subject=ADD_HUMOR
Get added to my Neat list:
mailto:[EMAIL PROTECTED]?subject=ADD_NEAT
Get my PGP public key:
mailto:[EMAIL PROTECTED]?subject=PSEND&body=send%20PublicKEY.asc
Visit My Home Page:
http://value.net/~opus/




-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: LAST_INSERT_ID()

[Erik Price]

On Tuesday, April 23, 2002, at 03:10  PM, destr0 wrote:

> SELECT LAST_INSERT_ID() as id FROM myTable;
>
> It returns the last inserted Id, but why does it return that value for 
> every
> row in the table.
>
> for example.
> if there are 5 total records in the table. and the last inserted Id is 
> 9, if
> I run the above query I get:
>
> +--+
> |id |
> +--+
> |9  |
> |9  |
> |9  |
> |9  |
> |9  |
> +--+

When you select anything from a table, using FROM tablename, you will 
end up with a result for each row in that table, unless you use a WHERE 
clause.


Erik





Erik Price
Web Developer Temp
Media Lab, H.H. Brown
[EMAIL PROTECTED]


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: How to Install as non-root user in Unix system?

[Steven Hajducko]

I think the general procedure is the same, just a couple things you have
to consider.

1. The mysql daemon will have to run under your user name.
2. You might not be able to use port 3306, you'll have to check with the
sys admin for this.
3. You'll have to install it into your home directory ( check
./configure --help for more info on this )

Most source packages that you compile don't require you to be root to
'make' them, just when you do 'make install'.

--
sh


On Tue, 2002-04-23 at 14:02, Paul E Johnson wrote:
> I have an account on our Dec Unix system and I can't find any directions 
> on how to make MySQL work without root privileges. Can it be done?
> 
> pj
> -- 
> Paul E. Johnson   email: [EMAIL PROTECTED]
> Dept. of Political Sciencehttp://lark.cc.ukans.edu/~pauljohn
> University of Kansas  Office: (785) 864-9086
> Lawrence, Kansas 66045FAX: (785) 864-5700
> 
> 
> -
> Before posting, please check:
>http://www.mysql.com/manual.php   (the manual)
>http://lists.mysql.com/   (the list archive)
> 
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail <[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
> 



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Erwin Vs Mysql ....

[vivek . chaudhary]

Has anyone got Erwin working with mysql. I guess all directly 
non-supported DBs by Erwin are suppose to work via ODBC but I have not 
been able to find ODBC driver (either generic or for mysql).

thanks

Vivek


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

RE: alternative to intersect in mySQL

[Thomas Moore]

The issue has to do with relating a PRODUCT table and ATTRIBUTE table so
that one product is related to multiple attributes. In the shopping cart, I
want to show multiple select menus. After a user selects all of them, only
the parts related to those attributes will be displayed.

Example:

PRODUCT (product_id, etc.)
Part #100 - has attributes 1, 2
Part #200 - has attribute 1

ATTRIBUTE (product_id, attribute_id)
Part_ID, Attribute - GREEN (1)
Part_ID, Attribute - Aluminum (2)

Want to select all products from PRODUCT that are both Green and Aluminum.
In Oracle, I can do this using the INTERSECT command.

select product_id from PRODUCT P, ATTRIBUTE A where P.product_id =
A.product_id and Attribute = 1
INTERSECT
select product_id from PRODUCT P, ATTRIBUTE A where P.product_id =
A.product_id and Attribute = 2

A temporary table may work, but I do not like this as a solution as I would
have to maintain an extra table with non-relevant data (need to constantly
insert and delete data). I tried playing with outer joins, but I don't know
how to get it to do this.

thanks,
-tom

-Original Message-
From: Roger Baklund [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 23, 2002 10:43 AM
To: MySQL List
Cc: [EMAIL PROTECTED]
Subject: RE: alternative to intersect in mySQL


* Thomas Moore

> > I know that intersect does not work yet with mySQL. I am selecting data
> from
> > two tables. Results of one select
> > would be 1, 2, 3, 4 . Results of other select 1, 2.
>
> > Want to print 1, 2.
>
> > Are there any nice workarounds using PHP or SQL?

[temporary table]

> If it is in a multi-user environment, this is undesirable. Any other
> thoughts?

Maybe you could give us some more details about the problem?

"Result of one select"...? Is this a complex joined select which you can not
expand to include the second select? Is it different hosts/databases? Why
can you not use a join?

select a.id from a,b where a.id = b.id

--
Roger


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail
<[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

compile problem with 3.23.50

[ch]

>Description:
I get the following error:

c++ -DMYSQL_SERVER  -DDEFAULT_MYSQL_HOME="\"/usr\""
-
DDATADIR="\"/var/lib/mysql\""   -DSHAREDIR="\"/usr/share/mysql\"
"   -DHAVE_CONFIG_H -I../bdb/build_unix -I../innobase/includ
e   -I./../include  -I./../regex   -
I. -I../include -I.. -I.-O3 -DDBUG_OFF   -fno-implicit-templates -fno-except
ions -fno-rtti -c mysqld.cc
mysqld.cc: In function `void * handle_connections_sockets(void *)':
/usr/include/tcpd.h:161: too few arguments to function `void sock_host(request_i
nfo *)'
mysqld.cc:2428: at this point in file
/usr/include/tcpd.h:119: too few arguments to function `int hosts_access(request
_info *)'
mysqld.cc:2429: at this point in file 
/usr/include/tcpd.h:153: too few arguments to function `char * eval_client(reque
st_info *)'
mysqld.cc:2437: at this point in file
make[4]: *** [mysqld.o] Error 1
make[4]: Leaving directory `/home/ch/debian/mysql-3.23.50/sql'
make[3]: *** [all-recursive] Error 1
make[3]: Leaving directory `/home/ch/debian/mysql-3.23.50/sql'

Desired=Unknown/Install/Remove/Purge/Hold
| Status=Not/Installed/Config-files/Unpacked/Failed-config/Half-installed
|/ Err?=(none)/Hold/Reinst-required/X=both-problems (Status,Err: uppercase=bad)
||/ Name   VersionDescription
+++-==-==-
ii  libwrap0   7.6-9  Wietse Venema's TCP wrappers library
ii  libwrap0-dev   7.6-9  Wietse Venema's TCP wrappers library, develo
ii  libc6  2.2.5-4GNU C Library: Shared libraries and Timezone
ii  libc6-dev  2.2.5-4GNU C Library: Development Libraries and Hea
ii  gcc2.95.4-14  The GNU C compiler.
ii  gcc-2.95   2.95.4-7   The GNU C compiler.
ii  gcc-3.0-base   3.0.4-7The GNU Compiler Collection (base package).

>How-To-Repeat:
see above
>Fix:
none

>Submitter-Id:  
>Originator:Christian Hammers
>Organization:
 Debian Project
>MySQL support: none
>Synopsis:  compile problem 3.23.50
>Severity:  serious
>Priority:  medium
>Category:  mysql
>Class: sw-bug
>Release:   mysql-3.23.49 (Source distribution)
>Server: /usr/bin/mysqladmin  Ver 8.23 Distrib 3.23.49, for pc-linux-gnu on i686
Copyright (C) 2000 MySQL AB & MySQL Finland AB & TCX DataKonsult AB
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL license

Server version  3.23.49-log
Protocol version10
Connection  Localhost via UNIX socket
UNIX socket /var/run/mysqld/mysqld.sock
Uptime: 1 day 7 hours 39 min 28 sec

Threads: 1  Questions: 621696  Slow queries: 0  Opens: 506  Flush tables: 1  Open 
tables: 12 Queries per second avg: 5.455
>Environment:

System: Linux xeniac 2.4.17 #2 Fre Jan 18 19:15:02 CET 2002 i686 unknown
Architecture: i686

Some paths:  /usr/bin/perl /usr/bin/make /usr/bin/gcc /usr/bin/cc
GCC: Reading specs from /usr/lib/gcc-lib/i386-linux/2.95.4/specs
gcc version 2.95.4 20011002 (Debian prerelease)
Compilation info: CC='gcc'  CFLAGS=''  CXX='c++'  CXXFLAGS=''  LDFLAGS=''
LIBC: 
lrwxrwxrwx1 root root   13 Mär 26 15:17 /lib/libc.so.6 -> libc-2.2.5.so
-rwxr-xr-x1 root root  1153816 Mär 24 18:00 /lib/libc-2.2.5.so
-rw-r--r--1 root root  2391274 Mär 24 18:00 /usr/lib/libc.a
-rw-r--r--1 root root  178 Mär 24 18:01 /usr/lib/libc.so
-rw-r--r--1 root root   726660 Mär 24 05:56 /usr/lib/libc-client.so.2001
Configure command: ./configure  --prefix=/usr --exec-prefix=/usr 
--libexecdir=/usr/sbin --datadir=/usr/share --sysconfdir=/etc/mysql 
--localstatedir=/var/lib/mysql --includedir=/usr/include --infodir=/usr/share/info 
--mandir=/usr/share/man --enable-shared --with-libwrap --enable-assembler 
--with-berkeley-db --with-innodb --enable-static --enable-shared --enable-local-infile 
--with-raid --enable-thread-safe-client --without-readline 
--with-unix-socket-path=/var/run/mysqld/mysqld.sock --with-mysqld-user=mysql 
--without-bench --with-client-ldflags=-lstdc++ --with-extra-charsets=all


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

How to Install as non-root user in Unix system?

[Paul E Johnson]

I have an account on our Dec Unix system and I can't find any directions 
on how to make MySQL work without root privileges. Can it be done?

pj
-- 
Paul E. Johnson   email: [EMAIL PROTECTED]
Dept. of Political Sciencehttp://lark.cc.ukans.edu/~pauljohn
University of Kansas  Office: (785) 864-9086
Lawrence, Kansas 66045FAX: (785) 864-5700


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: (Newbie) Apachie->PHP->MySql

[Jan Peuker]

You have to update your seession-path in your php.ini (usually located in
%%systemroot%% eg windows) to a valid windows-path like c:\windows\temp

Jan

- Original Message -
From: "r" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, April 24, 2002 11:19 AM
Subject: (Newbie) Apachie->PHP->MySql


> Greetings all.
> A bit of history,
> I have a small.no actually...TINY website. :-)
> I am using PHP and mySql there without any problems.
> But uploading and testing each PHP page/program was a pain in the
.
> so i installed Apache,MySql and PHP on my WINDOWS 2000 machine for testing
> before going live,
> I'm pretty much still a virgin at using MySql/apache/PHP on my local
machine
> so would appreciate any help.
>
> Heres my problem,
> I am running a php page to connect to the database and return some values,
> but instead this is what i get.
>
>  *
> Warning: open(/tmp\sess_1d9c4fe5132dbb9af2e128200e2c069b, O_RDWR) failed:
No
> such file or directory (2) in d:\program files\apache
> group\apache\htdocs\advt\common.php on line 133
> **
>
> Since what i have in the php file is no secret here is the code from line
> 133
> (If you want to see the actual file/s,write to me and i'll mail it to you
as
> this list does not support attachments)
>
>
>
>  function verifyUser() ***This is line
> 118*
>  {
>   global $ADMIN_EMAIL;
>   session_start();
>   global $email, $passwd;
>   if( session_is_registered( "email" ) &&
> session_is_registered( "passwd" ) )
>   {
>$result = mysql_query( "SELECT email, passwd FROM user WHERE
> email='$email' AND BINARY passwd='$passwd'" ) or error( "Login failed,
> please contact adminstrator" );
>if( mysql_num_rows( $result ) == 1 ) return true;
>   }
>   return false;
>  }
>  function verifyAdmin()
>  {
>   session_start(); *  133> *
>
>
>
> This is the error i am getting as i "login" via a username and password
> field.
> Scroll down to see the php code i am using. (There is nothing wrong with
the
> php code as i am using it "live" online without any problems for a
website)
>
>

> 
> Warning: open(/tmp\sess_1d9c4fe5132dbb9af2e128200e2c069b, O_RDWR) failed:
No
> such file or directory (2) in d:\program files\apache
> group\apache\htdocs\advt\admin.php on line 13
>
> Warning: Cannot add header information - headers already sent by (output
> started at d:\program files\apache group\apache\htdocs\advt\admin.php:13)
in
> d:\program files\apache group\apache\htdocs\advt\admin.php on line 15
>
> Warning: open(/tmp\sess_1d9c4fe5132dbb9af2e128200e2c069b, O_RDWR) failed:
No
> such file or directory (2) in Unknown on line 0
>
> Warning: Failed to write session data (files). Please verify that the
> current setting of session.save_path is correct (/tmp) in Unknown on line
0
>

> 
> First few lines of my php page (all common.php contains is the usernames
and
> passwords)
>
>   require( "common.php" );
>  if( isset( $action ) )
>  {
>   if( $action == "login" )
>   {
>$adminName = trim( $adminName );
>$adminPasswd = trim( $adminPasswd );
>if( $adminName == "" ) error( "Admin name required" );
>if( $adminPasswd == "" ) error( "Admin password required" );
>if( $adminName != $ADMIN_NAME ) error( "Invalid admin name" );
>if( $adminPasswd != $ADMIN_PASS ) error( "Invalid password" );
>session_register( "adminName" );
>session_register( "adminPasswd" );
>header( "Location: ./admin_menu.php" );
>   }
>   elseif( $action == "logout" )
>   {
>session_start();
>session_unregister( "adminName" );
>session_unregister( "adminPasswd" );
>displayHeader( "Admin Logout" );
>echo "You have logout
> successfully!\n";
>echo "Home\n";
>displayFooter();
>   }
>  }
>  else
>
>
>
>
>
> Thank you for reading this mail even if you cannot help me.
> ANY help appreciated.
> Cheers
> -Ryan.
>
>
> -
> Before posting, please check:
>http://www.mysql.com/manual.php   (the manual)
>http://lists.mysql.com/   (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
<[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/ph

MySQL datetime & GMT time handling

[James Berry]

I have a question, or maybe it's a feature request. Or maybe it's a question
and a feature request ;)

We would very much like to be able to store time on the server in UTC. The
TIMESTAMP type seems close, but has baggage due to its desire to update
itself as a timestamp on updates.

MySQL handling of dates seems to work poorly for GMT/UTC dates. Let me make
the following summary: (and please correct me if I'm wrong ;)

 (1) DATETIME columns are stored in a fixed format (BCD of some sort?)
 that is unrelated to the time zone TZ of the server. If I store
 a date/time, then change the time zone of the server, then fetch
 the field, it will remain unchanged. This is good.

 (2) But all MySQL interpretation of such dates is relative to the
 server's current time zone. So if I ask for a UNIX_TIMESTAMP of
 such a DATETIME, (or even worse maybe, try to use any of the very
 very nice looking MySQL date/time functions, the DATETIME field
 will be interpreted as if it were expressed in server local time.
 This is bad.

 (3) TIMESTAMP columns store the time as a true unix epoch time, but
 are hamstrung by the timestamping feature when used for regular
 date/times.

This leaves us with the following set of seemingly awkward choices:

 (a) Offset our DATETIME fields into GMT/UTC time before setting
 them on the server.
Advantages:
- If the server, or the database, is moved across timezones
  the data won't change.
- Clients of the database don't need to know the timezone
  of the MySQL server; they just have to know their own
  time zone.
Disadvantages:
- None of (very few of?) the build-in MySQL date/time
  functions will work, as they all assume that the datetimes
  are in server local time.

 (b) Offset times to server local time before storing or, better yet,
 let the server do this with From_UnixTime.
Advantages:
- The MySQL date/time functions will work okay
- Use of Unix_TimeStamp() and From_UnixTime() functions
  make date/time storage and retrieval fairly easy.
Disadvantages:
- Since times are stored on disk in local time, the database
  (or server) may not be moved or transported across date
  lines without munging the dates.
- It is likely that clients of the database will need to know
  what time-zone it is in.

 (c) Always use TIMESTAMP columns.
Advantages:
- The MySQL date/time functions will work (???)
- The database and server may be moved across time zones
  without affected the stored dates.
Disadvantages:
- The timestamping features makes such columns very awkward
  to use for "normal" date/time storage, as extreme care
  must be taken to ensure that the column is properly reset
  on each update.


We have chosen choice (a) currently as the best of the three choices, in
part because the the built-in date/time functions don't provide much benefit
since we have to accommodate users in multiple timezones anyway, and these
routines all really only work well if a user is within the server's time
zone.

My Question:

- Is there something we've missed here to make our lives easier? Is
there a better/easier choice that we've missed?

My Feature Request:

- I would ask for a rich set of date/time functions that manipulate a
date stored in a canonical GMT/UTC form that will survive transport across
time zones.
- Such routines (where they place an human readable interpretation or
representation on a date) should take a timezone or locale parameter of some
sort in order that the time can be interpreted according to a given set of
local conventions.


James.


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

(Newbie) Apachie->PHP->MySql

[r]

Greetings all.
A bit of history,
I have a small.no actually...TINY website. :-)
I am using PHP and mySql there without any problems.
But uploading and testing each PHP page/program was a pain in the .
so i installed Apache,MySql and PHP on my WINDOWS 2000 machine for testing
before going live,
I'm pretty much still a virgin at using MySql/apache/PHP on my local machine
so would appreciate any help.

Heres my problem,
I am running a php page to connect to the database and return some values,
but instead this is what i get.

 *
Warning: open(/tmp\sess_1d9c4fe5132dbb9af2e128200e2c069b, O_RDWR) failed: No
such file or directory (2) in d:\program files\apache
group\apache\htdocs\advt\common.php on line 133
**

Since what i have in the php file is no secret here is the code from line
133
(If you want to see the actual file/s,write to me and i'll mail it to you as
this list does not support attachments)



 function verifyUser() ***This is line
118*
 {
  global $ADMIN_EMAIL;
  session_start();
  global $email, $passwd;
  if( session_is_registered( "email" ) &&
session_is_registered( "passwd" ) )
  {
   $result = mysql_query( "SELECT email, passwd FROM user WHERE
email='$email' AND BINARY passwd='$passwd'" ) or error( "Login failed,
please contact adminstrator" );
   if( mysql_num_rows( $result ) == 1 ) return true;
  }
  return false;
 }
 function verifyAdmin()
 {
  session_start(); *  *



This is the error i am getting as i "login" via a username and password
field.
Scroll down to see the php code i am using. (There is nothing wrong with the
php code as i am using it "live" online without any problems for a website)



Warning: open(/tmp\sess_1d9c4fe5132dbb9af2e128200e2c069b, O_RDWR) failed: No
such file or directory (2) in d:\program files\apache
group\apache\htdocs\advt\admin.php on line 13

Warning: Cannot add header information - headers already sent by (output
started at d:\program files\apache group\apache\htdocs\advt\admin.php:13) in
d:\program files\apache group\apache\htdocs\advt\admin.php on line 15

Warning: open(/tmp\sess_1d9c4fe5132dbb9af2e128200e2c069b, O_RDWR) failed: No
such file or directory (2) in Unknown on line 0

Warning: Failed to write session data (files). Please verify that the
current setting of session.save_path is correct (/tmp) in Unknown on line 0


First few lines of my php page (all common.php contains is the usernames and
passwords)

You have logout
successfully!\n";
   echo "Home\n";
   displayFooter();
  }
 }
 else





Thank you for reading this mail even if you cannot help me.
ANY help appreciated.
Cheers
-Ryan.


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

3.23.50 client needs IP addresses

[rob]

>Description:
mysql client from 3.23.50 won't connect to older servers running on remote hosts 
unless you specify the host as an IP address:

ERROR 2005: Unknown MySQL Server Host 'xxx' (2)

>Submitter-Id:  
>Originator:Rob Steele
>Organization:  FatKat, Inc.
>MySQL support: none
>Synopsis:  3.23.50 client needs IP addresses
>Severity:  serious
>Priority:  high
>Category:  mysql
>Class: sw-bug
>Release:   mysql-3.23.50 (Official MySQL RPM)

>Environment:
x86 Linux
System: Linux warren.fatkat.com 2.4.9-31 #1 Tue Feb 26 07:11:02 EST 2002 i686 unknown
Architecture: i686

Some paths:  /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc
GCC: Reading specs from /usr/lib/gcc-lib/i386-redhat-linux/2.96/specs
gcc version 2.96 2731 (Red Hat Linux 7.1 2.96-98)
Compilation info: CC='gcc'  CFLAGS='-O6 -fno-omit-frame-pointer -mcpu=pentiumpro'  
CXX='gcc'  CXXFLAGS='-O6 -fno-omit-frame-pointer   -felide-constructors 
-fno-exceptions -fno-rtti -mcpu=pentiumpro'  LDFLAGS=''
LIBC: 
lrwxrwxrwx1 root root   13 Apr 17 13:33 /lib/libc.so.6 -> libc-2.2.4.so
-rwxr-xr-x2 root root  1285788 Apr  2 11:58 /lib/libc-2.2.4.so
-rw-r--r--1 root root 27332668 Apr  2 11:42 /usr/lib/libc.a
-rw-r--r--1 root root  178 Apr  2 11:42 /usr/lib/libc.so
lrwxrwxrwx1 root root   10 Oct 24 16:08 /usr/lib/libc-client.a -> 
c-client.a
Configure command: ./configure  --disable-shared --with-mysqld-ldflags=-all-static 
--with-client-ldflags=-all-static --with-other-libc=/usr/local/mysql-glibc 
--without-berkeley-db --without-innodb --enable-assembler --enable-local-infile 
--with-mysqld-user=mysql --with-unix-socket-path=/var/lib/mysql/mysql.sock --prefix=/ 
--with-extra-charsets=complex --exec-prefix=/usr --libexecdir=/usr/sbin 
--sysconfdir=/etc --datadir=/usr/share --localstatedir=/var/lib/mysql 
--infodir=/usr/info --includedir=/usr/include --mandir=/usr/man 
'--with-comment=Official MySQL RPM'


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: insert for datatype of "set"

[Jim Philips]

When I use this syntax, the first state gets inserted into the field and the 
others are ignored. Here is my exact SQL:

mysql> insert into contr
-> VALUES(
-> "", 0, "Hammer Whackers", "Bob Hammer",
-> "3390 Peachtree Rd.", "", "Atlanta",
-> "GA", "30326", "", "404-326-0200",
-> "", "[EMAIL PROTECTED]",
-> "http://www.hammerwhackers.com";,
-> "FL, SC, TN", "thehammer", "Hammer1", curdate());

Only "FL" shows up after the insert. All of the other fields come out as I 
expect. The field with state abbreviations is the only one that is a data 
type of set. I am using MySQL 3.23.47.

On Tuesday 23 April 2002 04:31 pm, Gerald Clark wrote:
> insert into mytable ( id , myset) values ('1', 'GA,SC') , ( '2',
> 'TN,NC,AL') ;
>
> Jim Philips wrote:
> >Yes. I found that page earlier. I still don't see how it answers my
> > question. What is the proper syntax for an insert statement?
> >
> >On Tuesday 23 April 2002 03:54 pm, Christopher Thompson wrote:
> >>http://www.mysql.com/doc/S/E/SET.html
> >>
> >>On Tuesday 23 April 2002 1:45 pm, Jim Philips wrote:
> >>>I couldn't find this in the documentation. What is the propoer sql to
> >>>insert into a field with a data type of set? My field has the following
> >>>set of acceptable values:
> >>>
> >>>GA, TN, SC, NC, AL
> >>>
> >>>Assume I am inserting multiple values, such GA, TN, SC. If I separate
> >>>them with commas, mysql will assume they are separate fields. So, what
> >>> is the way out of this?
> >>>
> >>>-
> >>>Before posting, please check:
> >>>   http://www.mysql.com/manual.php   (the manual)
> >>>   http://lists.mysql.com/   (the list archive)
> >>>
> >>>To request this thread, e-mail <[EMAIL PROTECTED]>
> >>>To unsubscribe, e-mail
> >>><[EMAIL PROTECTED]> Trouble
> >>>unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
> >>
> >>-
> >>Before posting, please check:
> >>   http://www.mysql.com/manual.php   (the manual)
> >>   http://lists.mysql.com/   (the list archive)
> >>
> >>To request this thread, e-mail <[EMAIL PROTECTED]>
> >>To unsubscribe, e-mail
> >><[EMAIL PROTECTED]> Trouble
> >>unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
> >
> >-
> >Before posting, please check:
> >   http://www.mysql.com/manual.php   (the manual)
> >   http://lists.mysql.com/   (the list archive)
> >
> >To request this thread, e-mail <[EMAIL PROTECTED]>
> >To unsubscribe, e-mail
> > <[EMAIL PROTECTED]>
> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
> -
> Before posting, please check:
>http://www.mysql.com/manual.php   (the manual)
>http://lists.mysql.com/   (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
> <[EMAIL PROTECTED]> Trouble
> unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

SET row dynamic?

[Jan Peuker]

Short question: Is there a way to update SET-options without alter table?
e.g. if one user is registered in table1 he is allowed(means registered in
set-row options) to write his id into table2 ?
Thanks,

Jan

P.S.: For the filter: I want to do a sql query which does something.


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: insert for datatype of "set"

[Gerald Clark]

insert into mytable ( id , myset) values ('1', 'GA,SC') , ( '2', 
'TN,NC,AL') ;

Jim Philips wrote:

>Yes. I found that page earlier. I still don't see how it answers my question. 
>What is the proper syntax for an insert statement?
>
>On Tuesday 23 April 2002 03:54 pm, Christopher Thompson wrote:
>
>>http://www.mysql.com/doc/S/E/SET.html
>>
>>On Tuesday 23 April 2002 1:45 pm, Jim Philips wrote:
>>
>>>I couldn't find this in the documentation. What is the propoer sql to
>>>insert into a field with a data type of set? My field has the following
>>>set of acceptable values:
>>>
>>>GA, TN, SC, NC, AL
>>>
>>>Assume I am inserting multiple values, such GA, TN, SC. If I separate
>>>them with commas, mysql will assume they are separate fields. So, what is
>>>the way out of this?
>>>
>>>-
>>>Before posting, please check:
>>>   http://www.mysql.com/manual.php   (the manual)
>>>   http://lists.mysql.com/   (the list archive)
>>>
>>>To request this thread, e-mail <[EMAIL PROTECTED]>
>>>To unsubscribe, e-mail
>>><[EMAIL PROTECTED]> Trouble
>>>unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>>>
>>-
>>Before posting, please check:
>>   http://www.mysql.com/manual.php   (the manual)
>>   http://lists.mysql.com/   (the list archive)
>>
>>To request this thread, e-mail <[EMAIL PROTECTED]>
>>To unsubscribe, e-mail
>><[EMAIL PROTECTED]> Trouble
>>unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>>
>
>
>-
>Before posting, please check:
>   http://www.mysql.com/manual.php   (the manual)
>   http://lists.mysql.com/   (the list archive)
>
>To request this thread, e-mail <[EMAIL PROTECTED]>
>To unsubscribe, e-mail 
><[EMAIL PROTECTED]>
>Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Intermittent 1049 error in MySQL 3.23.49

[Clay Loveless]

Hello again,

I've now been on the list long enough to determine it's not an inactive list
... So, I'm hoping that means that someone (perhaps one of the MySQL team
I've seen active on the list today) may be able to address this problem, as
it is quite a serious one.

Is there a reason that it's not even covered in the documentation?

I'd love to hear something back ... While I've been a MySQL user for many
years, I'm feeling the urge to spend the time I'm spending waiting to hear
something looking for a more stable and reliable database to run on Mac OS X
Server.

-Clay

PS -- I'm running MySQL 3.23.49, but have experienced this problem in other
MySQL versions on Mac OS X Server.

___
Clay Loveless
Webmaster, Crawlspace
http://www.crawlspace.com/



> From: Clay Loveless <[EMAIL PROTECTED]>
> Date: Fri, 19 Apr 2002 17:26:25 -0700
> To: <[EMAIL PROTECTED]>
> Subject: Intermittent 1049 error
> 
> Hello,
> 
> I'm running a relatively busy MySQL server on Mac OS X Server 10.1.4. MySQL
runs on
> a dedicated dual G4 500, with 1.5 GB of RAM and an 18GB 15k rpm Ultra160
> Cheetah drive. No other services besides MySQL run on this machine.
> 
> Roughly 3-5 times per day, my MySQL server suddenly "forgets" most or all of
> its databases, and begins claiming that they don't exist with an error 1049.
> 
> I've searched the mailing list (found 3 messages with 1049 in the archives,
> none of which described this problem), the online docs (error 1049 isn't
> even mentioned), and Google (which found 150+ pages who are apparently
> having this same problem, but found no answers) ...
> 
> I can't believe I'm the only one having this problem, but since there's no
> mention of it anywhere that I can find, I am beginning to wonder.
> 
> Can anyone shed some light on this issue, and hopefully, offer a remedy?
> 
> Thanks in advance.
> 
> -Clay
> 
> (
> 
> Further info -- the server hosts only about 15-20 databases, the total size
> of which is less than 1.5 GB. Well under 2MM records total.
> 
> mysqladmin status as of this writing:
> Uptime: 205602  Threads: 145  Questions: 4293056  Slow queries: 0  Opens:
> 207  Flush tables: 1  Open tables: 202 Queries per second avg: 20.880
> 
> )
> 
> ___
> Clay Loveless
> Webmaster, Crawlspace
> http://www.crawlspace.com/
> 
> 
> 
> 
> -
> Before posting, please check:
>  http://www.mysql.com/manual.php   (the manual)
>  http://lists.mysql.com/   (the list archive)
> 
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
> <[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
> 


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: insert for datatype of "set"

[Jim Philips]

Yes. I found that page earlier. I still don't see how it answers my question. 
What is the proper syntax for an insert statement?

On Tuesday 23 April 2002 03:54 pm, Christopher Thompson wrote:
> http://www.mysql.com/doc/S/E/SET.html
>
> On Tuesday 23 April 2002 1:45 pm, Jim Philips wrote:
> > I couldn't find this in the documentation. What is the propoer sql to
> > insert into a field with a data type of set? My field has the following
> > set of acceptable values:
> >
> > GA, TN, SC, NC, AL
> >
> > Assume I am inserting multiple values, such GA, TN, SC. If I separate
> > them with commas, mysql will assume they are separate fields. So, what is
> > the way out of this?
> >
> > -
> > Before posting, please check:
> >http://www.mysql.com/manual.php   (the manual)
> >http://lists.mysql.com/   (the list archive)
> >
> > To request this thread, e-mail <[EMAIL PROTECTED]>
> > To unsubscribe, e-mail
> > <[EMAIL PROTECTED]> Trouble
> > unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
> -
> Before posting, please check:
>http://www.mysql.com/manual.php   (the manual)
>http://lists.mysql.com/   (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
> <[EMAIL PROTECTED]> Trouble
> unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: insert for datatype of "set"

[Christopher Thompson]

http://www.mysql.com/doc/S/E/SET.html

On Tuesday 23 April 2002 1:45 pm, Jim Philips wrote:
> I couldn't find this in the documentation. What is the propoer sql to
> insert into a field with a data type of set? My field has the following set
> of acceptable values:
>
> GA, TN, SC, NC, AL
>
> Assume I am inserting multiple values, such GA, TN, SC. If I separate them
> with commas, mysql will assume they are separate fields. So, what is the
> way out of this?
>
> -
> Before posting, please check:
>http://www.mysql.com/manual.php   (the manual)
>http://lists.mysql.com/   (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
> <[EMAIL PROTECTED]> Trouble
> unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

insert for datatype of "set"

[Jim Philips]

I couldn't find this in the documentation. What is the propoer sql to insert 
into a field with a data type of set? My field has the following set of 
acceptable values:

GA, TN, SC, NC, AL

Assume I am inserting multiple values, such GA, TN, SC. If I separate them 
with commas, mysql will assume they are separate fields. So, what is the way 
out of this?

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: LAST_INSERT_ID()

[BD]

At 02:10 PM 4/23/2002, you wrote:
>query, table
>
>When I run the query:
>
>SELECT LAST_INSERT_ID() as id FROM myTable;
>
>It returns the last inserted Id, but why does it return that value for every
>row in the table.
>
>for example.
>if there are 5 total records in the table. and the last inserted Id is 9, if
>I run the above query I get:
>
>+--+
>|id |
>+--+
>|9  |
>|9  |
>|9  |
>|9  |
>|9  |
>+--+
>

Destr0,
 Because it is a constant. You don't add the table name to the 
query. Try

SELECT LAST_INSERT_ID() as id;

 And you will get one row, namely the last auto inc value for the 
last table that had a row inserted. You normally use this right after you 
have inserted a row to a table, so you automatically know which table it is 
for.

Brent


_
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Circular replication

[Madscientist]

Hi,

We're doing something weird (what else is new). We're hoping to use
MySQL as the base of a distributed database with peer replication. Most
of the peering and control mechanisms will be in the core application
code, but we're counting on MySQL's ability to replicate for some of the
lower-level peer synchronization mechanisms. It appears from the docs
that most of this will be straightforward, however it is not clear (or I
missed it) if replication works with all table types.

This is important because the issue of complex transactions has recently
come up and we may need to use innodb tables.

It is not entirely clear wether replication will work with innodb
tables.
We're hoping to use MySQL 4.x

Can we build reliable, circular replication with innodb tables in MySQL?

We will have the application pick a single master node for any
particular table and/or database until all nodes are synchronized...
Then the app will vote for a new master if needed.

For example.

   NODE1   NODE2NODE3
   MASTER OF A MASTER OF B  MASTER OF C

...--->[ ABC ]>[ ABC ]->[ ABC ]...

Will this work with innodb.
If not directly, then how?

Thanks in advacnce,
_M


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Slow Shutdown with NET STOP MYSQL

[Dave Butler]

I have version 3.23.41-max-debug running on Windows 2000 SP2. I have MySQL 
installed as a service and can use NET START MYSQL and NET STOP MYSQL to 
start and stop the server. One unusual item is that it takes about 30 
seconds for the NET STOP to finish executing. The NET START is very fast as 
is MYSQLADMIN SHUTDOWN.

Is this behavior typical? Anything to be concerned about?

Thanks,

Dave

PS - I don't know why the "debug" is part of the version (obtained from 
SELECT VERSION()). I installed as a service using "mysqld-max --install".

_
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp.


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: I thought MySQL Supported Relationships

[Jason Yates]

On Tue, 2002-04-23 at 14:35, Andrew Kuebler wrote:
> Hello Everyone.
> 
> I'm still fairly a newbie to MySQL, but I could have sworn I read
> somewhere that MySQL supported relationships just like Access. I've
> searched the entire manual, and cannot find anything on the subject.
> Does MySQL support relationships, and if so does anyone know where I can
> find any info on the topic? Thanks!

check out http://www.innodb.com/


-Jason


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Demande d'inscription à mysql-france

[Notification de Yahoo! Groupes]

Bonjour,

Vous avez récemment demandé à vous inscrire au groupe 
mysql-france.  Comme vous êtes déjà membre de ce groupe,
votre demande ne sera pas prise en compte.

Pour toute question sur l'envoi de messages à ce groupe, 
veuillez envoyer un e-mail à [EMAIL PROTECTED]


Cordialement,

L'équipe support Yahoo! Groupes 


L'utilisation du service Yahoo! Groupes est soumise à l'acceptation des 
Conditions d'utilisation et de la Charte sur la vie privée, disponibles 
respectivement sur http://fr.docs.yahoo.com/info/utos.html et
http://fr.docs.yahoo.com/info/privacy.html

 




-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

RE: I thought MySQL Supported Relationships

[Roger Baklund]

* Andrew Kuebler
> I'm still fairly a newbie to MySQL, but I could have sworn I read
> somewhere that MySQL supported relationships just like Access. I've
> searched the entire manual, and cannot find anything on the subject.
> Does MySQL support relationships, and if so does anyone know where I can
> find any info on the topic? Thanks!

It is called 'joins', and it is mainly used within the SELECT statement:

http://www.mysql.com/doc/S/E/SELECT.html >
http://www.mysql.com/doc/J/O/JOIN.html >

-- 
Roger

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

RE: I thought MySQL Supported Relationships

[Jonathan Hilgeman]

Actually, no. The addiction to MySQL has caused many relationship break-ups.
There's probably even a database with that information out there somewhere.
Probably a MySQL database, too. Meanwhile Access supports relationships
because it blows so hard that people can't wait to get away from it and home
to their families.

- Jonathan

-Original Message-
From: Andrew Kuebler [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 23, 2002 11:35 AM
To: [EMAIL PROTECTED]
Subject: I thought MySQL Supported Relationships


Hello Everyone.

I'm still fairly a newbie to MySQL, but I could have sworn I read
somewhere that MySQL supported relationships just like Access. I've
searched the entire manual, and cannot find anything on the subject.
Does MySQL support relationships, and if so does anyone know where I can
find any info on the topic? Thanks!

Andrew
 



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

RE: mySQL "dump"

[Roger Baklund]

* On-Site
> I'm very new to mySQL and have what is probably a simple question. I've
> created my database using mySQL and it resides on my local PC. I want to
> upload it to my hosting service's server.
> 
> They tell me "You would dump the content of your mysql database on your
> local machine and then use the mysql admin section we provide inside your
> member services section to import that content to your server database."
> 
> I've looked for a "dump" type command and can't locate anything nor
> export/import. Can someone tell me how to go about getting my database
> loaded onto my hosting service's server. They support mySQL.

There is a utility called 'mysqldump' in your mysql\bin directory.

http://www.mysql.com/doc/m/y/mysqldump.html >

-- 
Roger

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

I thought MySQL Supported Relationships

[Andrew Kuebler]

Hello Everyone.

I'm still fairly a newbie to MySQL, but I could have sworn I read
somewhere that MySQL supported relationships just like Access. I've
searched the entire manual, and cannot find anything on the subject.
Does MySQL support relationships, and if so does anyone know where I can
find any info on the topic? Thanks!

Andrew
 



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

mySQL "dump"

[On-Site]

Hi,

I'm very new to mySQL and have what is probably a simple question. I've
created my database using mySQL and it resides on my local PC. I want to
upload it to my hosting service's server.

They tell me "You would dump the content of your mysql database on your
local machine and then use the mysql admin section we provide inside your
member services section to import that content to your server database."

I've looked for a "dump" type command and can't locate anything nor
export/import. Can someone tell me how to go about getting my database
loaded onto my hosting service's server. They support mySQL.

Thanks.

Pete


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: MySQL start

[Samuel Mendelowski]

Victoria Reznichenko
> Samuel,
> Tuesday, April 23, 2002, 4:04:20 PM, you wrote:
>
> SM> Can you help me in the following problem?
>
> SM> OS: Linux Slackware 8.0
> SM> Source: mysql-3.23.42.tar.gz
>
> SM> I can't start mysql after installing the source file. I did it step
> by step SM> according guidance from Install-Source file.
>
> SM> My OS is generating such messages:
>
>
> SM> root@serwer:/TEMP# mysql
> SM> ERROR 2002: Can't connect to local MySQL server through
> SM> socket '/tmp/mysql.sock' (111)
>
> Your MySQL server is not running ...
>
> SM> file serwer.err:
> SM> 020422 19:16:29  mysqld started
> SM> 020422 19:16:32  /usr/libexec/mysqld: Table 'mysql.host' doesn't
> exist SM> 020422 19:16:32  /usr/libexec/mysqld: Normal shutdown
>
> SM> 020422 19:16:32  mysqld ended
>
> Try to find file 'host.frm' in data dir. If file does exist, check your
> permissions on mysql data dir - it should belong to user and group
> mysql server is running from. If file doesn't exist, you should run
> mysql_install_db to re-create grant tables, look at:
> http://www.mysql.com/doc/m/y/mysql_install_db.html
>
I found that file. Unfortunatelly, there is no databases after running
mysql_install_db

-- 
registered linux user #123707



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Prerelease of MySQL/InnoDB-3.23.50

[Heikki Tuuri]

Andrew,

unfortunately it usually takes 7 days for the Windows binary to appear.

Regards,

Heikki

- Original Message -
From: "Andrew Chan" <[EMAIL PROTECTED]>
To: "Heikki Tuuri" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Tuesday, April 23, 2002 8:43 PM
Subject: Re: Prerelease of MySQL/InnoDB-3.23.50


> There is no download for Windows at the moment, isn't it?
>
> Andrew
> - Original Message -
> From: "Heikki Tuuri" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Tuesday, April 23, 2002 1:12 PM
> Subject: Prerelease of MySQL/InnoDB-3.23.50
>
>
> > Hi!
> >
> > InnoDB is a MySQL table type which adds transactions, row level locking,
> hot
> > backup capability, and foreign key constraints to MySQL.
> >
> > Version 3.23.50 of InnoDB features an auto-extending data file, better
> > support for InnoDB Hot Backup, and better support of foreign key
> > constraints, including ON DELETE CASCADE and ON DELETE SET NULL clauses.
> >
> > InnoDB is included in the MySQL-Max-3.23, MySQL-4.0, and MySQL-Max-4.0
> > distributions of MySQL. For more information about InnoDB see the online
> > refererence manual at http://www.innodb.com.
> >
> > Since MySQL-3.23.50 was compiled with a new glibc and a new compiler on
> > Linux, MySQL AB decided to give out a prerelease before moving it to the
> > regular downloads page. You can now find 3.23.50-pre at the following
> link:
> >
> > http://www.mysql.com/downloads/mysql-3.23-pre.html
> >
> >
> > Changelog of MySQL/InnoDB-3.23.50, April 23, 2002:
> >
> > * InnoDB now supports an auto-extending last data file. You do not need
to
> > preallocate the whole data file at the database startup.
> >
> > * Made several changes to facilitate the use of the InnoDB Hot Backup
> tool.
> > It is a separate non-free tool you can use to take online backups of
your
> > database without shutting down the server or setting any locks.
> >
> > * If you want to run the InnoDB Hot Backup tool on an auto-extending
data
> > file you have to upgrade it to version ibbackup-0.35.
> >
> > * The log scan phase in crash recovery will now run much faster.
> >
> > * Starting from this server version, the hot backup tool truncates
unused
> > ends in the backup InnoDB data files.
> >
> > * To allow the hot backup tool to work, on Windows we no longer use
> > unbuffered i/o or native async i/o; instead we use the same simulated
> async
> > i/o as on Unix.
> >
> > * You can now define the ON DELETE CASCADE or ON DELETE SET NULL clause
on
> > foreign keys.
> >
> > * FOREIGN KEY constraints now survive ALTER TABLE and CREATE INDEX.
> >
> > * We suppress the FOREIGN KEY check if any of the column values in the
> > foreign key or referenced key to be checked is the SQL NULL. This is
> > compatible with Oracle, for example.
> >
> > * SHOW CREATE TABLE now lists also foreign key constraints. Also
mysqldump
> > no longer forgets about foreign keys in table definitions.
> >
> > * You can now add a new foreign key constraint with ALTER TABLE ... ADD
> > CONSTRAINT FOREIGN KEY (...) REFERENCES ... (...).
> >
> > * FOREIGN KEY definitions now allow backquotes around table and column
> > names.
> >
> > * MySQL command SET TRANSACTION ISOLATION LEVEL ... has now the
following
> > effect on InnoDB tables: if a transaction is defined as SERIALIZABLE
then
> > InnoDB conceptually adds LOCK IN SHARE MODE to all consistent reads. If
a
> > transaction is defined to have any other isolation level, then InnoDB
> obeys
> > its default locking strategy which is REPEATABLE READ.
> >
> > * SHOW TABLE STATUS no longer sets an x-lock at the end of an
> auto-increment
> > index if the auto-increment counter has already been initialized. This
> > removes in almost all cases the surprising deadlocks caused by SHOW
TABLE
> > STATUS.
> >
> > * Fixed a bug: in a CREATE TABLE statement the string 'foreign' followed
> by
> > a non-space character confused the FOREIGN KEY parser and caused table
> > creation to fail with errno 150.
> >
> > Best regards,
> >
> > Heikki Tuuri
> > Innobase Oy
> > [EMAIL PROTECTED]
> > http://www.innodb.com
> >
> >
> >
> >
> > -
> > Before posting, please check:
> >http://www.mysql.com/manual.php   (the manual)
> >http://lists.mysql.com/   (the list archive)
> >
> > To request this thread, e-mail <[EMAIL PROTECTED]>
> > To unsubscribe, e-mail
> <[EMAIL PROTECTED]>
> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

RE: alternative to intersect in mySQL

[Roger Baklund]

* Thomas Moore

> > I know that intersect does not work yet with mySQL. I am selecting data
> from
> > two tables. Results of one select
> > would be 1, 2, 3, 4 . Results of other select 1, 2.
>
> > Want to print 1, 2.
>
> > Are there any nice workarounds using PHP or SQL?

[temporary table]

> If it is in a multi-user environment, this is undesirable. Any other
> thoughts?

Maybe you could give us some more details about the problem?

"Result of one select"...? Is this a complex joined select which you can not
expand to include the second select? Is it different hosts/databases? Why
can you not use a join?

select a.id from a,b where a.id = b.id

--
Roger


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Prerelease of MySQL/InnoDB-3.23.50

[Andrew Chan]

There is no download for Windows at the moment, isn't it?

Andrew
- Original Message -
From: "Heikki Tuuri" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, April 23, 2002 1:12 PM
Subject: Prerelease of MySQL/InnoDB-3.23.50


> Hi!
>
> InnoDB is a MySQL table type which adds transactions, row level locking,
hot
> backup capability, and foreign key constraints to MySQL.
>
> Version 3.23.50 of InnoDB features an auto-extending data file, better
> support for InnoDB Hot Backup, and better support of foreign key
> constraints, including ON DELETE CASCADE and ON DELETE SET NULL clauses.
>
> InnoDB is included in the MySQL-Max-3.23, MySQL-4.0, and MySQL-Max-4.0
> distributions of MySQL. For more information about InnoDB see the online
> refererence manual at http://www.innodb.com.
>
> Since MySQL-3.23.50 was compiled with a new glibc and a new compiler on
> Linux, MySQL AB decided to give out a prerelease before moving it to the
> regular downloads page. You can now find 3.23.50-pre at the following
link:
>
> http://www.mysql.com/downloads/mysql-3.23-pre.html
>
>
> Changelog of MySQL/InnoDB-3.23.50, April 23, 2002:
>
> * InnoDB now supports an auto-extending last data file. You do not need to
> preallocate the whole data file at the database startup.
>
> * Made several changes to facilitate the use of the InnoDB Hot Backup
tool.
> It is a separate non-free tool you can use to take online backups of your
> database without shutting down the server or setting any locks.
>
> * If you want to run the InnoDB Hot Backup tool on an auto-extending data
> file you have to upgrade it to version ibbackup-0.35.
>
> * The log scan phase in crash recovery will now run much faster.
>
> * Starting from this server version, the hot backup tool truncates unused
> ends in the backup InnoDB data files.
>
> * To allow the hot backup tool to work, on Windows we no longer use
> unbuffered i/o or native async i/o; instead we use the same simulated
async
> i/o as on Unix.
>
> * You can now define the ON DELETE CASCADE or ON DELETE SET NULL clause on
> foreign keys.
>
> * FOREIGN KEY constraints now survive ALTER TABLE and CREATE INDEX.
>
> * We suppress the FOREIGN KEY check if any of the column values in the
> foreign key or referenced key to be checked is the SQL NULL. This is
> compatible with Oracle, for example.
>
> * SHOW CREATE TABLE now lists also foreign key constraints. Also mysqldump
> no longer forgets about foreign keys in table definitions.
>
> * You can now add a new foreign key constraint with ALTER TABLE ... ADD
> CONSTRAINT FOREIGN KEY (...) REFERENCES ... (...).
>
> * FOREIGN KEY definitions now allow backquotes around table and column
> names.
>
> * MySQL command SET TRANSACTION ISOLATION LEVEL ... has now the following
> effect on InnoDB tables: if a transaction is defined as SERIALIZABLE then
> InnoDB conceptually adds LOCK IN SHARE MODE to all consistent reads. If a
> transaction is defined to have any other isolation level, then InnoDB
obeys
> its default locking strategy which is REPEATABLE READ.
>
> * SHOW TABLE STATUS no longer sets an x-lock at the end of an
auto-increment
> index if the auto-increment counter has already been initialized. This
> removes in almost all cases the surprising deadlocks caused by SHOW TABLE
> STATUS.
>
> * Fixed a bug: in a CREATE TABLE statement the string 'foreign' followed
by
> a non-space character confused the FOREIGN KEY parser and caused table
> creation to fail with errno 150.
>
> Best regards,
>
> Heikki Tuuri
> Innobase Oy
> [EMAIL PROTECTED]
> http://www.innodb.com
>
>
>
>
> -
> Before posting, please check:
>http://www.mysql.com/manual.php   (the manual)
>http://lists.mysql.com/   (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
<[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

RE: table lock - which connection id own's it

[Sinisa Milivojevic]

Lopez David E-r9374c writes:
> Monty
> 
> BTW, it's a thrill to hear from the CTO.
> 
> The procedure for locking a table is more complex but will
> attempt to describe it further for you. Any of the 150 daemons
> can insert to the hash tables. The data in the row can be used
> by all 150 daemons. The primary key in hash table is the 
> "id" field which is an auto-increment type. This "id" field
> is the hash value inserted in the main table as foreign key.
> 
> When a daemon starts up, it reads the hash table with each
> entry a key-value pair. The value is the "id" field. During
> the course of logging info to the main table, it may find
> an entry that is not in it's local hash in RAM. When this 
> occurs, it does a sql select on the hash. If a row is returned,
> it will insert the key-value pair into the it's hash and 
> insert an entry into the main table. 
> 
> If no row is returned, then the following happens:
>   1) lock table ...
>   2) select ...
>   3) if no row is returned, 
>   4)insert ...
>   5)use LAST_INSERT_ID() to get the value of the key
>   6) else get the key-value pair
>   7) unlock table
>   8) put key-value pair in RAM hash
>   9) insert row in main table (using new key-value pair)
> 
> Since >99% of the time, the data hash table information is
> already stored in the daemon hash table on initial start up.
> We wanted to lock the table so two different daemons would
> not enter the same information in the hash tables. Extremely
> unlikely, but the boss is paranoid. Or is it more experienced.
> 
> Hope that clears the insertion process on the hash tables. I'm
> glad that if a connection is lost in steps 2-6, mysql would
> automatically unlock the tables. That will satisfy the db
> specification nicely. The architecture for our db came
> from the optimization chapter in the manual. Thanks!
> 
> David
> 

Hi!

Still , locking a table is not necessary  as MySQL server remembers
LAST_INSERT_ID() value, for each connection (thread) separately.

Simply, this value is not (only) remembered on per-table basis, but
also for each thread (connection) separately.


-- 
Regards,
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]>
 / /|_/ / // /\ \/ /_/ / /__   MySQL AB, Fulltime Developer
/_/  /_/\_, /___/\___\_\___/   Larnaca, Cyprus
   <___/   www.mysql.com


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: row id

[Benjamin Pflugmann]

Hi.

Please start a new thread next time instead of replying to an existing
one with a different topic. Mailers supporting threading will put your
mail under the original thread. Thank you.

On Tue, Apr 23, 2002 at 03:23:04PM +0800, [EMAIL PROTECTED] wrote:
> Do anyone know how to select or get the row id of a row in MySQL?

AFAIK, there is no such concept like row id in MySQL. The usual way
to is to add an AUTO_INCREMENT INT to the table and use that.

Regards,

Benjamin.

-- 
[EMAIL PROTECTED]

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

RE: table lock - which connection id own's it

[Lopez David E-r9374c]

Monty

BTW, it's a thrill to hear from the CTO.

The procedure for locking a table is more complex but will
attempt to describe it further for you. Any of the 150 daemons
can insert to the hash tables. The data in the row can be used
by all 150 daemons. The primary key in hash table is the 
"id" field which is an auto-increment type. This "id" field
is the hash value inserted in the main table as foreign key.

When a daemon starts up, it reads the hash table with each
entry a key-value pair. The value is the "id" field. During
the course of logging info to the main table, it may find
an entry that is not in it's local hash in RAM. When this 
occurs, it does a sql select on the hash. If a row is returned,
it will insert the key-value pair into the it's hash and 
insert an entry into the main table. 

If no row is returned, then the following happens:
  1) lock table ...
  2) select ...
  3) if no row is returned, 
  4)insert ...
  5)use LAST_INSERT_ID() to get the value of the key
  6) else get the key-value pair
  7) unlock table
  8) put key-value pair in RAM hash
  9) insert row in main table (using new key-value pair)

Since >99% of the time, the data hash table information is
already stored in the daemon hash table on initial start up.
We wanted to lock the table so two different daemons would
not enter the same information in the hash tables. Extremely
unlikely, but the boss is paranoid. Or is it more experienced.

Hope that clears the insertion process on the hash tables. I'm
glad that if a connection is lost in steps 2-6, mysql would
automatically unlock the tables. That will satisfy the db
specification nicely. The architecture for our db came
from the optimization chapter in the manual. Thanks!

David


-Original Message-
From: Michael Widenius [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 23, 2002 12:59 AM
To: Lopez David E-r9374c
Cc: Mysql List (E-mail)
Subject: table lock - which connection id own's it



Hi!

> "Lopez" == Lopez David > writes:

Lopez> AntiSpam - mysql, sql, query
Lopez> Version: 3.23.49a, MyISAM, NT, Solaris

Lopez> My app is 150 daemons writing logs to mysql. The main 
Lopez> table is of fixed size but depends on four other tables
Lopez> for foreign keys (hash tables). These tables are uploaded
Lopez> once to the daemon at start-up. Occasionally, a new entry 
Lopez> must be written into these hash tables. The procedure is
Lopez> to lock the table, insert entry, get the key (auto-increment
Lopez> field) and release the lock.

A better solution is to use LAST_INSERT_ID() and not use any locks at all.

Lopez> But what if the connection dies during the update process.
Lopez> If this happens, how can I tell which connection id has the 
Lopez> lock so I can kill it? 

If a connection dies, the server will automaticly delete all temporary
tables and all table locks.

Regards,
Monty

-- 
For technical support contracts, goto https://order.mysql.com/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Mr. Michael Widenius <[EMAIL PROTECTED]>
 / /|_/ / // /\ \/ /_/ / /__   MySQL AB, CTO
/_/  /_/\_, /___/\___\_\___/   Helsinki, Finland
   <___/   www.mysql.com

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Strange behaviour with SQL vars and order by

[Gerald Clark]

I see no column named  Site.nome showing that it is wrong.

ds wrote:

>Hi,
>
>I'm having a strange problem using SQL vars (@variable) and an order by
>expression.
>
>I have a query that returns a record for each day. 
>Each record has a date (data), a column with the daily total value
>(uv_views) and other with the accumulated value until the current day
>(acc_views). The other columns are IDs.
>
>The problem is that if i only order by date, the results are ok...
>If i order by "date,Site.nome"  (you would say Site.name) 
>the results are wrong and i don't know where it got those results. 
>
>Here is the output. 
>I have limited the values to 4 (it only returns rows with 0 but it
>doesn't matter).
>In the second "big" (not so big) query, look at "acc_views" accumulated
>value... How can it be ?!?!
>Thank you in advance for trying to help.
>
>
>mysql> select @diario_views:=0,@acc_views:=0;
>+--+---+
>| @diario_views:=0 | @acc_views:=0 |
>+--+---+
>|0 | 0 |
>+--+---+
>1 row in set (0.00 sec)
>
>mysql>  SELECT data,
>  @diario_views:=uv_views as views, 
>  @acc_views:=@acc_views+@diario_views as acc_views, 
>  secloc.site_id,secloc.section_id,secloc.location_id 
>FROM secloc,Site,Section,Location 
>WHERE secloc.campaign_id='9' 
>  and secloc.site_id=Site.site_id 
>  and secloc.section_id=Section.section_id 
>  and secloc.location_id=Location.location_id 
>ORDER BY data LIMIT 4;
>++---+---+-++-+
>| data   | views | acc_views | site_id | section_id | location_id |
>++---+---+-++-+
>| 2001-09-20 | 0 | 0 |   2 |  1 |   4 |
>| 2001-09-20 | 0 | 0 |   3 |  1 |   4 |
>| 2001-09-20 | 0 | 0 |   4 |  1 |   4 |
>| 2001-09-20 | 0 | 0 |   6 |  1 |   4 |
>++---+---+-++-+
>4 rows in set (0.02 sec)
>
>mysql> select @diario_views:=0,@acc_views:=0;
>+--+---+
>| @diario_views:=0 | @acc_views:=0 |
>+--+---+
>|0 | 0 |
>+--+---+
>1 row in set (0.00 sec)
>
>mysql>  SELECT data,
>  @diario_views:=uv_views as views,
>  @acc_views:=@acc_views+@diario_views as acc_views, 
>  secloc.site_id,secloc.section_id,secloc.location_id 
>FROM secloc,Site,Section,Location 
>WHERE secloc.campaign_id='9' 
>  and secloc.site_id=Site.site_id 
>  and secloc.section_id=Section.section_id 
>  and secloc.location_id=Location.location_id 
>ORDER BY data,Site.nome LIMIT 4;
>++---+---+-++-+
>| data   | views | acc_views | site_id | section_id | location_id |
>++---+---+-++-+
>| 2001-09-20 | 0 |227815 |   3 |  1 |   4 |
>| 2001-09-20 | 0 |263822 |   4 |  1 |   4 |
>| 2001-09-20 | 0 | 0 |   2 |  1 |   4 |
>| 2001-09-20 | 0 |331278 |   6 |  1 |   4 |
>++---+---+-++-+
>4 rows in set (0.04 sec)
>
>mysql> 
>



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: LAST_INSERT_ID()

[Christopher Thompson]

On Tuesday 23 April 2002 1:10 pm, destr0 wrote:
> query, table
>
> When I run the query:
>
> SELECT LAST_INSERT_ID() as id FROM myTable;

This query really makes no sense.  It is almost the same as:

SELECT LAST_INSERT_ID() as id;

> It returns the last inserted Id, but why does it return that value for
> every row in the table.

What would you expect it to do?  This is working exactly as I would expect.

_Perhaps_ you mean:

SELECT id FROM myTable WHERE id = LAST_INSERT_ID();

but I am not entirely sure.

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

LAST_INSERT_ID()

[destr0]

query, table

When I run the query:

SELECT LAST_INSERT_ID() as id FROM myTable;

It returns the last inserted Id, but why does it return that value for every
row in the table.

for example.
if there are 5 total records in the table. and the last inserted Id is 9, if
I run the above query I get:

+--+
|id |
+--+
|9  |
|9  |
|9  |
|9  |
|9  |
+--+



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Prerelease of MySQL/InnoDB-3.23.50

[Heikki Tuuri]

Hi!

InnoDB is a MySQL table type which adds transactions, row level locking, hot
backup capability, and foreign key constraints to MySQL.

Version 3.23.50 of InnoDB features an auto-extending data file, better
support for InnoDB Hot Backup, and better support of foreign key
constraints, including ON DELETE CASCADE and ON DELETE SET NULL clauses.

InnoDB is included in the MySQL-Max-3.23, MySQL-4.0, and MySQL-Max-4.0
distributions of MySQL. For more information about InnoDB see the online
refererence manual at http://www.innodb.com.

Since MySQL-3.23.50 was compiled with a new glibc and a new compiler on
Linux, MySQL AB decided to give out a prerelease before moving it to the
regular downloads page. You can now find 3.23.50-pre at the following link:

http://www.mysql.com/downloads/mysql-3.23-pre.html


Changelog of MySQL/InnoDB-3.23.50, April 23, 2002:

* InnoDB now supports an auto-extending last data file. You do not need to
preallocate the whole data file at the database startup.

* Made several changes to facilitate the use of the InnoDB Hot Backup tool.
It is a separate non-free tool you can use to take online backups of your
database without shutting down the server or setting any locks.

* If you want to run the InnoDB Hot Backup tool on an auto-extending data
file you have to upgrade it to version ibbackup-0.35.

* The log scan phase in crash recovery will now run much faster.

* Starting from this server version, the hot backup tool truncates unused
ends in the backup InnoDB data files.

* To allow the hot backup tool to work, on Windows we no longer use
unbuffered i/o or native async i/o; instead we use the same simulated async
i/o as on Unix.

* You can now define the ON DELETE CASCADE or ON DELETE SET NULL clause on
foreign keys.

* FOREIGN KEY constraints now survive ALTER TABLE and CREATE INDEX.

* We suppress the FOREIGN KEY check if any of the column values in the
foreign key or referenced key to be checked is the SQL NULL. This is
compatible with Oracle, for example.

* SHOW CREATE TABLE now lists also foreign key constraints. Also mysqldump
no longer forgets about foreign keys in table definitions.

* You can now add a new foreign key constraint with ALTER TABLE ... ADD
CONSTRAINT FOREIGN KEY (...) REFERENCES ... (...).

* FOREIGN KEY definitions now allow backquotes around table and column
names.

* MySQL command SET TRANSACTION ISOLATION LEVEL ... has now the following
effect on InnoDB tables: if a transaction is defined as SERIALIZABLE then
InnoDB conceptually adds LOCK IN SHARE MODE to all consistent reads. If a
transaction is defined to have any other isolation level, then InnoDB obeys
its default locking strategy which is REPEATABLE READ.

* SHOW TABLE STATUS no longer sets an x-lock at the end of an auto-increment
index if the auto-increment counter has already been initialized. This
removes in almost all cases the surprising deadlocks caused by SHOW TABLE
STATUS.

* Fixed a bug: in a CREATE TABLE statement the string 'foreign' followed by
a non-space character confused the FOREIGN KEY parser and caused table
creation to fail with errno 150.

Best regards,

Heikki Tuuri
Innobase Oy
[EMAIL PROTECTED]
http://www.innodb.com




-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: MySQL with Delphi 5.0

[Alexander Burbello]

I tryed to use Delphi 6.0 and dbExpress, but I didn't got.

What component and what property I have to set for use correct??


Regards


Alexander


>-- Mensagem Original --
>
>>  Hi, Haroldo
>>
>>  Is it first time to develop Database Application with Delphi?
>>  Do you know how to use DataAccess Component(e.g., TDatabase) and
>>BDE(or BDE Administrator)?
>>
>>  I suggest to use Delphi6 Pro/Ent. It contains dbExpress Component which
>>help you to develop Database Application very easily.
>>  (Note: dbExpress is able to connect to MySQL server directly,
>>using Native Driver without ODBC Driver)
>>
>>Thanks.
>>
>>--
>>Borland Japan / Consulting Group
>>TAKAHASHI, "KEN", Tomohiro
>>
>>José Haroldo Filho wrote:
>>>
>>> I've installed MyODBC and then I've set up ODBC and I saw the driver
>for
>>> MySQL DB, when I try to create a new alias wiht MySQL it does not apear
>>to
>>> select the DB, acording a book wich is guiding it should has to appear.
>>>
>>> Can anybody help to set up the ALIAS with MySQL
>>>
>>> Thanks
>>
>>-
>>Before posting, please check:
>>   http://www.mysql.com/manual.php   (the manual)
>>   http://lists.mysql.com/   (the list archive)
>>
>>To request this thread, e-mail <[EMAIL PROTECTED]>
>>To unsubscribe, e-mail <[EMAIL PROTECTED]>
>>Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>>
>>
>
>
>
>
>
>A busca mais veloz e precisa da internet. Acesse agora: http://www.zoom.com.br.
>
>





A busca mais veloz e precisa da internet. Acesse agora: http://www.zoom.com.br.


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: MySQL with Delphi 5.0

[Alexander Burbello]

I tryed to use Delphi 6.0 and dbExpress, but I didn't got.

What component and what property I have to set for use correct??


Regards


Alexander


-- Mensagem Original --

>  Hi, Haroldo
>
>  Is it first time to develop Database Application with Delphi?
>  Do you know how to use DataAccess Component(e.g., TDatabase) and
>BDE(or BDE Administrator)?
>
>  I suggest to use Delphi6 Pro/Ent. It contains dbExpress Component which
>help you to develop Database Application very easily.
>  (Note: dbExpress is able to connect to MySQL server directly,
>using Native Driver without ODBC Driver)
>
>Thanks.
>
>--
>Borland Japan / Consulting Group
>TAKAHASHI, "KEN", Tomohiro
>
>José Haroldo Filho wrote:
>>
>> I've installed MyODBC and then I've set up ODBC and I saw the driver
for
>> MySQL DB, when I try to create a new alias wiht MySQL it does not apear
>to
>> select the DB, acording a book wich is guiding it should has to appear.
>>
>> Can anybody help to set up the ALIAS with MySQL
>>
>> Thanks
>
>-
>Before posting, please check:
>   http://www.mysql.com/manual.php   (the manual)
>   http://lists.mysql.com/   (the list archive)
>
>To request this thread, e-mail <[EMAIL PROTECTED]>
>To unsubscribe, e-mail <[EMAIL PROTECTED]>
>Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>





A busca mais veloz e precisa da internet. Acesse agora: http://www.zoom.com.br.


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: MySQL with Delphi 5.0

[massey]

Several ways to do this, MyODBC, ZEOS, ASTA. dbExpress has issues, these
can be confirmed in the Borland News groups.
ZEOS works well and is free, MyODBC works but the BDE must be installed on
the Client if the native database componets id D6 - D5 is used, ASTA is
fast and excellent for Internet applications.

http://www.zeoslib.org/
www.astatech.com

I personaly use ASTA and ZEOS :)



>  Hi, Haroldo
>
>  Is it first time to develop Database Application with Delphi?
>  Do you know how to use DataAccess Component(e.g., TDatabase) and
> BDE(or BDE Administrator)?
>
>  I suggest to use Delphi6 Pro/Ent. It contains dbExpress Component
>  which
> help you to develop Database Application very easily.
>  (Note: dbExpress is able to connect to MySQL server directly,
> using Native Driver without ODBC Driver)
>
> Thanks.
>
> --
> Borland Japan / Consulting Group
> TAKAHASHI, "KEN", Tomohiro
>
> José Haroldo Filho wrote:
>>
>> I've installed MyODBC and then I've set up ODBC and I saw the driver
>> for MySQL DB, when I try to create a new alias wiht MySQL it does not
>> apear to select the DB, acording a book wich is guiding it should has
>> to appear.
>>
>> Can anybody help to set up the ALIAS with MySQL
>>
>> Thanks
>
> -
> Before posting, please check:
>   http://www.mysql.com/manual.php   (the manual)
>   http://lists.mysql.com/   (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]> To
> unsubscribe, e-mail <[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

RE: Further Question with --> table lock - which connection id own's it

[Roger Baklund]

* Shaun Bramley
> Depending on how many people are updating this db should ultimately
> determine your decision to remove the table locks.  If hte db is only
> experiencing one person updating it then it is not necessary.  However if
> multiple people are updating it, then you will want to keep the locks.

Why? Do you not trust LAST_INSERT_ID(), or is there another reason?

-- 
Roger
query


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

REPLACE() & wildcards

[Gavin McCullagh]

Hi,

When using the REPLACE() function in a query, are there any wildcards
allowed?  If so what are they?

Also are regular expressions only usable for matching or can one also do a
regular expression substitute in some way?

Thanks

Gavin


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

UDF's Under Windows

[Mike Grover]

Does MySQL 4 support udf's under Windows?


  Mike..


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

RE: alternative to intersect in mySQL

[Thomas Moore]

If it is in a multi-user environment, this is undesirable. Any other
thoughts?

I was thinking of doing arrays in PHP and then using array_intersect PHP
function, but would prefer a cleaner way.

-Original Message-
From: Aleksandar Bradaric [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 23, 2002 1:08 AM
To: Thomas Moore
Cc: MySQL List
Subject: Re: alternative to intersect in mySQL


Hi,

> I know that intersect does not work yet with mySQL. I am selecting data
from
> two tables. Results of one select
> would be 1, 2, 3, 4 . Results of other select 1, 2.

> Want to print 1, 2.

> Are there any nice workarounds using PHP or SQL?

You  could  use a temporary table to store the result of the
first  query  and  join the second query with it afterwards.
Nice enough? :)


Regards,
Sasa

»mysql, select, database«


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: mysqldump

[Harpreet Kaur]

Dont worry. It worked. Yes i was supposed to create the database before 
using the restore command as it couldnt find the database.

Thanks neways,
Regards,
Harpreet kaur


>From: "Harpreet Kaur" <[EMAIL PROTECTED]>
>To: [EMAIL PROTECTED]
>Subject: Re: mysqldump
>Date: Tue, 23 Apr 2002 16:08:23 +
>
>The mysql is working now and i can get into it. But when i type
>mysql databasename < /home/backup/backup_databasename.sql
>
>
>To restore a database do i need to have the database created first.
>
>i get an error message
>error 1044: access denied for user @localhost to database databasename
>
>If i log on as su root
>i get error message
>error 1049: unknown database databasename
>
>but i dont have the databas eyet . I want to create a new database.
>
>_
>Join the world’s largest e-mail service with MSN Hotmail.
>http://www.hotmail.com
>
>
>-
>Before posting, please check:
>   http://www.mysql.com/manual.php   (the manual)
>   http://lists.mysql.com/   (the list archive)
>
>To request this thread, e-mail <[EMAIL PROTECTED]>
>To unsubscribe, e-mail 
><[EMAIL PROTECTED]>
>Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>


_
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp.


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Update

[Chris Johnson]

I'd have to guess that MySQL is interpreting the "set" clause this way:

Set events_ID = ( 512 AND ( term = 'changed' ))

That is, a logical AND, so a zero result makes sense.  Still, it seems a bit
odd.


- Original Message -
From: "Salada, Duncan" <[EMAIL PROTECTED]>


For one of two reasons (probably) - and I think you found a bug:

1.  The syntax in your "set" clause is wrong.  It should be "set
alternatepreference='C',AltContactID='1'"  *Notice the use of a comma
instead of "and"*

2.  The row that matched the conditions in the "where" clause may already be
set to those values.  MySQL will not update a row needlessly.

I tried out your syntax on MySQL 3.23.47 (i.e. using "and" in the "set"
clause) and got some unexpected results.  Below is a synopsis of what
happened when I ran a query with the "and" syntax on my machine.

THE FIRST TIME
update events_terms set events_ID=512 and term='changed' where ID=108;
Query OK, 1 row affected (0.00 sec)
Rows matched: 1  Changed: 1  Warnings: 0

It says a row was changed and it was -- but not correctly!  The events_ID
column was set to 0 and the term column was not changed at all.  That
doesn't seem like the correct behavior.  Then executed the query again...





-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: mysqldump

[Harpreet Kaur]

The mysql is working now and i can get into it. But when i type
mysql databasename < /home/backup/backup_databasename.sql


To restore a database do i need to have the database created first.

i get an error message
error 1044: access denied for user @localhost to database databasename

If i log on as su root
i get error message
error 1049: unknown database databasename

but i dont have the databas eyet . I want to create a new database.

_
Join the world’s largest e-mail service with MSN Hotmail. 
http://www.hotmail.com


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: problem with libmysqlclient_r.so

[Sinisa Milivojevic]

Andrey Kotrekhov writes:
> 
> 
> my program crash in another plase
> (gdb) bt
> #0  _db_enter_ (_func_=0x280fe4dc "mysql_ping",
> _file_=0x280fdd48 "libmysql.c", _line_=2248, _sfunc_=0xbfa87d3c,
> _sfile_=0xbfa87d40, _slevel_=0xbfa87d44, _sframep_=0xbfa87d48)
> at dbug.c:712
> #1  0x280eceae in mysql_ping (mysql=0x80c9c1c) at libmysql.c:2248
> #2  0x80832d2 in QueueModule::Run (this=0x80c9c00)
> at /usr/local/mysql++/include/connection1.hh:80
> #3  0x8068b2f in start_Module (ptr=0x80c9c00) at Module.cc:23
> #4  0x282063af in _thread_start () from /usr/lib/libc_r.so.4
> #5  0x0 in ?? ()
> (gdb) p state
> $1 = (CODE_STATE *) 0x0
> (gdb)
> why code_state() return NULL?
> Is this right?
> 
> >
> 
> Best regards.
> ___
>   Andrey Kotrekhov [EMAIL PROTECTED]
>   ISP Alkar Teleport
>   ÔÅÌ. +380 562 34-00-44
> 
 
Does not seem like our bug !

Because last time it crashed in a completely different place. Plus, it
is unlikely that it would crash in ping. Check out your compiler
version and whether libstdc++ got linked into the binary.

-- 
Regards,
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]>
 / /|_/ / // /\ \/ /_/ / /__   MySQL AB, Fulltime Developer
/_/  /_/\_, /___/\___\_\___/   Larnaca, Cyprus
   <___/   www.mysql.com


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: mysqldump

[David BORDAS]

- Original Message -
From: "Harpreet Kaur" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, April 23, 2002 5:44 PM
Subject: mysqldump


> Dear group members
>
> I did a mysqldump on my machine at home to backup a database. I saved the
> file to the /home/backup folder at my work and am trying to restore the
> database using
> mysql databasename < /home/backup/backup_databasename.sql
>
> I get the following error:
> Cannot connetc to local mysql server through socket
'var/lib/mysql/mysql.soc
> (2)
>
> What is wrong. Please help.
>
> Regards,
> Harpreet kaur
>
>
It seems that your mysql server isn't launched.
Try
ps -Al | grep mysql

to see if there are somme mysql process up ...

Hope this help
David


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

mysqldump

[Harpreet Kaur]

Dear group members

I did a mysqldump on my machine at home to backup a database. I saved the 
file to the /home/backup folder at my work and am trying to restore the 
database using
mysql databasename < /home/backup/backup_databasename.sql

I get the following error:
Cannot connetc to local mysql server through socket 'var/lib/mysql/mysql.soc 
(2)

What is wrong. Please help.

Regards,
Harpreet kaur


_
Join the world’s largest e-mail service with MSN Hotmail. 
http://www.hotmail.com


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Help needed on query

[Chris Johnson]

You should be able to just use something like this:

Select uid, username From tablename Where '$externalstringvar' like query;

That's PHP syntax.  You'll have to use whatever makes sense for your
scripting or programming language in place of the $externalstringvar
variable.  The single-quotes are required.

Note this will always do a full table scan, so if your table is big, it will
be slow.

..chris

- Original Message -
From: "thor" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, April 23, 2002 4:22 AM
Subject: Help needed on query


I have a table like this one:

+-+---+---+
| uid | username  | query |
+-+---+---+
|   1 | someuser  | %qu1% |
|   2 | anotheru  | bla%  |
+-+---+---+

I get a string from external source, let's say the string is 'blahblah'.

Now I need a query which will take the values from column 'query', treat
them
as patterns for matching and return row(s) which match the given string
'blahblah'. In this example, the matched data is obviously in second row.
(bla% matches blahblah)

Do I make any sense? Is this possible?
Any help will be greatly appreciated.





-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

RE: Update

[Salada, Duncan]

For one of two reasons (probably) - and I think you found a bug:

1.  The syntax in your "set" clause is wrong.  It should be "set
alternatepreference='C',AltContactID='1'"  *Notice the use of a comma
instead of "and"*

2.  The row that matched the conditions in the "where" clause may already be
set to those values.  MySQL will not update a row needlessly.

I tried out your syntax on MySQL 3.23.47 (i.e. using "and" in the "set"
clause) and got some unexpected results.  Below is a synopsis of what
happened when I ran a query with the "and" syntax on my machine.

THE FIRST TIME
update events_terms set events_ID=512 and term='changed' where ID=108;
Query OK, 1 row affected (0.00 sec)
Rows matched: 1  Changed: 1  Warnings: 0

It says a row was changed and it was -- but not correctly!  The events_ID
column was set to 0 and the term column was not changed at all.  That
doesn't seem like the correct behavior.  Then executed the query again...

THE SECOND TIME
update events_terms set events_ID=512 and term='changed' where ID=108;
Query OK, 0 rows affected (0.00 sec)
Rows matched: 1  Changed: 0  Warnings: 0

No rows changed that time -- as should be the case.  Changing the syntax to
"update events_terms set events_ID=512,term='changed' where ID=108;" yielded
the desired results -- events_ID was set to 512 and term was set to changed.


Duncan
--
Duncan Salada | Titan | www.titan.com/testeval
Email: [EMAIL PROTECTED] | Voice: 301-925-3222x375 | Fax: 301-925-3216

> -Original Message-
> From: Richard Morton [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, April 23, 2002 10:44 AM
> To: MySQL List
> Subject: Update
> 
> 
> mysql> update contact set alternatepreference='C' and 
> AltContactID='1' where
> con
> tactid=2;
> Query OK, 0 rows affected (0.00 sec)
> Rows matched: 1  Changed: 0  Warnings: 0
> 
> 
> any ideas why the UPDATE did not perform an update?
> 
> Thanks
> 
> Rich
> 
> 
> -
> Before posting, please check:
>http://www.mysql.com/manual.php   (the manual)
>http://lists.mysql.com/   (the list archive)
> 
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail 
> <[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
> 

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Checking if a table exists?

[Shaun Bramley]

Hello,

PHP has a function call that will return the table names within as an array.
The function name is mysql_list_tables()

Shaun
- Original Message -
From: "BD" <[EMAIL PROTECTED]>
To: "Bo Mellberg" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Tuesday, April 23, 2002 10:38 AM
Subject: Re: Checking if a table exists?


> At 04:58 AM 4/23/2002, you wrote:
> >Hi!
> >
> >How do check if a certain table exists? I have to know if
> >the table exists and then make a query in that
> >table. I mean to use it in a function so the SHOW TABLES
> >is not an option...
> >
> >I have tried the "sysobjects" solution but it comes back with:
> >
> >table 'lve.sysobjects' doesn't exist.
> >
> >Thanks for reading,
> >
> >/Bo
>
> Bo,
>  This question came up before. I would try something like "select
1
> from mytable limit 0" and if it throws and error, the table doesn't
> exist.  If you are using PHP you can use the @ symbol in front of the
mysql
> call to supress the error message. I suggest using "1" because it is an
> arbitrary constant and I don't have to know the field name.
>
>  Someone else came up with the idea of executing "show tables like
> mytable" and if a row is returned, the table exists. Now I don't know if
> MySQL can turn off "Show Tables" like it can "Show Databases". If you can
> turn it off, then the "Show tables ..." won't be a universal solution.
>
> Brent
>
>
> _
> Do You Yahoo!?
> Get your free @yahoo.com address at http://mail.yahoo.com
>
>
> -
> Before posting, please check:
>http://www.mysql.com/manual.php   (the manual)
>http://lists.mysql.com/   (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
<[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Update

[Richard Morton]

mysql> update contact set alternatepreference='C' and AltContactID='1' where
con
tactid=2;
Query OK, 0 rows affected (0.00 sec)
Rows matched: 1  Changed: 0  Warnings: 0


any ideas why the UPDATE did not perform an update?

Thanks

Rich


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Checking if a table exists?

[BD]

At 04:58 AM 4/23/2002, you wrote:
>Hi!
>
>How do check if a certain table exists? I have to know if
>the table exists and then make a query in that
>table. I mean to use it in a function so the SHOW TABLES
>is not an option...
>
>I have tried the "sysobjects" solution but it comes back with:
>
>table 'lve.sysobjects' doesn't exist.
>
>Thanks for reading,
>
>/Bo

Bo,
 This question came up before. I would try something like "select 1 
from mytable limit 0" and if it throws and error, the table doesn't 
exist.  If you are using PHP you can use the @ symbol in front of the mysql 
call to supress the error message. I suggest using "1" because it is an 
arbitrary constant and I don't have to know the field name.

 Someone else came up with the idea of executing "show tables like 
mytable" and if a row is returned, the table exists. Now I don't know if 
MySQL can turn off "Show Tables" like it can "Show Databases". If you can 
turn it off, then the "Show tables ..." won't be a universal solution.

Brent


_
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Further Question with --> table lock - which connection id own's it

[Shaun Bramley]

Hello,

Depending on how many people are updating this db should ultimately
determine your decision to remove the table locks.  If hte db is only
experiencing one person updating it then it is not necessary.  However if
multiple people are updating it, then you will want to keep the locks.

Here is a simple example of the last_insert_id without using table locks.


CREATE TABLE Temp (
   temp_idINT NOT NULL PRIMARY KEY AUTO_INCREMENT,
   valueINT);

INSERT INTO Temp VALUES(null, 5);

SELECT Temp.value from Temp WHERE Temp.temp_id = last_insert_id();



- Original Message -
From: "Luciano Barcaro" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, April 23, 2002 9:49 AM
Subject: Re: Further Question with --> table lock - which connection id
own's it




*** REPLY SEPARATOR  ***

>Hi ...
>
>just wanted to added another question to this one...
>
>you suggested to use LAST_INSERT_ID() , but the
>question is if there are concurrent access to the
>database, how will you get the last id without locking
>the table.

Don't worry about concurrent access... the last_insert_id()
returns the last id inserted by your process (connection).

>
>Because what I've been doing is also:
>1. lock the table
>2. get the id
>3. release lock
>
>Could you further explain the LAST_INSERT_ID() a
>little more and how to complish it without using
>locks.
>
>thank you.
>
>Sukhdev.
>
>--- Michael Widenius <[EMAIL PROTECTED]> wrote:
>>
>> Hi!
>>
>> > "Lopez" == Lopez David > <[EMAIL PROTECTED]>> writes:
>>
>> Lopez> AntiSpam - mysql, sql, query
>> Lopez> Version: 3.23.49a, MyISAM, NT, Solaris
>>
>> Lopez> My app is 150 daemons writing logs to mysql.
>> The main
>> Lopez> table is of fixed size but depends on four
>> other tables
>> Lopez> for foreign keys (hash tables). These tables
>> are uploaded
>> Lopez> once to the daemon at start-up. Occasionally,
>> a new entry
>> Lopez> must be written into these hash tables. The
>> procedure is
>> Lopez> to lock the table, insert entry, get the key
>> (auto-increment
>> Lopez> field) and release the lock.
>>
>> A better solution is to use LAST_INSERT_ID() and not
>> use any locks at all.
>>
>> Lopez> But what if the connection dies during the
>> update process.
>> Lopez> If this happens, how can I tell which
>> connection id has the
>> Lopez> lock so I can kill it?
>>
>> If a connection dies, the server will automaticly
>> delete all temporary
>> tables and all table locks.
>>
>> Regards,
>> Monty
>>
>> --
>> For technical support contracts, goto
>> https://order.mysql.com/
>>__  ___ ___   __
>>   /  |/  /_ __/ __/ __ \/ /Mr. Michael Widenius
>> <[EMAIL PROTECTED]>
>>  / /|_/ / // /\ \/ /_/ / /__   MySQL AB, CTO
>> /_/  /_/\_, /___/\___\_\___/   Helsinki, Finland
>><___/   www.mysql.com
>>
>>
>-
>> Before posting, please check:
>>http://www.mysql.com/manual.php   (the manual)
>>http://lists.mysql.com/   (the list
>> archive)
>>
>> To request this thread, e-mail
>> <[EMAIL PROTECTED]>
>> To unsubscribe, e-mail
>>
><[EMAIL PROTECTED]>
>> Trouble unsubscribing? Try:
>> http://lists.mysql.com/php/unsubscribe.php
>>
>
>
>__
>Do You Yahoo!?
>Yahoo! Games - play chess, backgammon, pool and more
>http://games.yahoo.com/
>
>-
>Before posting, please check:
>   http://www.mysql.com/manual.php   (the manual)
>   http://lists.mysql.com/   (the list archive)
>
>To request this thread, e-mail <[EMAIL PROTECTED]>
>To unsubscribe, e-mail
><[EMAIL PROTECTED]>
>Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

fim do besteirol todo que Sukhdev Sethi escreveu.
---
\|/   __   \|/
`@"  / o .  \  "@'Microsoft? Por acaso é alguma
/___| \/ |___\marca de papel higiênico?
 \___U__/
  .^.  Luciano Barcaro - Linux User #99517
  /v\  Seja também um feliz usuário de linux
 // \\ Registre-se gratuitamente em
/( . )\http://counter.li.org
 ^`~'^ ICQ #
---



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail
<[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.

Re: MySQL with Delphi 5.0

[TAKAHASHI, Tomohiro]

  Hi, Haroldo

  Is it first time to develop Database Application with Delphi?
  Do you know how to use DataAccess Component(e.g., TDatabase) and
BDE(or BDE Administrator)?

  I suggest to use Delphi6 Pro/Ent. It contains dbExpress Component which
help you to develop Database Application very easily.
  (Note: dbExpress is able to connect to MySQL server directly,
using Native Driver without ODBC Driver)

Thanks.

-- 
Borland Japan / Consulting Group
TAKAHASHI, "KEN", Tomohiro

José Haroldo Filho wrote:
> 
> I've installed MyODBC and then I've set up ODBC and I saw the driver for
> MySQL DB, when I try to create a new alias wiht MySQL it does not apear to
> select the DB, acording a book wich is guiding it should has to appear.
> 
> Can anybody help to set up the ALIAS with MySQL
> 
> Thanks

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Pre-release of MySQL 3.23.50

[Trond Eivind Glomsrød]

Philip Molter <[EMAIL PROTECTED]> writes:

> On Tue, Apr 23, 2002 at 10:26:04AM +0300, Michael Widenius wrote:
> : 
> : Hi!
> : 
> : 3.23.50 is basicly just a bug fix release compare do 3.23.49a
> : 
> : There is however two things one should be aware of regarding 3.23.50
> : (both only affecting our Linux x86 binaries (normal and RPM's):
> : 
> : - We have switched to a new updated glib library, because we found a
> :   critical memory corruption bug (introduced by us) in the old glibc
> :   library that we used to compile 3.23.49.
> :   (older MySQL binaries are not affected by this problem)
> : - We have changed compiler to gcc 3.0.4 (because the old gcc compiler
> :   we used couldn't compile with an alternative glibc library).
> 
> Does this affect people who compile MySQL on their own on Linux?
> If I have my RH7.2 box and I compile my own version of MySQL, am
> I going to hit these memory corruption issues?

No, as we don't use a glibc patched in this way.

-- 
Trond Eivind Glomsrød
Red Hat, Inc.

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: problem with libmysqlclient_r.so

[Andrey Kotrekhov]

äÏÂÒÙÊ ÄÅÎØ.

> > program crash in my_fopen
> >
> > this is stack of program :
> > (gdb) bt
> > #0  0x180ef7f2 in my_fopen () from
> > /usr/local/mysql/lib/libmysqlclient_r.so.10
> > #1  0x180f0b20 in search_default_file ()
> >from /usr/local/mysql/lib/libmysqlclient_r.so.10
>
> [skip]
>
> Hi!
>
> First of all, what version of limysql are you using ??
>

OK. I got mysql-3.23.49, configure it:
./configure  \
"--prefix=/usr/local/mysql" \
"--with-debug" \
"--with-charset=koi8_ru" \
"--with-extra-charset=koi8_ukr,win1251,win1251ukr" \
"--with-mysqld-user=mysql" \
--without-berkeley-db \
--with-innodb \
--enable-thread-safe-client

OS: FreeBSD 4.5-STABLE (cvsup today :) )

my program crash in another plase
(gdb) bt
#0  _db_enter_ (_func_=0x280fe4dc "mysql_ping",
_file_=0x280fdd48 "libmysql.c", _line_=2248, _sfunc_=0xbfa87d3c,
_sfile_=0xbfa87d40, _slevel_=0xbfa87d44, _sframep_=0xbfa87d48)
at dbug.c:712
#1  0x280eceae in mysql_ping (mysql=0x80c9c1c) at libmysql.c:2248
#2  0x80832d2 in QueueModule::Run (this=0x80c9c00)
at /usr/local/mysql++/include/connection1.hh:80
#3  0x8068b2f in start_Module (ptr=0x80c9c00) at Module.cc:23
#4  0x282063af in _thread_start () from /usr/lib/libc_r.so.4
#5  0x0 in ?? ()
(gdb) p state
$1 = (CODE_STATE *) 0x0
(gdb)
why code_state() return NULL?
Is this right?

> Second, please do : frame 1 and let us know the values for the
> following parameters :
>
>   const char *dir, const char *config_file,  const char *ext, TYPELIB *group)
>

Best regards.
___
Andrey Kotrekhov [EMAIL PROTECTED]
ISP Alkar Teleport
ÔÅÌ. +380 562 34-00-44



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

How to update/insert to a blob?

[GUAN CONLITH]

HI Gurus,
I am very in need of dealing object serialization in / out a database, but I 
want to do it independent of any dbm such as ADO, ODBC etc, and I believe 
there is a sql statement to do it(though may not implemented in sql92), can 
you tell me?
Thanks a lot!

_
Chat with friends online, try MSN Messenger: http://messenger.msn.com


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: trying to cpmpile mysql with hebrew

[Victoria Reznichenko]

Afgin,
Tuesday, April 23, 2002, 1:14:17 PM, you wrote:

AS> I try to compile mysql with hebrew and did not success.
AS> I compile it on solaris 5.6.

AS> When I configure it with:
AS> ./configure --prefix=/usr/local/mysql-3.23.49 --with-low-memory
AS> --with-extra-charsets=complex --with-charset=hebrew --enable-assembler

AS> or When I configure it with:
AS> ./configure --prefix=/usr/local/mysql-3.23.49 --with-low-memory
AS> --with-charset=hebrew --with-extra-charsets=hebrew --enable-assembler

AS> I get the error:
AS> 020418 15:21:22  mysqld started
AS> 020418 15:21:23  /usr/local/mysql-3.23.49/libexec/mysqld: File
AS> '/usr/local/mysql
AS> -3.23.49/share/mysql/charsets/latin1.conf' not found (Errcode: 2)
AS> 020418 15:21:23  /usr/local/mysql-3.23.49/libexec/mysqld: Character set
AS> '#8' is
AS> not a compiled character set and is not specified in the
AS> '/usr/local/mysql-3.23.
AS> 49/share/mysql/charsets/Index' file
AS> 020418 15:21:23  /usr/local/mysql-3.23.49/libexec/mysqld: Can't open file:
AS> 'tabl
AS> es_priv.MYD'. (errno: 142)
AS> /usr/local/mysql-3.23.49/libexec/mysqld: ready for connections

AS> Any one know any clue?
AS> Please reply directly to me to [EMAIL PROTECTED]

By default MySQL uses latin1 character set. You have compiled only with
hebrew character set. So, latin1 is not available then. 

Try to compile MySQL with latin1, too. 

AS> Any ideas are welcome.
AS> Thanks,
AS> Shlomit.




-- 
For technical support contracts, goto https://order.mysql.com/
This email is sponsored by Ensita.net http://www.ensita.net/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Victoria Reznichenko
 / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.net
   <___/   www.mysql.com




-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

unable to build mysql-3.23.49 on Solaris2.6

[Anderson, Robert]

>Description:
I am unable to build mysql-3.23.49 on Solaris2.6 using gcc 2.95.3.
Build fails with following error in mysql-3.23.49/sql.  Rest of project
builds successfully.   

.
.
.
Making all in sql
Making all in share
make[3]: Nothing to be done for `all'.
/bin/sh ../libtool --mode=link gcc  -O3 -DDBUG_OFF -O3 -felide-constructors
-fno-exceptions -fno-rtti  -fno-implicit-templates -fno-exceptions -
fno-rtti -DHAVE_RWLOCK_T  -o mysqld  sql_lex.o item.o item_sum.o item_buff.o
item_func.o item_cmpfunc.o item_strfunc.o item_timefunc.o thr_mallo
c.o item_create.o field.o key.o sql_class.o sql_list.o net_serv.o violite.o
net_pkg.o lock.o my_lock.o sql_string.o sql_manager.o sql_map.o mysq
ld.o password.o hash_filo.o hostname.o convert.o sql_parse.o sql_yacc.o
sql_base.o table.o sql_select.o sql_insert.o sql_update.o sql_delete.o s
ql_do.o procedure.o item_uniq.o sql_test.o log.o log_event.o init.o derror.o
sql_acl.o unireg.o time.o opt_range.o opt_sum.o opt_ft.o records.o 
filesort.o handler.o ha_heap.o ha_myisam.o ha_myisammrg.o ha_berkeley.o
ha_innobase.o ha_gemini.o ha_isam.o ha_isammrg.o sql_db.o sql_table.o sq
l_rename.o sql_crypt.o sql_load.o mf_iocache.o field_conv.o sql_show.o
sql_udf.o sql_analyse.o sql_cache.o slave.o sql_repl.o mini_client.o mini
_client_errors.o md5.o stacktrace.o ../isam/libnisam.a
../merge/libmerge.a ../myisam/libmyisam.a  .
./myisammrg/libmyisammrg.a  ../heap/libheap.a
../mysys/libmysys.a ../dbug/libdbug.
a   ../regex/libregex.a
../strings/libmystrings.a-ldl  -lpthread -lthread -lz -lcrypt -lgen
-lsocket
 -lnsl -lm  -lpthread -lthread
gcc -O3 -DDBUG_OFF -O3 -felide-constructors -fno-exceptions -fno-rtti
-fno-implicit-templates -fno-exceptions -fno-rtti -DHAVE_RWLOCK_T -o mysql
d sql_lex.o item.o item_sum.o item_buff.o item_func.o item_cmpfunc.o
item_strfunc.o item_timefunc.o thr_malloc.o item_create.o field.o key.o sql
_class.o sql_list.o net_serv.o violite.o net_pkg.o lock.o my_lock.o
sql_string.o sql_manager.o sql_map.o mysqld.o password.o hash_filo.o hostnam
e.o convert.o sql_parse.o sql_yacc.o sql_base.o table.o sql_select.o
sql_insert.o sql_update.o sql_delete.o sql_do.o procedure.o item_uniq.o sql
_test.o log.o log_event.o init.o derror.o sql_acl.o unireg.o time.o
opt_range.o opt_sum.o opt_ft.o records.o filesort.o handler.o ha_heap.o ha_m
yisam.o ha_myisammrg.o ha_berkeley.o ha_innobase.o ha_gemini.o ha_isam.o
ha_isammrg.o sql_db.o sql_table.o sql_rename.o sql_crypt.o sql_load.o m
f_iocache.o field_conv.o sql_show.o sql_udf.o sql_analyse.o sql_cache.o
slave.o sql_repl.o mini_client.o mini_client_errors.o md5.o stacktrace.o
 ../isam/libnisam.a ../merge/libmerge.a ../myisam/libmyisam.a
../myisammrg/libmyisammrg.a ../heap/libheap.a ../mysys/libmysys.a
../dbug/libdbug.
a ../regex/libregex.a ../strings/libmystrings.a -ldl -lpthread -lthread -lz
-lcrypt -lgen -lsocket -lnsl -lm -lpthread -lthread
/usr/local/lib/gcc-lib/sparc-sun-solaris2.6/2.95.3/libgcc.a: could not read
symbols: Bad value
collect2: ld returned 1 exit status
make[3]: *** [mysqld] Error 1
make[2]: *** [all-recursive] Error 1
make[1]: *** [all-recursive] Error 1
make: *** [all-recursive-am] Error 1
>How-To-Repeat:
In top-level directory of mysql project (mysql-3.23.49) after 
running ./configure

prompt>make   

always get error found in the Description section.
>Fix:

>Submitter-Id:  
>Originator:Robert Anderson
>Organization:
 
>MySQL support: [none | licence | email support | extended email support ]
>Synopsis:  unable to build mysql-3.23.49 on Solaris2.6
>Severity:  
>Priority:  
>Category:  mysql
>Class: 
>Release:   mysql-3.23.49 (Source distribution)

>Environment:

System: SunOS jafar 5.6 Generic_105181-23 sun4u sparc SUNW,Ultra-4
Architecture: sun4

Some paths:  /usr/local/bin/perl /home/rcsadmin/gmake.Sun/make
/usr/local/bin/gmake /usr/local/bin/gcc /opt/SUNWspro/SC5.0/bin/cc
GCC: Reading specs from
/usr/local/lib/gcc-lib/sparc-sun-solaris2.6/2.95.3/specs
gcc version 2.95.3 20010315 (release)
Compilation info: CC='gcc'  CFLAGS='-O3'  CXX='gcc'  CXXFLAGS='-O3
-felide-constructors -fno-exceptions -fno-rtti'  LDFLAGS=''
LIBC: 
-rw-r--r--   1 bin  bin  1624036 Dec 11 22:10 /lib/libc.a
lrwxrwxrwx   1 root root  11 May 14  1999 /lib/libc.so ->
./libc.so.1
-rwxr-xr-x   1 bin  bin  1025416 Dec 11 22:10 /lib/libc.so.1
-rw-r--r--   1 bin  bin  1624036 Dec 11 22:10 /usr/lib/libc.a
lrwxrwxrwx   1 root root  11 May 14  1999 /usr/lib/libc.so ->
./libc.so.1
-rwxr-xr-x   1 bin  bin  1025416 Dec 11 22:10 /usr/lib/libc.so.1
Configure command: ./configure  --prefix=/users/r/randerso/jafar/mysql
--with-low-memory --with-extra-charsets=complex --enable-assembler
Perl: This is perl, version 5.005_03 built for sun4-solaris


-
Before p

MySQL with Delphi 5.0

[José Haroldo Filho]

I've installed MyODBC and then I've set up ODBC and I saw the driver for 
MySQL DB, when I try to create a new alias wiht MySQL it does not apear to 
select the DB, acording a book wich is guiding it should has to appear.

Can anybody help to set up the ALIAS with MySQL 

Thanks 

 

José Haroldo Filho
 Gerência de TI

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Further Question with --> table lock - which connection id own's it

[Luciano Barcaro]

*** REPLY SEPARATOR  ***

>Hi ...
>
>just wanted to added another question to this one...
>
>you suggested to use LAST_INSERT_ID() , but the
>question is if there are concurrent access to the
>database, how will you get the last id without locking
>the table.

Don't worry about concurrent access... the last_insert_id()
returns the last id inserted by your process (connection).

>
>Because what I've been doing is also:
>1. lock the table
>2. get the id
>3. release lock
>
>Could you further explain the LAST_INSERT_ID() a
>little more and how to complish it without using
>locks.
>
>thank you.
>
>Sukhdev.
>
>--- Michael Widenius <[EMAIL PROTECTED]> wrote:
>>
>> Hi!
>>
>> > "Lopez" == Lopez David > <[EMAIL PROTECTED]>> writes:
>>
>> Lopez> AntiSpam - mysql, sql, query
>> Lopez> Version: 3.23.49a, MyISAM, NT, Solaris
>>
>> Lopez> My app is 150 daemons writing logs to mysql.
>> The main
>> Lopez> table is of fixed size but depends on four
>> other tables
>> Lopez> for foreign keys (hash tables). These tables
>> are uploaded
>> Lopez> once to the daemon at start-up. Occasionally,
>> a new entry
>> Lopez> must be written into these hash tables. The
>> procedure is
>> Lopez> to lock the table, insert entry, get the key
>> (auto-increment
>> Lopez> field) and release the lock.
>>
>> A better solution is to use LAST_INSERT_ID() and not
>> use any locks at all.
>>
>> Lopez> But what if the connection dies during the
>> update process.
>> Lopez> If this happens, how can I tell which
>> connection id has the
>> Lopez> lock so I can kill it?
>>
>> If a connection dies, the server will automaticly
>> delete all temporary
>> tables and all table locks.
>>
>> Regards,
>> Monty
>>
>> --
>> For technical support contracts, goto
>> https://order.mysql.com/
>>__  ___ ___   __
>>   /  |/  /_ __/ __/ __ \/ /Mr. Michael Widenius
>> <[EMAIL PROTECTED]>
>>  / /|_/ / // /\ \/ /_/ / /__   MySQL AB, CTO
>> /_/  /_/\_, /___/\___\_\___/   Helsinki, Finland
>><___/   www.mysql.com
>>
>>
>-
>> Before posting, please check:
>>http://www.mysql.com/manual.php   (the manual)
>>http://lists.mysql.com/   (the list
>> archive)
>>
>> To request this thread, e-mail
>> <[EMAIL PROTECTED]>
>> To unsubscribe, e-mail
>>
><[EMAIL PROTECTED]>
>> Trouble unsubscribing? Try:
>> http://lists.mysql.com/php/unsubscribe.php
>>
>
>
>__
>Do You Yahoo!?
>Yahoo! Games - play chess, backgammon, pool and more
>http://games.yahoo.com/
>
>-
>Before posting, please check:
>   http://www.mysql.com/manual.php   (the manual)
>   http://lists.mysql.com/   (the list archive)
>
>To request this thread, e-mail <[EMAIL PROTECTED]>
>To unsubscribe, e-mail
><[EMAIL PROTECTED]>
>Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

fim do besteirol todo que Sukhdev Sethi escreveu.
---
\|/   __   \|/
`@"  / o .  \  "@'Microsoft? Por acaso é alguma
/___| \/ |___\marca de papel higiênico?
 \___U__/
  .^.  Luciano Barcaro - Linux User #99517
  /v\  Seja também um feliz usuário de linux
 // \\ Registre-se gratuitamente em
/( . )\http://counter.li.org
 ^`~'^ ICQ #
---



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: MySQL start

[Victoria Reznichenko]

Samuel,
Tuesday, April 23, 2002, 4:04:20 PM, you wrote:

SM> Can you help me in the following problem?

SM> OS: Linux Slackware 8.0
SM> Source: mysql-3.23.42.tar.gz

SM> I can't start mysql after installing the source file. I did it step by step
SM> according guidance from Install-Source file.

SM> My OS is generating such messages:


SM> root@serwer:/TEMP# mysql
SM> ERROR 2002: Can't connect to local MySQL server through
SM> socket '/tmp/mysql.sock' (111)

Your MySQL server is not running ...

SM> file serwer.err:
SM> 020422 19:16:29  mysqld started
SM> 020422 19:16:32  /usr/libexec/mysqld: Table 'mysql.host' doesn't exist
SM> 020422 19:16:32  /usr/libexec/mysqld: Normal shutdown

SM> 020422 19:16:32  mysqld ended

Try to find file 'host.frm' in data dir. If file does exist, check
your permissions on mysql data dir - it should belong to user and group 
mysql server is running from. If file doesn't exist, you should run
mysql_install_db to re-create grant tables, look at:
 http://www.mysql.com/doc/m/y/mysql_install_db.html

SM> Any ideas?




-- 
For technical support contracts, goto https://order.mysql.com/
This email is sponsored by Ensita.net http://www.ensita.net/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Victoria Reznichenko
 / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.net
   <___/   www.mysql.com




-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: ERROR 1045: Access denied for user: 'root@localhost'

[Victoria Reznichenko]

Tewfic,
Monday, April 22, 2002, 10:07:06 PM, you wrote:

>> Hello, i'm having a problem accessing mysql database.  I don't recall
>> setting a password for root, but when i try to set that password.  This is
>> happening right after i run  mysql_install_db
>> 
>> [root@omsrh etc]# mysql -u root -p
>> Enter password:**
>> ERROR 1045: Access denied for user: 'root@localhost' (Using password: YES)

If you didn't set password, you don't have to use '-p' option for
connection. 

If you want to set password, please, chaeck the following link:
   http://www.mysql.com/doc/P/a/Passwords.html

>> [root@omsrh etc]# mysql
>> ERROR 1045: Access denied for user: 'root@localhost' (Using password: NO)

   It means that anonymous user doesn't have any privileges ...
   Unix 'root' user and 'root' user in MySQL are different ...

>> I was able access Mysql not being root, but couldn't get access to 'mysql'
>> database to change user options and all.  
>> 
>> When accessing mysql as a user, I am unable to create databases.
>> 
>> 
>> When using skip-grant-table i get ...
>> 
>> [root@omsrh etc]# mysql -u root
>> mysql: unrecognized option `--skip-grant-table'

Use "--skip-grant-tables" option, not "--skip-grant-table" ...

>> Your help will be greatly appreciated.




-- 
For technical support contracts, goto https://order.mysql.com/
This email is sponsored by Ensita.net http://www.ensita.net/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Victoria Reznichenko
 / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.net
   <___/   www.mysql.com




-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Mysql.sock missing

[Egor Egorov]

Charitha,

Tuesday, April 23, 2002, 11:58:37 AM, you wrote:

C> REALFROM: Charitha <[EMAIL PROTECTED]> 
C> HOUR: 2002042312


C> Hello all,

C> I am facing very strange problem

C> I am not having mysql.sock in /var/lib/mysql
C> But it is showing its status to be running.
C> How could it be?

Check path to the socket file ...

You may issue the following command in mysql client: 

  show variables like "socket";

C> Clearance needed.





-- 
For technical support contracts, goto https://order.mysql.com/
This email is sponsored by Ensita.net http://www.ensita.net/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Egor Egorov
 / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.net
   <___/   www.mysql.com



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: New Setup

[Egor Egorov]

Ian,
Tuesday, April 23, 2002, 12:41:40 AM, you wrote:

Egor>> By default user 'root' has all privileges...
Egor>> Show me the output of following:
Egor>>  SHOW GRANTS FOR 'root'@'localhost';


IP> mysql> show grants for 'root'@'localhost'
IP> -> ;
IP> +---
IP> --+
IP> | Grants for root@localhost
IP> |
IP> +---
IP> --+
IP> | GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' IDENTIFIED BY PASSWORD
IP> 'password_obscured' |
IP> +---
IP> --+
IP> 1 row in set (0.00 sec)

:)
Your 'root' user doesn't have GRANT privilege ...

You should change Grant_priv to 'Y'
You can do this using UPDATE statement:
 UPDATE user SET Grant_priv='Y' WHERE user='root';
 
or you run mysqld with "--skip-grant-tables" option and set Grant_priv
using GRANT statement:
  GRANT ALL ON *.* to 'root'@'localhost' identified by
  'password_obscured' WITH GRANT OPTION;

IP> Ian





-- 
For technical support contracts, goto https://order.mysql.com/
This email is sponsored by Ensita.net http://www.ensita.net/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Egor Egorov
 / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.net
   <___/   www.mysql.com



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

SUMMARY: Inserting a BLOB using MySQL++

[Thi Cao]

All,

First of all, thanks to everyone(Sinisa, Opus) who gave input into the
resolution of my problem.  What I ended up doing was escaping any character
that would be interpreted as a special character in an STL string.  These
included ", \0, and '.  So, basically I armored the binary data and inserted
the object as a string into the BLOB field of my particular table.  This may
or may not be the best solution to the problem, but it is one that met my
needs.  And so, there you have it, one solution to inserting binary data
into a blob field using MySQL++.

Regards,

Thi

-Original Message-
From: Opus [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 22, 2002 3:14 PM
To: Thi Cao; MySQL
Subject: Re: Inserting a BLOB using MySQL++


Probably the best bet would be to write the individual attributes to
respective 
database columns.  It keeps a few things simpler.  It would also allow you
to 
update the database from multible sources (many threads, or many users on
the 
database).

Other wise, you would have to serialize the object to a binary object and
write 
that to the BLOB field.  When you imported it back, you would have to 
deserialize.  Some languages call this pickeling.  As I have not touched C++

code for a while, I'm not sure what classes are availible to do this for
you.

The BLOB way of doing it would force you read/write the entire thing
everytime 
you update the object, unless you are just using the database to store it
for 
backup.

-Opus

On 22 Apr 2002 at 8:21, Thi Cao wrote:

> All,
> 
> I created a C++ class containing a variety of member variables of varying
> types such as float, int, char *, etc.  If I instantiate an object of this
> class, how should I insert this object into my database table?  I can
> retrieve the individual members and insert them that way, but I feel it
> would be more efficient to insert the object as a BLOB, but I don't
exactly
> know how to do that.  Basically, I want to insert the object as is so that
I
> can retrieve it as is and not have to bother with calling the member
setting
> functions to populate the class members.  I looked at the MySQL++ example
> for loading a binary file, but am unsure how to apply that to my needs.  I
> also looked through the mail archives and was unsuccessful in finding a
> solution, so any assistance would be much appreciated.  Thanks in advance.
> 
> Regards,
> 
> Thi
> 


--Opus--

Government is not reason, it is not eloquence- it is force.
- George Washington


Get added to my Humor list:
mailto:[EMAIL PROTECTED]?subject=ADD_HUMOR
Get added to my Neat list:
mailto:[EMAIL PROTECTED]?subject=ADD_NEAT
Get my PGP public key:
mailto:[EMAIL PROTECTED]?subject=PSEND&body=send%20PublicKEY.asc
Visit My Home Page:
http://value.net/~opus/



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

MySQL start

[Samuel Mendelowski]

Can you help me in the following problem?

OS: Linux Slackware 8.0
Source: mysql-3.23.42.tar.gz

I can't start mysql after installing the source file. I did it step by step
according guidance from Install-Source file.

My OS is generating such messages:


root@serwer:/TEMP# mysql
ERROR 2002: Can't connect to local MySQL server through
socket '/tmp/mysql.sock' (111)


file serwer.err:
020422 19:16:29  mysqld started
020422 19:16:32  /usr/libexec/mysqld: Table 'mysql.host' doesn't exist
020422 19:16:32  /usr/libexec/mysqld: Normal shutdown

020422 19:16:32  mysqld ended

Any ideas?



-- 
registered linux user #123707



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: sub selects

[Bill Easton]

Try the following:

SELECT leads.* FROM leads
LEFT JOIN blacklist ON leads.refnumberid = blacklist.leadid
  WHERE blacklist.leadid IS NULL
AND ...

The LEFT JOIN will give you a row for every row in leads; blacklist columns
will be null if there's no matching blacklist, so the WHERE clause will
filter these out.

Check out LEFT [OUTER] JOIN in the manual...


> From: <[EMAIL PROTECTED]>
> To: "Mysql. Com" <[EMAIL PROTECTED]>
> Subject: sub selects
> Date: Mon, 22 Apr 2002 15:34:22 +0100
>
> I know that mysql does not support sub selects but I want to be able to do
> the following:
>
> I have a table with all my leads in called leads. The table has a unique
ref
> for each lead called refnumberid
> I have a table with leads in and products that leads have asked not to be
> mailed on the table has a field called leadid which stores the value of
> refnumberid above.
>
> I want to select records from the table leads provided they do not have a
> record in the table blacklist. I have used the following select statement
> which produces no results. The intro screen collects the value of adate
and
> acountry
>
> sql2=" SELECT leads.* from leads,blacklist   WHERE  leads.date1stcontact
<=
> '"&adate&"'   and leads.country = '"&acountry&"' and leads.refnumberid <>
> blacklist.leadid and leads.productname <> blacklist.productOR
> leads.date1stcontact <= '"&adate&"'  and leads.refnumberid <>
> blacklist.leadid and leads.productname <> blacklist.product   and
> '"&acountry&"' = 'ALL'"
>set rs22=Server.CreateObject("ADODB.Recordset")
>rs22.open sql2,db,0,1
>
>
> Can anyone help?
>
> Regards
>
> Michael Johnson
> Managing Director
> Humphrey Consulting Limited BPEnet
> 13 Austin Friars
> London
> EC2N 2JX
> Tel +44(0)1323 438975
> Fax +44(0)1323 738355
> Email [EMAIL PROTECTED]
> URL www.bpenet.net



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Mysql 4.0.x enough stable to be in production ?

[Anthony W. Marino]

What table types are you using?

Anthony

> I've been running 4.0.1-alpha on a development server for our new internet
> bookstore. Holds around 1.3million books, 100k bookcovers and a lot of
> other information.
>
> I haven't experienced any crash/problems except for one bug that brings
> down MySQL: using two 'match-against' in fulltext search with some words
> will shutdown mysql.
> Not sure if it's already fixed or not, but if I get some free time later
> this week I'll try to make a test case for the mysql-team.
>
> But anyway, not counting that bug I haven't experienced any problems. But
> alpha is alpha... :p
>
> Since the logistics etc. are stored on a different server I wouldn't have
> any problems using this server as our main web-server (which is what I'm
> going to do in 3 weeks). Restoring the whole server from total crash is
> relativly easy, so a mysql bug wouldn't hurt much anyway
>
>
> Regards
> Erlend Stromsvik
>
> - Original Message -
> From: "David BORDAS" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Tuesday, April 23, 2002 9:09 AM
> Subject: Mysql 4.0.x enough stable to be in production ?
>
> > Hi all,
> >
> > just one question, i need to use an index on a specific query.
> > This feature in fact :
> > http://www.mysql.com/doc/N/e/News-4.0.0.html
> > << ORDER BY ... DESC can now use keys.  >>
> >
> > And this one is only available in mysql 4.0.x.
> >
> > I'll give a try to mysql 4.0 in a test server.
> >
> > But i need some feed back, did someone using mysql 4.0.x in production ?
> >
> > I know it's an alpha release :(
> >
> > Thanks
> > David
> >
> >
> > -
> > Before posting, please check:
> >http://www.mysql.com/manual.php   (the manual)
> >http://lists.mysql.com/   (the list archive)
> >
> > To request this thread, e-mail <[EMAIL PROTECTED]>
> > To unsubscribe, e-mail <[EMAIL PROTECTED]>
> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
> -
> Before posting, please check:
>http://www.mysql.com/manual.php   (the manual)
>http://lists.mysql.com/   (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
> <[EMAIL PROTECTED]> Trouble
> unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

-- 
Anthony W. Marino
Pres./CTO, AWM Objects
email:  [EMAIL PROTECTED]
phone:  (732) 610-2441


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Pre-release of MySQL 3.23.50

[Ireneusz Piasecki]

Hi. I'm running on linux box 6.2 with glibc 2.1 and i compiled from src.rpm
mysql.
The compiler is gcc  2.95.2.
So, the new version of mysql 3.23.50 can i complie with it (2.95.2) or i
must upgrade to gcc 3.0.4 ???


Regards, irek.

- Original Message -
From: "Michael Widenius" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Tuesday, April 23, 2002 9:26 AM
Subject: Pre-release of MySQL 3.23.50


>
> Hi!
>
> 3.23.50 is basicly just a bug fix release compare do 3.23.49a
>
> There is however two things one should be aware of regarding 3.23.50
> (both only affecting our Linux x86 binaries (normal and RPM's):
>
> - We have switched to a new updated glib library, because we found a
>   critical memory corruption bug (introduced by us) in the old glibc
>   library that we used to compile 3.23.49.
>   (older MySQL binaries are not affected by this problem)
> - We have changed compiler to gcc 3.0.4 (because the old gcc compiler
>   we used couldn't compile with an alternative glibc library).
>
>
> As 3.23 is a stable release version, we don't want to release 3.23.50
> to the general public right away, as we want to be sure that the new
> gcc version works in practice as good as it has worked on our
> internal machines.
>
> You can now find 3.23.50 at the following link:
>
> http://www.mysql.com/downloads/mysql-3.23-pre.html
>
> If we don't get any fatal bug reports by the end of the week for this
> version, we will then move it to our standard download page.
>
> If you find anything wrong/strange with this release compared to
> older 3.23 releases, please send a full bug report to
> [EMAIL PROTECTED] and we will fix it ASAP!
>
> Changes in release 3.23.50
> --
>
>* Fixed problem with `crash-me' and gcc 3.0.4.
>
>* Fixed that `@@unknown_variable' doesn't hang server.
>
>* Added `@@VERSION' as a synonym for `VERSION()'.
>
>* `SHOW VARIABLES LIKE 'xxx'' is now case insensitive.
>
>* Fixed timeout for `GET_LOCK()' on HPUX with DCE threads.
>
>* Fixed memory allocation bug in the glibc library used to build
>  Linux binaries, which caused mysqld to die in 'free()'.
>
>* Fixed `SIGINT' and `SIGQUIT' problems in `mysql'.
>
>* Fixed bug in character table converts when used with big ( > 64K)
>  strings.
>
>* `InnoDB' now retains foreign key constraints through `ALTER TABLE'
>  and `CREATE/DROP INDEX'.
>
>* `InnoDB' now allows foreign key constraints to be added through the
>  `ALTER TABLE' syntax.
>
>* `InnoDB' tables can now be set to automatically grow in size
>  (autoextend).
>* Fixed some buffer overflow problems when reading startup
>  parameters.
>
>* Because of problems on shutdown we have now disabled named pipes on
>  windows by default.  One can enable named pipes by starting mysqld
>  with `--enable-named-pipe'.
>
>* Fixed bug when using `WHERE key_column = 'J' or key_column='j''.
>
>* Fixed core-dump bug when using `--log-bin' with `LOAD DATA INFILE'
>  without an active database.
>
>* Fixed bug in `RENAME TABLE' when used with
>  `lower_case_table_names=1' (default on Windows).
>
>* Fixed unlikely core-dump bug when using `DROP TABLE' on a table
>  that was in use by a thread that also used queries on only
>  temporary tables.
>
>* Fixed problem with `SHOW CREATE TABLE' and `PRIMARY KEY' when using
>  32 indexes.
>
>* Fixed that one can use `SET PASSWORD' for the anonymous user.
>
>* Fixed core-dump bug when reading client groups from option files
>  using `mysql_options()'.
>
>* Memory leak (16 bytes per every *corrupted* table) closed.
>
>* Fixed binary builds to use `--enable-local-infile'.
>
>* Update source to work with new `bison' version.
>
>* Updated shell scripts to new agree with new POSIX standard.
>
>* Fixed bug where `DATE_FORMAT()' returned empty string when used
>  with `GROUP BY'.
>
>
> Regards,
> Monty
> CTO of MySQL AB
>
> -
> Before posting, please check:
>http://www.mysql.com/manual.php   (the manual)
>http://lists.mysql.com/   (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
<[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>



-- 
Encyklopedia multimedialna w prezencie!
http://www.e-mail.onet.pl



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Pre-release of MySQL 3.23.50

[Philip Molter]

On Tue, Apr 23, 2002 at 10:26:04AM +0300, Michael Widenius wrote:
: 
: Hi!
: 
: 3.23.50 is basicly just a bug fix release compare do 3.23.49a
: 
: There is however two things one should be aware of regarding 3.23.50
: (both only affecting our Linux x86 binaries (normal and RPM's):
: 
: - We have switched to a new updated glib library, because we found a
:   critical memory corruption bug (introduced by us) in the old glibc
:   library that we used to compile 3.23.49.
:   (older MySQL binaries are not affected by this problem)
: - We have changed compiler to gcc 3.0.4 (because the old gcc compiler
:   we used couldn't compile with an alternative glibc library).

Does this affect people who compile MySQL on their own on Linux?
If I have my RH7.2 box and I compile my own version of MySQL, am
I going to hit these memory corruption issues?

sql, query, mysql

* Philip Molter
* Texas.net Internet
* http://www.texas.net/
* [EMAIL PROTECTED]

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Mysql.sock missing

[Hisseine Dj.]

Don't worry if it's running then you can find that file else where on your
system; try to look for in /tmp

Hisseine

- Original Message -
From: "Charitha" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, April 23, 2002 4:58 AM
Subject: Mysql.sock missing


>
> Hello all,
>
> I am facing very strange problem
>
> I am not having mysql.sock in /var/lib/mysql
> But it is showing its status to be running.
> How could it be?
>
> Clearance needed.
>
> --
> Regards,
> Charitha.
>
>
> -
> Before posting, please check:
>http://www.mysql.com/manual.php   (the manual)
>http://lists.mysql.com/   (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
<[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Cant connect using socket ''(111) for Mysqlgui on linux

[Hisseine Dj.]

Verify if your MySQL server is running and the user and password when
entering Mysqlgui1.7.5
I have the same on Linux and it's running fine.

Hisseine

- Original Message -
From: "Sinisa Milivojevic" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Tuesday, April 23, 2002 7:40 AM
Subject: Re: Cant connect using socket ''(111) for Mysqlgui on linux


> Krishna Kumar Sundara Moorthy writes:
> > Hello All
> >
> > Is there any installation instructions for Mysqlgui1.7.5 on linux.
> >
> > Also i have installed it and while trying to connect it says couldnt
connect
> > using Socket''(111)
> > and also can some one throw light on "sql command on connet or Socket"
> > dialog in options window
> > and what showuld really go in there
> >
> > thanks in advance
> > Krishna Kumar S.
> >
>
> Hi!
>
> There is README that comes with mysqlgui that contains all info.
>
> Click on Options, fill up all entrries.
>
> On Linux, in that field 'SQL command on ..." enter a location of the
> socket file. If it is defined in any *my.cnf it should pop up there
> for itself.
>
> Then click on 'Save' and re-connect.
>
> --
> Regards,
>__  ___ ___   __
>   /  |/  /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]>
>  / /|_/ / // /\ \/ /_/ / /__   MySQL AB, Fulltime Developer
> /_/  /_/\_, /___/\___\_\___/   Larnaca, Cyprus
><___/   www.mysql.com
>
>
> -
> Before posting, please check:
>http://www.mysql.com/manual.php   (the manual)
>http://lists.mysql.com/   (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
<[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

database design approval

[Daniel Jarrett]

i understand that this is a bit of an ask.

but.
I was wondering if someone could look over my database design.
i've got a diagram. and text document of all my create table syntax.

It's my first mysql database, and it's kind of important that i get the
thing right.
So if anyone could help me out. i'd be very very grateful.

thanks
dan


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

read only tables

[Manuel]

Dear all,

When I try to update or create a record to a table,
there is an error saying the table is read-only.

How can I change it to read-write?

I have chmod 777 to all the tables in the mysql data directory.
I have also restarted the mysql engine.

This happened only after I copy the tables from another linux box.

Please help.


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Further Question with --> table lock - which connection id own's it

[Sukhdev Sethi]

Hi ...

just wanted to added another question to this one...

you suggested to use LAST_INSERT_ID() , but the
question is if there are concurrent access to the
database, how will you get the last id without locking
the table.

Because what I've been doing is also:
1. lock the table
2. get the id
3. release lock

Could you further explain the LAST_INSERT_ID() a
little more and how to complish it without using
locks.

thank you.

Sukhdev.

--- Michael Widenius <[EMAIL PROTECTED]> wrote:
> 
> Hi!
> 
> > "Lopez" == Lopez David  <[EMAIL PROTECTED]>> writes:
> 
> Lopez> AntiSpam - mysql, sql, query
> Lopez> Version: 3.23.49a, MyISAM, NT, Solaris
> 
> Lopez> My app is 150 daemons writing logs to mysql.
> The main 
> Lopez> table is of fixed size but depends on four
> other tables
> Lopez> for foreign keys (hash tables). These tables
> are uploaded
> Lopez> once to the daemon at start-up. Occasionally,
> a new entry 
> Lopez> must be written into these hash tables. The
> procedure is
> Lopez> to lock the table, insert entry, get the key
> (auto-increment
> Lopez> field) and release the lock.
> 
> A better solution is to use LAST_INSERT_ID() and not
> use any locks at all.
> 
> Lopez> But what if the connection dies during the
> update process.
> Lopez> If this happens, how can I tell which
> connection id has the 
> Lopez> lock so I can kill it? 
> 
> If a connection dies, the server will automaticly
> delete all temporary
> tables and all table locks.
> 
> Regards,
> Monty
> 
> -- 
> For technical support contracts, goto
> https://order.mysql.com/
>__  ___ ___   __
>   /  |/  /_ __/ __/ __ \/ /Mr. Michael Widenius
> <[EMAIL PROTECTED]>
>  / /|_/ / // /\ \/ /_/ / /__   MySQL AB, CTO
> /_/  /_/\_, /___/\___\_\___/   Helsinki, Finland
><___/   www.mysql.com
> 
>
-
> Before posting, please check:
>http://www.mysql.com/manual.php   (the manual)
>http://lists.mysql.com/   (the list
> archive)
> 
> To request this thread, e-mail
> <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
>
<[EMAIL PROTECTED]>
> Trouble unsubscribing? Try:
> http://lists.mysql.com/php/unsubscribe.php
> 


__
Do You Yahoo!?
Yahoo! Games - play chess, backgammon, pool and more
http://games.yahoo.com/

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Cant connect using socket ''(111) for Mysqlgui on linux

[Sinisa Milivojevic]

Krishna Kumar Sundara Moorthy writes:
> Hello All
> 
> Is there any installation instructions for Mysqlgui1.7.5 on linux.
> 
> Also i have installed it and while trying to connect it says couldnt connect
> using Socket''(111)
> and also can some one throw light on "sql command on connet or Socket"
> dialog in options window
> and what showuld really go in there
> 
> thanks in advance
> Krishna Kumar S.
> 

Hi!

There is README that comes with mysqlgui that contains all info.

Click on Options, fill up all entrries.

On Linux, in that field 'SQL command on ..." enter a location of the
socket file. If it is defined in any *my.cnf it should pop up there
for itself.

Then click on 'Save' and re-connect.

-- 
Regards,
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]>
 / /|_/ / // /\ \/ /_/ / /__   MySQL AB, Fulltime Developer
/_/  /_/\_, /___/\___\_\___/   Larnaca, Cyprus
   <___/   www.mysql.com


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Question about mysql++ and g++

[Sinisa Milivojevic]

Mike Holmquist writes:
> Ok, i downloaded the  mysql++-1.7.8-1.i386.rpm 
>  rpm 
> file from RpmFind.net. I have mysql installed already on my machine, o 
> ya and im running linux. I have gcc installed, version 2.96, i think 
> everything installed correctly when i ran the rpm. But i am not sure. I 
> made a simple program, here it is:
> 
> #include 
> 
> int main() {
> 
> 
>   return 0;
> }
> 
> When i tried to compile it using "g++ mysql.cpp" i got a bunch of errors 
> saying "mysql.h not found" (errors are printed on bottom of email). So i 
> tried doing a "locate mysql.h" and it only found the mysql.h file from 
> my windows partition (i have mysql++ installed on windows...).
> 
> I am not sure if its my compiler, or the version of mysql++ i installed.
> 
> Another question i have is it says to reset my database using reset-db, 
> where would i do that? The mysql command line?
> 
> If anyone can help me, give me some ideas if my install went wrong, or 
> if i need to update gcc, or get a different compiler (i dont know any 
> for linux yet! ) id appreciate it very much!
> 
> ~Mike
> 
> 

HI!

The errors are caused by MySQL++ not seeing MySQL++ include directory.

In your Makefile add -I.. directive for include directory and
-L.. directive for lib directory.

-- 
Regards,
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]>
 / /|_/ / // /\ \/ /_/ / /__   MySQL AB, Fulltime Developer
/_/  /_/\_, /___/\___\_\___/   Larnaca, Cyprus
   <___/   www.mysql.com


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Help needen on query

[domi]

Hi all !!

This is just great ! Sometimes things seem to be
more complicated than they actually are.
I needed (and still do) a similar solution to check
if an IP adress exist in a table. And sometimes the
argument in the query is a whole subnet like 192.168.0.%

I guess this will do the job for me :-)
Thanx !!!

=d0Mi=

| Hi,
| 
| > Now  I need a query which will take the values from column
| > 'query',  treat  them  as patterns for matching and return
| > row(s)  which  match  the given string 'blahblah'. In this
| > example,  the  matched  data  is  obviously in second row.
| > (bla% matches blahblah)
| 
| > Do I make any sense? Is this possible?
| > Any help will be greatly appreciated.
| 
| To  be  honest I didn't belive it would work, but... here it
| is :)
| 
| mysql> select * from blah;
| +--+--+---+
| | uid  | username | query |
| +--+--+---+
| |1 | someuser | %qu1% |
| |2 | anotheru | bla%  |
| +--+--+---+
| 2 rows in set (0.00 sec)
| 
| mysql> select * from blah where 'blahblah' like query;
| +--+--+---+
| | uid  | username | query |
| +--+--+---+
| |2 | anotheru | bla%  |
| +--+--+---+
| 1 row in set (0.00 sec)
|
| Regards,
| Sasa
| 
| »mysql, select, database«


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

RE: super-smack on FreeBSD

[Simon Green]

> Hi List
> I know super-smack was writing for Linux but I am trying to get it to work
> on FreeBSD.
> Has any one done this or is there a another many threaded bench mark
> software out there  for MySQL ?
> 
> Thanks
> Simon

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php