Re: Processing the join

[Toni Strandell]

I am interested in the internal join algorithms, not the join types that 
can be found in the manual. My question is how the join types in the 
manual are processed internally? Or, what are the different join 
algorithms supported by MySQL?



> It depends on your database & query structure and especially what
> indexes are available. If you just put "explain" in front of your query
> you will be able to see how mysql will execute your query.
>
> On Tuesday, September 10, 2002, at 09:45 AM, Toni Strandell wrote:
>
>
>> How does MySQL process a join between tables? Does it always use
>> nested-loop join, or does it use sort-merge join if the table is sorted
>> before joining it? Is the join algorithm merge if the tables are 
>already
>> sorted on the join attributes (through an index)?


-- 
 
 Toni Strandell
 [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

error while make of 3.23.52

[Chugh Shalini]

Hi All!
mysql, sql, query

> I am trying to install mysql-3.23.52 . I configured with following command
> and then had run make. Make gives the following errors. Please help
> 
> ./configure --with-low-memory --with-innodb
> --with-mysqld-ldflags=-rdynamic
> 
> 
> errors during make
> 
> sql_lex.cc: In function `void lex_init()':
> sql_lex.cc:85: `symbols' undeclared (first use this function)
> sql_lex.cc:85: (Each undeclared identifier is reported only once for each
>function it appears in.)
> sql_lex.cc:87: `sql_functions' undeclared (first use this function)
> sql_lex.cc: In function `int find_keyword(LEX*, unsigned int, bool)':
> sql_lex.cc:168: `get_hash_symbol' undeclared (first use this function)
> *** Error code 1
> make: Fatal error: Command failed for target `sql_lex.o'
> Current working directory /usr/local/mysql-3.23.52/sql
> *** Error code 1
> make: Fatal error: Command failed for target `all-recursive'
> 
> 
Regards

-
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 with innodb support

[Peter Goggin]

I am setting up a web site with Linux (redhat 7.1), apache, php and mysql.

I need the version of mysql with innodb support.
Can anyone indicate to me what file or files I need to obtain to install
thecorrect version of mysql and where I can down load them?

Thanks in advance
Regards

Peter Goggin


-
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 i must use mysql_free_result()?

[Dizzy Myope]

hi all:) 

  int main(void)
  {
 .
 rs=mysql_store_result(&connection);//get result to rs
 ..
 mysql_free_result(rs);// it is necessary ???
 rs=mysql_store_result(&connection);// get result to rs again.
 
  }
 
   i write some codes with c++&mysql like above, and i want to know 
   between the same "mysql_res" used twice ,
   it is necessary to use mysql_free_result() or not. 
   3KS.
   asap. 
   
Dizzy Myope
[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

MySQL and Kylix 2 problem

[Ed Valentine]

I am using Kylix 2 Pro on Caldera 3.1.1 with MySQL 3.23.33-9 and getting
SIGSEGV faults.

I looked on Borland site 6 months ago and found reference that version
3.32 will not work and they tested on 3.22 which works well.

I have looked on MySQL today and find that the latest is 3.23.5x., leads
me to believe that the Borland reference is a type error and they meant
to say 3.23 not 3.32.

Seams I have the choice of downgrading to MySQL 3.22 or upgrading to
Kylix 3 hoping that the MySQL problem is fixed and our code will work
with version 3.

I am looking for any suggestions and/or comments.

Thanks in advance.

Ed Valentine

-- 
Ed Valentine
President,
ProSoft Plus, Inc.
3 Cherry Park
San Antonio, TX  78249
[EMAIL PROTECTED]
210-694-0801




-
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: Problems with alias names in WHERE clause

[Zak Greant]

-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

On September 10, 2002 22:32, Paul DuBois wrote:
 ...
> You can't refer to aliases in WHERE clauses.  Aliases refer to columns
> that have been selected, WHERE clauses determine which columns should
> be selected.  In essence, WHERE refers to "input" columns, which occurs
> earlier than the aliases (which refer to "output" columns).

  Hi Nicholas,

  You may be able to get the effect that you desire using user variables.
  (see http://www.mysql.com/doc/en/Variables.html for details)

  The following query using user variables *might* work for you :)

SELECT
i.id image_id,
@photo_id  := ifnull(i.photographer,"6")photo_id,
@owner_id := ifnull(i.owner,"6")owner_id,
concat(cp1.fname,' ',cp1.lname) photo_id,
concat(cp2.fname,' ',cp2.lname) owner_name,
FROM
image i,
common.persons cp1,
common.persons cp2
WHERE
i.id='8200' 
AND @photo_id=cp1.id 
AND @owner_id=cp2.id;

  Cheers!
- -- 
Zak Greant <[EMAIL PROTECTED]>
MySQL Community Advocate

Feed the Dolphin! Order MySQL support from the MySQL developers at
https://order.mysql.com/?ref=mzgr

"Gosh, Batman! The nobility of the almost-human porpoise." --Robin
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.0.7 (GNU/Linux)

iD8DBQE9ftPQb6QONwsK8bIRAiFKAJ9xRnNM+Nn0JiFj8AV0GEch0YKVDQCdE8uv
kRA6OKVYj8AU9WrPnq/BuI8=
=HI5o
-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

mysql install Q... error connecting /tmp/mysql.sock

[anand v]

Hi,

I have redhat linux 7.1 and I have downloaded mysql-3.23.52
and followed all the instructions as to how to install and how
to bring up the database the scripts/mysql_install_db worked
fine and then I did ./bin/safe_mysqld and that worked fine too
but when I tried to execute the mysql program I got the following error

[root@abacusweb mysql]# bin/safe_mysqld &
[1] 25307
[root@abacusweb mysql]# Starting mysqld daemon with databases from 
/var/lib/mysq
l

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

=

I don't know how to run and capture the output from mysqlbug program
and if some one tells me how to redirect the output from mysqlbug program
I appreciate that

Please help me in finding out the problem...

Thanks


_
Send and receive Hotmail on your mobile device: http://mobile.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

mysql

[laura papas]

Mysql

Please remove me from your list
- Original Message -
From: <[EMAIL PROTECTED]>
To: "laura papas" <[EMAIL PROTECTED]>
Sent: Tuesday, September 10, 2002 6:07 PM
Subject: Re: email


> Your message cannot be posted because it appears to be either spam or
> simply off topic to our filter. To bypass the filter you must include
> one of the following words in your message:
>
> sql,query
>
> If you just reply to this message, and include the entire text of it in
the
> reply, your reply will go through. However, you should
> first review the text of the message to make sure it has something to do
> with MySQL. Just typing the word MySQL once will be sufficient, for
example.
>
> You have written the following:
>
> please remove me from your list
>
>


-
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: Problems with alias names in WHERE clause

[Paul DuBois]

At 20:57 -0700 9/10/02, Nicholas Berry wrote:
>I search high and low for an explanation of this at
>http://www.mysql.com/doc (hoping I didn't overlook anything) thought it
>might be easier to ask this list to see if I'm the only one with this
>problem.
>
>With the query statement -
>   SELECT i.id image_id, ifnull(i.photographer,"6") photo_id,
>ifnull(i.owner,"6") owner_id,
>   concat(cp1.fname,' ',cp1.lname) photo_name,
>   concat(cp2.fname,' ',cp2.lname) owner_name,
>   FROM image I, common.persons cp1, common.persons cp2
>   WHERE id='8200' AND photo_id=cp1.id AND owner_id=cp2.id
>
>- an error is reported "ERROR 1054: Unknown column 'photo_id' in 'where
>claus'".  This query is failing at the reference to the column alias in
>the WHERE claus.  Is this right? Should it be acting this way?  If I
>replace photo_id in the WHERE claus with 'ifnull(i.photographer,"6")'
>then the correct result is produced.
>
>Can someone please help me understand what I'm missing and possibly why
>this approach does not work.

You can't refer to aliases in WHERE clauses.  Aliases refer to columns
that have been selected, WHERE clauses determine which columns should
be selected.  In essence, WHERE refers to "input" columns, which occurs
earlier than the aliases (which refer to "output" columns).

>
>Thanks,
>
>Nicholas Berry
>Systems Engineer
>RagingWire Telecommunications, Inc.
>916.286.4048 ph
>916.921.4148 fax
>[EMAIL PROTECTED]
>www.ragingwire.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

MySQL and Kylix 2 problem

[Ed Valentine]

I am using Kylix 2 Pro on Caldera 3.1.1 with MySQL 3.23.33-9 and getting 
SIGSEGV faults.

I looked on Borland site 6 months ago and found reference that version 
3.32 will not work and they tested on 3.22 which works well.

I have looked on MySQL today and find that the latest is 3.23.5x., leads 
me to believe that the Borland reference is a type error and they meant 
to say 3.23 not 3.32.

Seams I have the choice of downgrading to MySQL 3.22 or upgrading to 
Kylix 3 hoping that the MySQL problem is fixed and our code will work 
with version 3.

I am looking for any suggestions and/or comments.

Thanks in advance.

Ed Valentine

-- 
Ed Valentine
President,
ProSoft Plus, Inc.
3 Cherry Park
San Antonio, TX  78249
[EMAIL PROTECTED]
210-694-0801



-
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

Problems with alias names in WHERE clause

[Nicholas Berry]

I search high and low for an explanation of this at
http://www.mysql.com/doc (hoping I didn't overlook anything) thought it
might be easier to ask this list to see if I'm the only one with this
problem.

With the query statement -
  SELECT i.id image_id, ifnull(i.photographer,"6") photo_id,
ifnull(i.owner,"6") owner_id,
concat(cp1.fname,' ',cp1.lname) photo_name,
concat(cp2.fname,' ',cp2.lname) owner_name,
FROM image I, common.persons cp1, common.persons cp2
WHERE id='8200' AND photo_id=cp1.id AND owner_id=cp2.id

- an error is reported "ERROR 1054: Unknown column 'photo_id' in 'where
claus'".  This query is failing at the reference to the column alias in
the WHERE claus.  Is this right? Should it be acting this way?  If I
replace photo_id in the WHERE claus with 'ifnull(i.photographer,"6")'
then the correct result is produced.

Can someone please help me understand what I'm missing and possibly why
this approach does not work.

Thanks,

Nicholas Berry 
Systems Engineer 
RagingWire Telecommunications, Inc. 
916.286.4048 ph
916.921.4148 fax
[EMAIL PROTECTED] 
www.ragingwire.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: Default Win install --> mySQL autostarts when booting?

[Paul DuBois]

At 10:43 +0800 9/11/02, Uriel Wittenberg wrote:
>Sorry for not specifying: I'm using WinXP HOME.
>
>I did the normal default install. It seems to start up the mySQL server
>automatically when I start up Windows. Hence my question:
>
>Is there a standard way to change that so the server only runs when
>explicitly invoked?

Start the Services Manager and see if it lists an entry for the "MySql"
service.  If so, tell the service to stop and close the window.
Then open a DOS window and issue this command:

C:\> mysqld --remove

That will remove the service.  Then it will run only when you invoke
it explicitly.


Alternatively, if the service is registered, you can change it to be
a "manual" service rather than an "automatic" service.  Then you use
the Services Manager to start it up as a service, but you have to do
so yourself. It won't start whenever Windows starts.

>
>- Original Message -
>From: "Gerald R. Jensen" <[EMAIL PROTECTED]>
>To: "Uriel Wittenberg" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>; "Paul
>DuBois" <[EMAIL PROTECTED]>
>Sent: Wednesday, September 11, 2002 7:47 AM
>Subject: Re: Default Win install --> mySQL autostarts when booting?
>
>
>Which version of WinXP (Pro or Home)?
>
>On WinXP Pro, you'd have to install MySQL as a service, in which case it can
>either started manually or automatically. WinXP Home is more like WinME
>(yuck!) or Win98, where you can start MySLQ from a batch file.
>
>- Original Message -
>From: "Uriel Wittenberg" <[EMAIL PROTECTED]>
>To: <[EMAIL PROTECTED]>; "Paul DuBois" <[EMAIL PROTECTED]>
>Sent: Tuesday, September 10, 2002 6:14 PM
>Subject: Default Win install --> mySQL autostarts when booting?
>
>
>Does a normal WinXP installation of WinXP result in the mySQL server being
>automatically started up whenever one boots up the system? If so this is not
>well documented and it's not an appropriate default, at least not for
>everyone. Is there a standard way to change that so the server only runs
>when explicitly invoked?
>
>- Original Message -
>From: "Paul DuBois" <[EMAIL PROTECTED]>
>To: "Uriel Wittenberg" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
>Sent: Tuesday, September 10, 2002 11:59 PM
>Subject: Re: Confused, discombobulated, weirded out, upset! --Windows
>standalone user
>
>
>>  >Then does a normal Windows installation set it up so the server
>autostarts
>>  >whenever you boot up? I did not manually start the server.
>>
>>  It might be installed as a service.
>
>
>- finishing up previous topic: ---
>
>>  I don't understand.  In your previous message, you said:
>>
>>  At 23:37 +0800 9/10/02, Uriel Wittenberg wrote:
>>  >
>>  >Also, per advice here, I tried putting local-infile=1 in the [mysqld] and
>>  >[mysql] sections of my.cnf(my.ini), but that does not change the
>behavior.
>>
>>  Which seems to contradict what you're saying now.
>
>Yes, sorry -- I corrected my error in a previous message in this thread.
>
>
>
>-
>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: Default Win install --> mySQL autostarts when booting?

[Uriel Wittenberg]

Sorry for not specifying: I'm using WinXP HOME.

I did the normal default install. It seems to start up the mySQL server
automatically when I start up Windows. Hence my question:

Is there a standard way to change that so the server only runs when
explicitly invoked?

- Original Message -
From: "Gerald R. Jensen" <[EMAIL PROTECTED]>
To: "Uriel Wittenberg" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>; "Paul
DuBois" <[EMAIL PROTECTED]>
Sent: Wednesday, September 11, 2002 7:47 AM
Subject: Re: Default Win install --> mySQL autostarts when booting?


Which version of WinXP (Pro or Home)?

On WinXP Pro, you'd have to install MySQL as a service, in which case it can
either started manually or automatically. WinXP Home is more like WinME
(yuck!) or Win98, where you can start MySLQ from a batch file.

- Original Message -
From: "Uriel Wittenberg" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>; "Paul DuBois" <[EMAIL PROTECTED]>
Sent: Tuesday, September 10, 2002 6:14 PM
Subject: Default Win install --> mySQL autostarts when booting?


Does a normal WinXP installation of WinXP result in the mySQL server being
automatically started up whenever one boots up the system? If so this is not
well documented and it's not an appropriate default, at least not for
everyone. Is there a standard way to change that so the server only runs
when explicitly invoked?

- Original Message -
From: "Paul DuBois" <[EMAIL PROTECTED]>
To: "Uriel Wittenberg" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Tuesday, September 10, 2002 11:59 PM
Subject: Re: Confused, discombobulated, weirded out, upset! --Windows
standalone user


> >Then does a normal Windows installation set it up so the server
autostarts
> >whenever you boot up? I did not manually start the server.
>
> It might be installed as a service.


- finishing up previous topic: ---

> I don't understand.  In your previous message, you said:
>
> At 23:37 +0800 9/10/02, Uriel Wittenberg wrote:
> >
> >Also, per advice here, I tried putting local-infile=1 in the [mysqld] and
> >[mysql] sections of my.cnf(my.ini), but that does not change the
behavior.
>
> Which seems to contradict what you're saying now.

Yes, sorry -- I corrected my error in a previous message in this thread.



-
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: MySQL Question

[Nicholas Stuart]

The optimization is understandable but I'm not sure how much it would
affect it if you did the select outside the insert statment vs inside.
Either way you are selecting the same thing but I dont know which way is
better.
Well just playing around with it for a bit I think I found something.
The value from memory is a variable of some sort right? I dont know what
language you are using so I'm not sure what it will hold.
Anyways you could do something like the following:
INSERT INTO table1(col1, col2) SELECT table2.col1a, "variablehere" FROM
table2 WHERE [blah];

This will work becuase if you do a SELECT 5 you get 5 back. So if you do
it with SELECT variable(aka some literial) you will get the
variable(literial) back and you will have two cols to match your
table1(col1, col2).
HTH
-Nick

> Sorry...yes...both columns have a NOT NULL constraint which makes
> inserting a blank a problem. My only other option is to do the SELECT
> first, then push the result into the INSERT with the other memory only
> variable. I'm doing this for a system that will undergo high volumes,
> and want to do what I can to optimize the number of individual selects.
>
> I'm probably going to have to do the alternate technique regardless. =\
>
> On Tuesday, September 10, 2002, at 05:23  PM, Nicholas Stuart wrote:
>
>>> From my experince this is not possible.
>> Is there any reason why you can not simply do two inserts following
>> each
>> other?
>> INSERT INTO table1(column1) SELECT column1a FROM table2 WHERE
>> [something]
>> INSERT INTO table1(column2) VALUES(valueFromMemory)
>> (as if you didnt know that already)  =D
>> There should be no reason why you couldnt do this as there is nothing
>> that
>> ties the two columns together (that I can see here).
>> Maybe explain a bit more and we might be able to give you more info.
>>
>> -Nick
>>
>>> I have to do an insert and need to nest a select inside. I have tons
>>> of
>>> documentation on a very simple version of this, however my
>>> requirements
>>> are one step beyond that. Here is what I'd like to do in MySQL:
>>>
>>> insert into
>>>
>>> table1
>>>
>>> (column1, column2)
>>>
>>> values
>>> (select column1a from table2 where [something],
>>> valueFromMemory)
>>>
>>> If you'll notice, I want one column from a select and one column
>>> outside the select. Is this possible in MySQL? All the documentation
>>> I've read about MySQL says it can't be done.
>>>
>>> Thank you in advance!
>>>
>>> Mark
>>>
>>>
>>> -
>>> 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: Windows XP Installation Problems

[Miguel Angel Solórzano]

At 16:40 10/9/2002 -0700, Lukoni, Bryan AG:EX wrote:
Hi,
>Thanks Michel:
>
>Enabled the error reporting, but no luck. I'm stumped why I am not seeing
>any error messages when it fails to install. Do you know if the MYSQL
>installation makes any modifications to the registry or adds files to the
>system directory.

Nothing is copied to registry.

>  If not I could probably just copy the complete directory
>from the other computer onto a CD and recopy to the problem computer.

The above will works.

-- 
Regards,
__  ___ ___   __
   /  |/  /_ __/ __/ __ \/ /Miguel Angel Solórzano <[EMAIL PROTECTED]>
  / /|_/ / // /\ \/ /_/ / /__   MySQL AB, Fulltime Developer
/_/  /_/\_, /___/\___\_\___/   São Paulo - Brazil
<___/   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

MySQL Cookbook software distribution available

[Paul DuBois]

I've put up the "recipes" distribution that will accompany the upcoming
MySQL Cookbook (O'Reilly & Associates).  It's available at the book's
companion web site:

 http://www.kitebird.com/mysql-cookbook/

Note that this is more or less a "pre-release", because I still have
some cleaning up to do, READMEs to write, etc.  I'm making it available
in hopes that people will find things wrong with it that need fixing!

Also note that it contains more than 700 files, and many of them probably
won't make a lot of sense without the text of the book to look at.  Don't
say I didn't warn you. :-)

-
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 user's login

[aman mysql]

Hi
I added a new user in mysql using the following
mysql>insert into user
values('localhost','aman',PASSWORD('mysql024'),'Y','Y','Y','Y','Y','Y','N','
N','N','N','N','N','Y','Y');
mysql>insert into user
values('%','aman',PASSWORD('mysql024'),'Y','Y','Y','Y','Y','Y','N','N','N','
N','N','N','Y','Y');
mysql>FLUSH PRIVILEGES;

I am trying to connect from the shell by
shell>mysql -p -u aman
Enter password:
ERROR 1045: Access denied for user: 'aman@localhost' (Using password: YES)

Why so?
Thank you
Aman

-
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: Default Win install --> mySQL autostarts when booting?

[Ed Carp]

> Which version of WinXP (Pro or Home)?
>
> On WinXP Pro, you'd have to install MySQL as a service, in which case it
can
> either started manually or automatically. WinXP Home is more like WinME
> (yuck!) or Win98, where you can start MySLQ from a batch file.

WinXP Home is MUCH more stable than ME ever dreamed of being.  And yes, you
can run services under XP Home.

sql, 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

RE: Default Win install --> mySQL autostarts when booting?

[Gerald R. Jensen]

You are right, Paul ... the service is optional on WinXP Pro. I'm a creature of habit!

-Original Message-
From:   Paul DuBois [SMTP:[EMAIL PROTECTED]]
Sent:   Tuesday, September 10, 2002 7:32 PM
To: Gerald R. Jensen; Uriel Wittenberg; [EMAIL PROTECTED]
Subject:Re: Default Win install --> mySQL autostarts when booting?

At 18:47 -0500 9/10/02, Gerald R. Jensen wrote:
>Which version of WinXP (Pro or Home)?
>
>On WinXP Pro, you'd have to install MySQL as a service,

???

Have to, or have the option to?

>  in which case it can
>either started manually or automatically. WinXP Home is more like WinME
>(yuck!) or Win98, where you can start MySLQ from a batch file.
>
>- Original Message -
>From: "Uriel Wittenberg" <[EMAIL PROTECTED]>
>To: <[EMAIL PROTECTED]>; "Paul DuBois" <[EMAIL PROTECTED]>
>Sent: Tuesday, September 10, 2002 6:14 PM
>Subject: Default Win install --> mySQL autostarts when booting?
>
>
>Does a normal WinXP installation of WinXP result in the mySQL server being
>automatically started up whenever one boots up the system? If so this is not
>well documented and it's not an appropriate default, at least not for
>everyone. Is there a standard way to change that so the server only runs
>when explicitly invoked?
>
>- Original Message -
>From: "Paul DuBois" <[EMAIL PROTECTED]>
>To: "Uriel Wittenberg" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
>Sent: Tuesday, September 10, 2002 11:59 PM
>Subject: Re: Confused, discombobulated, weirded out, upset! --Windows
>standalone user
>
>
>>  >Then does a normal Windows installation set it up so the server
>autostarts
>>  >whenever you boot up? I did not manually start the server.
>>
>  > It might be installed as a service.



-
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 installation error... mysql.sock file not found

[anand v]

Hi,

I have redhat linux 7.1 server and I have downloaded the
binary version of mysql 3.23.52 and I have installed the same version on
other servers and it was all fine but on this server I am getting the 
following
error

[root@abacusweb mysql]# bin/safe_mysqld &
[1] 21278
[root@abacusweb mysql]# Starting mysqld daemon with databases from 
/var/lib/mysq
l
020910 19:12:53  mysqld ended

and I can not see the file mysql.sock in /varlib/mysql area but it has all 
the
tables etc that are needed. And I followed the README and all the docs and
did all the steps one by one.. and also I don't know how to run mysqlbug 
program??

How can direct mysqlbug program to a file so that I can send that file as an 
attachment
to this mailing list??

Please help me.. seems like I am stuck here... I created mysql user and the 
group
and I changed all the permissions according to the document

Thanks

Anand



_
MSN Photos is the easiest way to share and print your photos: 
http://photos.msn.com/support/worldwide.aspx


-
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 Question

[Paul DuBois]

At 17:16 -0700 9/10/02, Mark S Lowe wrote:
>I have to do an insert and need to nest a select inside. I have tons 
>of documentation on a very simple version of this, however my 
>requirements are one step beyond that. Here is what I'd like to do 
>in MySQL:
>
>insert into
>
>table1
>
>(column1, column2)
>
>values
>(select column1a from table2 where [something],
>valueFromMemory)
>
>If you'll notice, I want one column from a select and one column 
>outside the select. Is this possible in MySQL? All the documentation 
>I've read about MySQL says it can't be done.

It depends.  What is the second value and where does it come from?
If it's some expression that you can calculate on the fly, there's
no reason it can't be done.

>
>Thank you in advance!
>
>Mark


-
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: Default Win install --> mySQL autostarts when booting?

[Paul DuBois]

At 18:47 -0500 9/10/02, Gerald R. Jensen wrote:
>Which version of WinXP (Pro or Home)?
>
>On WinXP Pro, you'd have to install MySQL as a service,

???

Have to, or have the option to?

>  in which case it can
>either started manually or automatically. WinXP Home is more like WinME
>(yuck!) or Win98, where you can start MySLQ from a batch file.
>
>- Original Message -
>From: "Uriel Wittenberg" <[EMAIL PROTECTED]>
>To: <[EMAIL PROTECTED]>; "Paul DuBois" <[EMAIL PROTECTED]>
>Sent: Tuesday, September 10, 2002 6:14 PM
>Subject: Default Win install --> mySQL autostarts when booting?
>
>
>Does a normal WinXP installation of WinXP result in the mySQL server being
>automatically started up whenever one boots up the system? If so this is not
>well documented and it's not an appropriate default, at least not for
>everyone. Is there a standard way to change that so the server only runs
>when explicitly invoked?
>
>- Original Message -
>From: "Paul DuBois" <[EMAIL PROTECTED]>
>To: "Uriel Wittenberg" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
>Sent: Tuesday, September 10, 2002 11:59 PM
>Subject: Re: Confused, discombobulated, weirded out, upset! --Windows
>standalone user
>
>
>>  >Then does a normal Windows installation set it up so the server
>autostarts
>>  >whenever you boot up? I did not manually start the server.
>>
>  > It might be installed as a service.


-
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 Question

[Nicholas Stuart]

>From my experince this is not possible.
Is there any reason why you can not simply do two inserts following each
other?
INSERT INTO table1(column1) SELECT column1a FROM table2 WHERE [something]
INSERT INTO table1(column2) VALUES(valueFromMemory)
(as if you didnt know that already)  =D
There should be no reason why you couldnt do this as there is nothing that
ties the two columns together (that I can see here).
Maybe explain a bit more and we might be able to give you more info.

-Nick

> I have to do an insert and need to nest a select inside. I have tons of
> documentation on a very simple version of this, however my requirements
> are one step beyond that. Here is what I'd like to do in MySQL:
>
> insert into
>
> table1
>
> (column1, column2)
>
> values
> (select column1a from table2 where [something],
> valueFromMemory)
>
> If you'll notice, I want one column from a select and one column
> outside the select. Is this possible in MySQL? All the documentation
> I've read about MySQL says it can't be done.
>
> Thank you in advance!
>
> Mark
>
>
> -
> 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

MySQL Question

[Mark S Lowe]

I have to do an insert and need to nest a select inside. I have tons of 
documentation on a very simple version of this, however my requirements 
are one step beyond that. Here is what I'd like to do in MySQL:

insert into

table1

(column1, column2)

values
(select column1a from table2 where [something],
valueFromMemory)

If you'll notice, I want one column from a select and one column 
outside the select. Is this possible in MySQL? All the documentation 
I've read about MySQL says it can't be done.

Thank you in advance!

Mark


-
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

CoreReader

[John Ragan]

I am the creator of CoreReader and have done 
rudimentary testing against MySql.  However, not 
being familiar with that data source, I hesitate to 
state that CoreReader runs against it without 
problems.

Has anybody who knows what they are doing used 
CoreReader with MySql enough to say that there are 
no problems involved?


-- 
John Ragan
[EMAIL PROTECTED]
501-228-0317
http://www.CoreReader.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: Default Win install --> mySQL autostarts when booting?

[Gerald R. Jensen]

Which version of WinXP (Pro or Home)?

On WinXP Pro, you'd have to install MySQL as a service, in which case it can
either started manually or automatically. WinXP Home is more like WinME
(yuck!) or Win98, where you can start MySLQ from a batch file.

- Original Message -
From: "Uriel Wittenberg" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>; "Paul DuBois" <[EMAIL PROTECTED]>
Sent: Tuesday, September 10, 2002 6:14 PM
Subject: Default Win install --> mySQL autostarts when booting?


Does a normal WinXP installation of WinXP result in the mySQL server being
automatically started up whenever one boots up the system? If so this is not
well documented and it's not an appropriate default, at least not for
everyone. Is there a standard way to change that so the server only runs
when explicitly invoked?

- Original Message -
From: "Paul DuBois" <[EMAIL PROTECTED]>
To: "Uriel Wittenberg" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Tuesday, September 10, 2002 11:59 PM
Subject: Re: Confused, discombobulated, weirded out, upset! --Windows
standalone user


> >Then does a normal Windows installation set it up so the server
autostarts
> >whenever you boot up? I did not manually start the server.
>
> It might be installed as a service.


- finishing up previous topic: ---

> I don't understand.  In your previous message, you said:
>
> At 23:37 +0800 9/10/02, Uriel Wittenberg wrote:
> >
> >Also, per advice here, I tried putting local-infile=1 in the [mysqld] and
> >[mysql] sections of my.cnf(my.ini), but that does not change the
behavior.
>
> Which seems to contradict what you're saying now.

Yes, sorry -- I corrected my error in a previous message in this thread.



-
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: need help on DROP.

[Gerald R. Jensen]

Clarify your question ... are you trying to drop TABLES, DATABASES, or
modify user privileges?

If you are trying to modify user privileges, use GRANT or REVOKE.

- Original Message -
From: "Daniel Curry" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, September 10, 2002 6:26 PM
Subject: need help on DROP.



  I am unable to find the specific DROP command to remove only test@%,
test\_%@%,
snort@localhost, and snort@%.

  I am trying to clean up my db information.

Thank you.


mysql> select * from db;
+---+--++-+-+---
--+-+-+---++-+--
--++
| Host  | Db   | User   | Select_priv | Insert_priv |
Update_priv | Delete_priv | Create_priv | Drop_priv | Grant_priv |
References_priv | Index_priv | Alter_priv |
+---+--++-+-+---
--+-+-+---++-+--
--++
| % | test || Y   | Y   |
Y   | Y   | Y   | Y | N  |
Y   | Y  | Y  |
| % | test\_%  || Y   | Y   |
Y   | Y   | Y   | Y | N  |
Y   | Y  | Y  |
| localhost | snort| snort  | Y   | Y   |
Y   | Y   | Y   | N | N  |
N   | N  | N  |
| % | snort| snort  | Y   | Y   |
Y   | Y   | Y   | N | N  |
N   | N  | N  |
| localhost | snort_db | snort  | Y   | Y   |
Y   | Y   | N   | N | N  |
N   | N  | N  |
| % | snort_db | snort  | Y   | Y   |
Y   | Y   | N   | N | N  |
N   | N  | N  |
+---+--++-+-+---
--+-+-+---++-+--
--++
6 rows in set (0.00 sec)

-
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: need help on DROP.

[Daniel Curry]

Paul,
  Thank you.  That did it.
You are correct I needed to DELETE.


Paul DuBois wrote:
> 
> At 16:26 -0700 9/10/02, Daniel Curry wrote:
> >   I am unable to find the specific DROP command to remove only test@%,
> >test\_%@%,
> >snort@localhost, and snort@%.
> 
> I think you want DELETE, not DROP.
> 
> DELETE FROM db WHERE Db='test' AND Host='%';
> DELETE FROM db WHERE Db='test\_' AND Host='%';
> DELETE FROM db WHERE Db='snort' AND Host='localhost';
> DELETE FROM db WHERE Db='snort' AND Host='%';
> 
> >
> >   I am trying to clean up my db information.
> >
> >Thank you.
> >
> >
> >mysql> select * from db;
> 
>>+---+--++-+-+-+-+-+---++-+++
> >| Host  | Db   | User   | Select_priv | Insert_priv |
> >Update_priv | Delete_priv | Create_priv | Drop_priv | Grant_priv |
> >References_priv | Index_priv | Alter_priv |
> 
>>+---+--++-+-+-+-+-+---++-+++
> >| % | test || Y   | Y   |
> >Y   | Y   | Y   | Y | N  |
> >Y   | Y  | Y  |
> >| % | test\_%  || Y   | Y   |
> >Y   | Y   | Y   | Y | N  |
> >Y   | Y  | Y  |
> >| localhost | snort| snort  | Y   | Y   |
> >Y   | Y   | Y   | N | N  |
> >N   | N  | N  |
> >| % | snort| snort  | Y   | Y   |
> >Y   | Y   | Y   | N | N  |
> >N   | N  | N  |
> >| localhost | snort_db | snort  | Y   | Y   |
> >Y   | Y   | N   | N | N  |
> >N   | N  | N  |
> >| % | snort_db | snort  | Y   | Y   |
> >Y   | Y   | N   | N | N  |
> >N   | N  | N  |
> 
>>+---+--++-+-+-+-+-+---++-+++
> >6 rows in set (0.00 sec)
> >
> >-
> >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: Windows XP Installation Problems

[Lukoni, Bryan AG:EX]

Thanks Michel:

Enabled the error reporting, but no luck. I'm stumped why I am not seeing
any error messages when it fails to install. Do you know if the MYSQL
installation makes any modifications to the registry or adds files to the
system directory. If not I could probably just copy the complete directory
from the other computer onto a CD and recopy to the problem computer.

-=Bryan=-

> -Original Message-
> From: Michael Bunzel [mailto:[EMAIL PROTECTED]] 
> Sent: Tuesday, September 10, 2002 3:49 PM
> To: Lukoni, Bryan AG:EX
> Cc: [EMAIL PROTECTED]
> Subject: Re: Windows XP Installation Problems
> 
> 
> Hi Bryan,
> 
> could it be that you deactivated the Windows XP error 
> reporting function? Activate it for the Windows Operating 
> System and All Programs and try installing MySQL again. If an 
> error message occurs the provided data might help you track 
> down the problem... If not don't forget to deactivate it again ;-)
> 
> --
> Michael Bunzel
> LintraNex Systems
> Vienna, Austria
> 
> Lukoni, Bryan AG:EX wrote:
> 
>  > I am unable to install either version MySQL 4.03 or the 
> release MySQL 3.23
> > on a XP professional operating system. No error message is produced,
> double
> > clicking the setup.exe file only produces a flashing hourglass for a
> second
> > and then nothing, no error messages. Suggestions anyone.
> >
> > Stange thing, is it installed fine on my home computer which is 
> > running XP professional.
> >
> >
> > -=Bryan=-
> >
> > 
> -
> > 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: need help on DROP.

[Paul DuBois]

At 16:26 -0700 9/10/02, Daniel Curry wrote:
>   I am unable to find the specific DROP command to remove only test@%,
>test\_%@%,
>snort@localhost, and snort@%.

I think you want DELETE, not DROP.

DELETE FROM db WHERE Db='test' AND Host='%';
DELETE FROM db WHERE Db='test\_' AND Host='%';
DELETE FROM db WHERE Db='snort' AND Host='localhost';
DELETE FROM db WHERE Db='snort' AND Host='%';

>
>   I am trying to clean up my db information.
>
>Thank you.
>
>
>mysql> select * from db;
>+---+--++-+-+-+-+-+---++-+++
>| Host  | Db   | User   | Select_priv | Insert_priv |
>Update_priv | Delete_priv | Create_priv | Drop_priv | Grant_priv |
>References_priv | Index_priv | Alter_priv |
>+---+--++-+-+-+-+-+---++-+++
>| % | test || Y   | Y   |
>Y   | Y   | Y   | Y | N  |
>Y   | Y  | Y  |
>| % | test\_%  || Y   | Y   |
>Y   | Y   | Y   | Y | N  |
>Y   | Y  | Y  |
>| localhost | snort| snort  | Y   | Y   |
>Y   | Y   | Y   | N | N  |
>N   | N  | N  |
>| % | snort| snort  | Y   | Y   |
>Y   | Y   | Y   | N | N  |
>N   | N  | N  |
>| localhost | snort_db | snort  | Y   | Y   |
>Y   | Y   | N   | N | N  |
>N   | N  | N  |
>| % | snort_db | snort  | Y   | Y   |
>Y   | Y   | N   | N | N  |
>N   | N  | N  |
>+---+--++-+-+-+-+-+---++-+++
>6 rows in set (0.00 sec)
>
>-
>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

need help on DROP.

[Daniel Curry]

  I am unable to find the specific DROP command to remove only test@%,
test\_%@%,
snort@localhost, and snort@%.

  I am trying to clean up my db information.

Thank you.


mysql> select * from db;
+---+--++-+-+-+-+-+---++-+++
| Host  | Db   | User   | Select_priv | Insert_priv |
Update_priv | Delete_priv | Create_priv | Drop_priv | Grant_priv |
References_priv | Index_priv | Alter_priv |
+---+--++-+-+-+-+-+---++-+++
| % | test || Y   | Y   |
Y   | Y   | Y   | Y | N  |
Y   | Y  | Y  |
| % | test\_%  || Y   | Y   |
Y   | Y   | Y   | Y | N  |
Y   | Y  | Y  |
| localhost | snort| snort  | Y   | Y   |
Y   | Y   | Y   | N | N  |
N   | N  | N  |
| % | snort| snort  | Y   | Y   |
Y   | Y   | Y   | N | N  |
N   | N  | N  |
| localhost | snort_db | snort  | Y   | Y   |
Y   | Y   | N   | N | N  |
N   | N  | N  |
| % | snort_db | snort  | Y   | Y   |
Y   | Y   | N   | N | N  |
N   | N  | N  |
+---+--++-+-+-+-+-+---++-+++
6 rows in set (0.00 sec)

-
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

Default Win install --> mySQL autostarts when booting?

[Uriel Wittenberg]

Does a normal WinXP installation of WinXP result in the mySQL server being
automatically started up whenever one boots up the system? If so this is not
well documented and it's not an appropriate default, at least not for
everyone. Is there a standard way to change that so the server only runs
when explicitly invoked?

- Original Message -
From: "Paul DuBois" <[EMAIL PROTECTED]>
To: "Uriel Wittenberg" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Tuesday, September 10, 2002 11:59 PM
Subject: Re: Confused, discombobulated, weirded out, upset! --Windows
standalone user


> >Then does a normal Windows installation set it up so the server
autostarts
> >whenever you boot up? I did not manually start the server.
>
> It might be installed as a service.


- finishing up previous topic: ---

> I don't understand.  In your previous message, you said:
>
> At 23:37 +0800 9/10/02, Uriel Wittenberg wrote:
> >
> >Also, per advice here, I tried putting local-infile=1 in the [mysqld] and
> >[mysql] sections of my.cnf(my.ini), but that does not change the
behavior.
>
> Which seems to contradict what you're saying now.

Yes, sorry -- I corrected my error in a previous message in this thread.



-
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: Windows XP Installation Problems

[Michael Bunzel]

Hi Bryan,

could it be that you deactivated the Windows XP error reporting function?
Activate it for the Windows Operating System and All Programs and try
installing MySQL again. If an error message occurs the provided data might
help you track down the problem... If not don't forget to deactivate it
again ;-)

--
Michael Bunzel
LintraNex Systems
Vienna, Austria

Lukoni, Bryan AG:EX wrote:

 > I am unable to install either version MySQL 4.03 or the release MySQL
3.23
> on a XP professional operating system. No error message is produced,
double
> clicking the setup.exe file only produces a flashing hourglass for a
second
> and then nothing, no error messages. Suggestions anyone.
>
> Stange thing, is it installed fine on my home computer which is running XP
> professional.
>
>
> -=Bryan=-
>
> -
> 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: 'mysqladmin shutdown' doesn't shut it down...

[Daniel Kasak]

Eric Lamendola wrote:

> Hey,
>
> I thought you could just use
>
> mysqladmin refresh -pPASSWORD -- or
> mysqladmin reload -pPASSWORD
>
> To kickstart logging again?
>
> If not - hey, what do I know 
>
> Eric Lamendola
>
Yeah that only restarts the binary log. I like to have a human-readable 
log which I can run through for when I screw up a query badly (or 
someone else does something just as silly) and have to recover by 
restoring from a backup, editing the transaction log and handing it back 
through the mysql client:

mysql < log_without_stupid_mistake -pPASSWORD

I've had to do this a few times now...
As far as I know you can't do this very easily with the binary log. 
Anyway, I feel a lot better knowing I can see something human-readable. 
I like watching my logs, OK? :) And I want them broken up by the day so 
they're managable. Is there a way of making mysql also restart the 
non-binary (pure sql) log?

-- 
Daniel Kasak
IT Developer
* NUS Consulting Group*
Level 18, 168 Walker Street
North Sydney, NSW, Australia 2060
T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989
email: [EMAIL PROTECTED]
website: www.nusconsulting.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: [PHP] Questions regarding inserting and updating data into a MySQL db

[Axis Computers]

Thanks for the tip I will try that, I'm still learning MySQL and PHP,
although I did a couple of complex applications, there are some
techniques that still are 'obscure' to me.

Regards,

Ricardo Fitzgerald
AXIS Computers
- Original Message -
From: "Chris Shiflett" <[EMAIL PROTECTED]>
To: "Axis Computers" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>; "PHP" <[EMAIL PROTECTED]>
Sent: Tuesday, September 10, 2002 7:24 PM
Subject: Re: [PHP] Questions regarding inserting and updating data into a
MySQL db


> You should search for some SQL tutorials on the Web.
>
> What it sounds like you are looking for is the "update" SQL statement
> which modifies an existing row (for your second form, for example).
> Thus, you "insert" the row to create it (which assigns the key using the
> auto increment), then "update" that row to make any modifications you
> need to after that.
>
> Happy hacking.
>
> Chris
>
> Axis Computers wrote:
>
> > I'm developing a web application that uses forms for user input and
> > then after each form is filled shows something like Welcome Bob to our
> > site ... bla. bla... inserts data in a table and on the same page
> > continues with the rest of the data, and goes to another form and so on.
> >
> > I have no problems inserting the data from the first form in the
> > table, display the personalized message, and then connect to the mySQL
> > db, my problem is some fields in the table which must be filled are
> > null in this first instance, and then on the second form they are
filled,
> > but my I don´t know how can I fill the gaps and leave all the data in
> > one row, because the first field auto increments, and I'm worried the
> > data instead of filling one row spreads accross two or three.
>
>
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.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: [PHP] Questions regarding inserting and updating data into aMySQL db

[Chris Shiflett]

You should search for some SQL tutorials on the Web.

What it sounds like you are looking for is the "update" SQL statement 
which modifies an existing row (for your second form, for example). 
Thus, you "insert" the row to create it (which assigns the key using the 
auto increment), then "update" that row to make any modifications you 
need to after that.

Happy hacking.

Chris

Axis Computers wrote:

> I'm developing a web application that uses forms for user input and 
> then after each form is filled shows something like Welcome Bob to our 
> site ... bla. bla... inserts data in a table and on the same page 
> continues with the rest of the data, and goes to another form and so on.
>  
> I have no problems inserting the data from the first form in the 
> table, display the personalized message, and then connect to the mySQL 
> db, my problem is some fields in the table which must be filled are 
> null in this first instance, and then on the second form they are filled,
> but my I don´t know how can I fill the gaps and leave all the data in 
> one row, because the first field auto increments, and I'm worried the 
> data instead of filling one row spreads accross two or three.



-
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: deleting frequently = OK?

[Erick Papadakis]

sql, query

thanks for the note brent. 


> If you don't have any variable length 
> fields (ie. varchar) then all your record 
> lengths are exactly the same and the 
> "empty" space can be reused for new records, 
> preventing fragmentation. 


i think we can do this. since this rotateable table is only for
calculations, it only contains integer values. but is there any
documentationm for such issues? my guess is that although the table may
not lead to fragmentation, the index may? 



> When you say "truncate entirely" do you mean you're are 
> performing a 
> "DELETE FROM TABLE"? 


yes, either that, or 

TRUNCATE TABLE table1

is there any reason one is better than the other?

thanks for any advice! 

.ep


__
Yahoo! - We Remember
9-11: A tribute to the more than 3,000 lives lost
http://dir.remember.yahoo.com/tribute

-
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

can not connect or log into MySQL anymore.

[Stephen Sokalski]

version: 3.23.37 running on an RAQ
Problem:  I can not log into MySql as root - it hangs after I give it a 
password.
Background:  MySql was running fine for a year and then just stopped 
running.

Symptoms:   
1) Mysqld is running when I reboot the server but can't be shut down 
(/usr/share/mysql/mysql.server stop) and keeps timing out.
2) When it's running there is a .sock file
3) If I try to log in as any valid user, it simply waits indefinitely.
4) Suspecting that something is wrong with the mysql database, I ran a 
check on it:
myisamchk -f *.MYI and
myisamchk -r *.MYI
Every time I run the -r it states it's repairing indexes.

In any event:
I know I should probably upgrade the version but it was a "package" that 
was suggested by sun at the time and I know I could
download the binary but ... I want to make sure I understand what the 
problem is and know that I will be able to fix it by upgrading.

Can someone explain what is going on?  Will upgrading fix this problem, 
etc.?

Thanks,
Steve


-
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

Web Usage queries against apache logs

[Chad Arimura]

Hi everyone -

We recently started logging our apache logs directly into a mysql db.  Two
questions:

1. The db files are growing fairly rapidly.  Will inserts begin to slow the
larger the database gets?  Is there a recommended method for rotating the
database every few gigs (it's all in one table, so we could rotate the
table...)  Or should we just keep letting it grow and maybe deal with it
down the road?  After a a few hundred gigs, say

2. Does anyone have an already thought out set of SQL queries that will
generate useful data given a database full of log files?  I know all those
database analysis tools do something along those lines, except they parse
the log rather than querying a db.  (ie Unique visitors for a given time
period, exit pages, entry pages, etc)


Thanks in advance,
Chad Arimura


-
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

SQL help, search with related record in 2nd table

[Michael Collins]

I am looking for some help on a SQL query to perform a search, but 
constrain the search to those records which have a related record in 
a second table. What I think I need is a subselect, but since this is 
not possible in 3.23.47, I am looking for work around.

I have one table for Visitors (key is VisitorID) and another for 
items that a user has selected named WishListItems (foreign key is 
VisitorID).

SELECT Visitors.* FROM Visitors, WishListItems
WHERE Visitors.VisitorID=WishListItems.VisitorID AND 
Visitors.NameLast REGEXP 'Collins';

I get a result for each record there is in WishListItems.

I tried using a Join but that does not help:

SELECT Visitors.* FROM Visitors INNER JOIN WishListItems
On Visitors.VisitorID=WishListItems.VisitorID WHERE Visitors.NameLast 
REGEXP 'Collins';

I seem to get the same result.

What I need is to search Visitors, but only find records from 
Visitors if there are any records in WishListItems (I am not checking 
anythign in WishListItems, there just has to be at least one record).

-- 
Michael
__
||| Michael Collins
||| Kuwago Inc  mailto:[EMAIL PROTECTED]
||| Seattle, WA, USAhttp://michaelcollins.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 on AIX 4.3.3 problem: errmsg.sys missing?

[Gerald Clark]

Make sure mysql is the owner of /usr/local/mysql.
With Linux the command is
chown -R  mysql  /usr/local/mysql

This recursively makes mysql the owner, and keeps security tight.

Xiaolin Zhao wrote:

>Dear Gerald,
>
>Many thanks!
>
>I just did a chmod -R a+r, then everything is fixed. 
>
>It is kind of lasy and security breaking act, but at
>least that confirms the nature of the problem.
>
>Best regards,
>
>Allen Zhao
>
>--- Gerald Clark <[EMAIL PROTECTED]>
>wrote:
>
>>Make sure mysql has search privileges through all
>>the
>>directories to the file.
>>
>>Xiaolin Zhao wrote:
>>
>>>Hi, 
>>>
>>>Yes, it is existing:
>>>
>>>ibmaix:/usr/local/mysql # ls -al
>>>./share/mysql/english/errmsg.sys
>>>-rw-r--r--   1 mysqlsystem 12183 Sep 09
>>>
>>17:02
>>
>>>./share/mysql/english/errmsg.sys
>>>
>>>The mysqld is run as mysql user. 
>>>
>>>That is why I can not understand it. 
>>>
>>>Any idea?
>>>
>>>Best regards,
>>>
>>>Allen Zhao
>>>
>>>
>>>
>>>--- Gerald Clark <[EMAIL PROTECTED]>
>>>wrote:
>>>
Is the file there, and readable by the user

>>'mysql'
>>
?

Xiaolin Zhao wrote:

>Hi, All
>
>I am trying to make MySQL 4.0.3b work with AIX
>
4.3.3.

>But whenever I did the `./bin/safe_mysqld &`
>
command,

>I get following error:
>
>020910 08:31:33  mysqld started
>020910  8:31:33  Can't find messagefile
>'mysql-4.0.3b/share/mysql/english/errmsg.sys'
>020910  8:31:33  Aborting
>
>020910 08:31:33  mysqld ended
>
>The mysql is installed under
>
/usr/local/mysql-4.0.3b,

>and /usr/local/mysql is sym link to mysql-4.0.3b.
>
>Can anyone pinpoint what the problem is? TIA
>
>Best regards,
>
>Allen Zhao
>
>>
>
>
>__
>Do You Yahoo!?
>Yahoo! Finance - Get real-time stock quotes
>http://finance.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: Innodb X myisam

[Yuri]

> I have been working with Mysql-Myisam, but when I converted to Inoodb
> I
> noticed that my queries were much slower.
> Why?
Inno DB handles transactions. So if they are "on"
it generally would be slower vs. if they are "off"
since it has to keep both copies of data (before
and after change)
> what can I do for best the performance?
Ex. use raw disk option in InnoDB. This generally
speeds up operations since you bypass file system
drivers. See if all indexes are correct and not
missing. Increase memory buffers like
key_buffer/record_buffer in my.cnf.

> When do I have to use the innodb?
For reliability (it's crash-safe), transactions.

Yuri.

-
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

Innodb X myisam

[Silmara Cristina Basso]

I have been working with Mysql-Myisam, but when I converted to Inoodb I
noticed that my queries were much slower.
Why?
what can I do for best the performance?
When do I have to use the innodb?

Best regards.

Thank you!





-
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

Schema changes affect regular select?

[Yuri]

Do schema operations affect
regular statements?

I've run "alter table add column ..."
on the large table and it coinsided
with "select fld from same_table limit 0,1".
And this select returned as if no records
were available though there were plenty.

Is this normal?
Should schema changes run independantly
if they _really_ don't affect regular
statements (if fields not involved in
select modified) ?

I think schema changes should follow
transactional paradigm. But that's tough
to do, I understand. At least they have
to wait on each other.

Yuri.



sql,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

RE: Convert dates for import into Mysql

[David Yee]

Thanks to Peter's hint here's an example of how I'll be doing it using PHP:



David

> -Original Message-
> From: Peter Engström [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, September 10, 2002 12:18 PM
> To: David Yee
> Cc: [EMAIL PROTECTED]
> Subject: Re: Convert dates for import into Mysql
> 
> 
> Hi David!
> 
> What language do you use to build your application?
> 
> You can do this easily with PHP.
> Please have a look at the following functions
> http://se.php.net/manual/en/function.strtotime.php
> http://se.php.net/manual/en/function.strftime.php
> 
> Best regards
> /Peter
> 
> 
> 
> - Original Message -
> From: "David Yee" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Tuesday, September 10, 2002 8:57 PM
> Subject: Convert dates for import into Mysql
> 
> 
> > Hi all. Does any one know how to convert dates like 
> "06-Sep-02 00:00:00"
> > into the mysql datetime format?  The main challenge here is probably
> > converting the 3 letter abbreviations for the month.  Thanks for any
> input.
> >
> > 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

Found a bug with... CREATE SELECT IF?

[ant]

>Description:
Apparently in 4.0.3 does not like if statements in it's
SELECT query... A query that once worked now returns 0 when I use
an IF, rather than the proper value

>How-To-Repeat:
  This is a simple example of how I am able to recreate...
CREATE TEMPORARY TABLE temp SELECT IF(LENGTH('test'),'test','test') AS test;
SELECT * FROM temp;

  This will yield 0, where it should be test...

  Describing the table shows an int(4), so I am guessing it is not figuring
out the proper type... my original query I found this in is as follows,
H.type is a char(5) field

CREATE TEMPORARY TABLE map(primary key(h_order), key (type)) IGNORE SELECT H.type AS 
a,IF(LENGTH(H.type),H.type,H.type) AS type,H.h_order,H.userid FROM 
pool_holdings.h_ANTSPOOL_18 AS H LEFT JOIN pool_lookup.lookup AS L ON H.userid = 
L.secid AND (H.type = '' OR L.type = H.type);

>Fix:
no known way

>Submitter-Id:  
>Originator:Web development
>Organization:
 
>MySQL support: [none | licence | email support | extended email support ]
>Synopsis:  
>Severity:  
>Priority:  
>Category:  mysql
>Class: 
>Release:   mysql-4.0.3-beta-max (Official MySQL-max binary)
>Server: /idcom/mysql/bin/mysqladmin  Ver 8.37 Distrib 4.0.3-beta, for sun-solaris2.7 
>on sparc
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  4.0.3-beta-max
Protocol version10
Connection  127.0.0.1 via TCP/IP
TCP port3307
Uptime: 1 day 39 min 50 sec

Threads: 29  Questions: 5800958  Slow queries: 402  Opens: 689  Flush tables: 12  Open 
tables: 78  Queries per second avg: 65.333
>Environment:

System: SunOS gums-sun 5.7 Generic_106541-16 sun4u sparc SUNW,Ultra-Enterprise
Architecture: sun4

Some paths:  /prod/gnusol/bin/perl /usr/ccs/bin/make 
/prod/cygnus/gnupro-99r1/H-sparc-sun-solaris2.7/bin/gcc /usr/ucb/cc
GCC: Reading specs from 
/prod/cygnus/gnupro-99r1/H-sparc-sun-solaris2.7/lib/gcc-lib/sparc-sun-solaris2.7/2.9-gnupro-99r1/specs
gcc version 2.9-gnupro-99r1
Compilation info: CC='gcc'  CFLAGS='-O3 -fno-omit-frame-pointer'  CXX='gcc'  
CXXFLAGS='-O3 -fno-omit-frame-pointer -felide-constructors -fno-exceptions -fno-rtti'  
LDFLAGS=''
LIBC: 
-rw-r--r--   1 bin  bin  1707752 May  2  2001 /lib/libc.a
lrwxrwxrwx   1 root root  11 Dec 13  2001 /lib/libc.so -> ./libc.so.1
-rwxr-xr-x   1 bin  bin  1125056 May  2  2001 /lib/libc.so.1
-rw-r--r--   1 bin  bin  1707752 May  2  2001 /usr/lib/libc.a
lrwxrwxrwx   1 root root  11 Dec 13  2001 /usr/lib/libc.so -> ./libc.so.1
-rwxr-xr-x   1 bin  bin  1125056 May  2  2001 /usr/lib/libc.so.1
Configure command: ./configure --prefix=/usr/local/mysql '--with-comment=Official 
MySQL-max binary' --with-extra-charsets=complex --with-server-suffix=-max 
--enable-thread-safe-client --enable-local-infile --enable-assembler --disable-shared 
--with-berkeley-db --with-raid --with-innodb CC=gcc 'CFLAGS=-O3 
-fno-omit-frame-pointer' 'CXXFLAGS=-O3 -fno-omit-frame-pointer -felide-constructors 
-fno-exceptions -fno-rtti' CXX=gcc


-
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: Convert dates for import into Mysql

[David Yee]

Hi Peter- thanks for the reply.  Yes I do use PHP but I was not aware of
those two functions.  I was just going to do a str_replace() for all the
different months, then do an explode on the date and re-arrange it, but
these two functions may provide a much better solution.

David

> -Original Message-
> From: Peter Engström [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, September 10, 2002 12:18 PM
> To: David Yee
> Cc: [EMAIL PROTECTED]
> Subject: Re: Convert dates for import into Mysql
> 
> 
> Hi David!
> 
> What language do you use to build your application?
> 
> You can do this easily with PHP.
> Please have a look at the following functions
> http://se.php.net/manual/en/function.strtotime.php
> http://se.php.net/manual/en/function.strftime.php
> 
> Best regards
> /Peter
> 
> 
> 
> - Original Message -
> From: "David Yee" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Tuesday, September 10, 2002 8:57 PM
> Subject: Convert dates for import into Mysql
> 
> 
> > Hi all. Does any one know how to convert dates like 
> "06-Sep-02 00:00:00"
> > into the mysql datetime format?  The main challenge here is probably
> > converting the 3 letter abbreviations for the month.  Thanks for any
> input.
> >
> > 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

Re: Convert dates for import into Mysql

[Peter Engström]

Hi David!

What language do you use to build your application?

You can do this easily with PHP.
Please have a look at the following functions
http://se.php.net/manual/en/function.strtotime.php
http://se.php.net/manual/en/function.strftime.php

Best regards
/Peter



- Original Message -
From: "David Yee" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, September 10, 2002 8:57 PM
Subject: Convert dates for import into Mysql


> Hi all. Does any one know how to convert dates like "06-Sep-02 00:00:00"
> into the mysql datetime format?  The main challenge here is probably
> converting the 3 letter abbreviations for the month.  Thanks for any
input.
>
> 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

Convert dates for import into Mysql

[David Yee]

Hi all. Does any one know how to convert dates like "06-Sep-02 00:00:00"
into the mysql datetime format?  The main challenge here is probably
converting the 3 letter abbreviations for the month.  Thanks for any input.

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

RE: Selecting data from one table if it's NOT in another

[Weaver, Walt]

Try this (not sure the syntax is exactly right since I'm more used to
Oracle's outer join syntax):

select * from main left join activity on main.user = activity.id
where activity.id is null;

This should return only the users in main that are not in activity.

--Walt Weaver
  Bozeman, Montana


-Original Message-
From: Steve Davies [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, September 10, 2002 12:23 PM
To: [EMAIL PROTECTED]
Subject: Selecting data from one table if it's NOT in another


>
>
>Hi all
>
>There's probably a simple answer to this but I can't find it and it's 
>doing my head in.
>
>I have two tables:
>main contains user data, address,name,etc.
>activity contains user activity
>
>'user' in main has the same value as 'id' in activity
>
>I want to produce a list of users who have not been active, i.e. pull 
>all the data for users in main who do NNOT appear in activity
>
>I've tried running the following sql
>
>select * from main as t1, activity as t2 where t1.user !=  t2.id;
>select * from main left join activity on main.user = activity.id
>select @id:=id from activity; select * from main where user != @id;
>
>But each query produces near identical results - more or less a dump of
main.
>
>Any ideas gratefully rec'd.
>
>Thanks
>
>Steve Davies
>
>  
>



-
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 on AIX 4.3.3 problem: errmsg.sys missing?

[Xiaolin Zhao]

Dear Gerald,

Many thanks!

I just did a chmod -R a+r, then everything is fixed. 

It is kind of lasy and security breaking act, but at
least that confirms the nature of the problem.

Best regards,

Allen Zhao

--- Gerald Clark <[EMAIL PROTECTED]>
wrote:
> Make sure mysql has search privileges through all
> the
> directories to the file.
> 
> Xiaolin Zhao wrote:
> 
> >Hi, 
> >
> >Yes, it is existing:
> >
> >ibmaix:/usr/local/mysql # ls -al
> >./share/mysql/english/errmsg.sys
> >-rw-r--r--   1 mysqlsystem 12183 Sep 09
> 17:02
> >./share/mysql/english/errmsg.sys
> >
> >The mysqld is run as mysql user. 
> >
> >That is why I can not understand it. 
> >
> >Any idea?
> >
> >Best regards,
> >
> >Allen Zhao
> >
> >
> >
> >--- Gerald Clark <[EMAIL PROTECTED]>
> >wrote:
> >
> >>Is the file there, and readable by the user
> 'mysql'
> >>?
> >>
> >>Xiaolin Zhao wrote:
> >>
> >>>Hi, All
> >>>
> >>>I am trying to make MySQL 4.0.3b work with AIX
> >>>
> >>4.3.3.
> >>
> >>>But whenever I did the `./bin/safe_mysqld &`
> >>>
> >>command,
> >>
> >>>I get following error:
> >>>
> >>>020910 08:31:33  mysqld started
> >>>020910  8:31:33  Can't find messagefile
> >>>'mysql-4.0.3b/share/mysql/english/errmsg.sys'
> >>>020910  8:31:33  Aborting
> >>>
> >>>020910 08:31:33  mysqld ended
> >>>
> >>>The mysql is installed under
> >>>
> >>/usr/local/mysql-4.0.3b,
> >>
> >>>and /usr/local/mysql is sym link to mysql-4.0.3b.
> 
> >>>
> >>>Can anyone pinpoint what the problem is? TIA
> >>>
> >>>Best regards,
> >>>
> >>>Allen Zhao
> >>>
> >>
> 
> 


__
Do You Yahoo!?
Yahoo! Finance - Get real-time stock quotes
http://finance.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: deleting frequently = OK?

[Brent Baisley]

As is usually the case, it depends on your table structure and how you 
are deleting. If you don't have any variable length fields (ie. varchar) 
then all your record lengths are exactly the same and the "empty" space 
can be reused for new records, preventing fragmentation. I'm only 95% 
positive that advice is correct, so someone correct me if I'm wrong.

When you say "truncate entirely" do you mean you're are performing a 
"DELETE FROM TABLE"? If so, then you have nothing to worry about. When 
deleting every record in a table, the system is essentially (actually?) 
deleting the database file and creating an entirely new one. So there 
will be no fragmentation because of this action.


On Tuesday, September 10, 2002, at 10:25 AM, Erick Papadakis wrote:

> hello
>
>   sql, query
>
> for various reasons, i need to do a cron job that will take a snapshot 
> of
> table1 (by snapshot i mean a temporary table), do some processing, and
> then save some scientific calculations to table2. after this, i need to
> "refresh" table1 -- i.e., truncate it entirely. i need to do this 
> every 5
> minutes so that table1 is "rotated" every 5 mins after my scientific
> calculations off it.
>
> my question is: does this have a negative impact on the table1 since it
> is being truncated every 5 minutes? That is roughly about
>
> 365 days * 24 hours * 12 times
>  =  105,120 times a year !!!
>
> my questions:
>
> 1. is there something else i can do? i considered writing text files
> instead of the DB, but then the 'processing' becomes a lot more
> complicated.
>
> 2. i considered making this special table1 in a separate tablespace ...
>
>2a. would a different database be a different "table space" in mysql?
>2b. would this help at all?
>
> would appreciate any insight/advice.
>
> thanks/erick
>
> __
> Yahoo! - We Remember
> 9-11: A tribute to the more than 3,000 lives lost
> http://dir.remember.yahoo.com/tribute
>
> -
> 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
>
>
--
Brent Baisley
Systems Architect
Landover Associates, Inc.
Search & Advisory Services for Advanced Technology Environments
p: 212.759.6400/800.759.0577


-
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

Error during make for mysql 3.23.45

[Niranjan Patel]

Hello everybody,

I am getting the following error during make of mysql
3.23.45 on solaris 2.5.
Anybody has an idea please reply

Thanks,
Niranjan


ake[1]: Entering directory
`/homes/woprf/n/niranjan/tmpfiles/mysql-3.23.45'
Making all in include
make[2]: Entering directory
`/homes/woprf/n/niranjan/tmpfiles/mysql-3.23.45/include'
make[2]: Nothing to be done for `all'.
make[2]: Leaving directory
`/homes/woprf/n/niranjan/tmpfiles/mysql-3.23.45/include'
Making all in Docs
make[2]: Entering directory
`/homes/woprf/n/niranjan/tmpfiles/mysql-3.23.45/Docs'
make[2]: Nothing to be done for `all'.
make[2]: Leaving directory
`/homes/woprf/n/niranjan/tmpfiles/mysql-3.23.45/Docs'
Making all in readline
make[2]: Entering directory
`/homes/woprf/n/niranjan/tmpfiles/mysql-3.23.45/readline'
make[2]: Nothing to be done for `all'.
make[2]: Leaving directory
`/homes/woprf/n/niranjan/tmpfiles/mysql-3.23.45/readline'
Making all in libmysql
make[2]: Entering directory
`/homes/woprf/n/niranjan/tmpfiles/mysql-3.23.45/libmysql'
make[2]: Nothing to be done for `all'.
make[2]: Leaving directory
`/homes/woprf/n/niranjan/tmpfiles/mysql-3.23.45/libmysql'
Making all in client
make[2]: Entering directory
`/homes/woprf/n/niranjan/tmpfiles/mysql-3.23.45/client'
c++ -DUNDEF_THREADS_HACK -I./../include   
 -I../include -I./.. -I.. 
  -I..-O3 -DDBUG_OFF  
-fno-implicit-templates -fno-exceptions -fno-rtti
-DHAVE_RWLOCK_T -DSOLARIS -c mysql.cc
cc1plus: Invalid option `-fno-exceptions'
cc1plus: Invalid option `-fno-rtti'
In file included from client_priv.h:19,
 from mysql.cc:28:
./../include/global.h:680: warning: abstract
declarator used as declaration
In file included from mysql.cc:49:
/usr/include/term.h:1043: warning: ANSI C++ forbids
declaration `SGTTYS' with no type or storage class
/usr/include/term.h:1043: parse error before `,'
make[2]: *** [mysql.o] Error 1
make[2]: Leaving directory
`/homes/woprf/n/niranjan/tmpfiles/mysql-3.23.45/client'
make[1]: *** [all-recursive] Error 1
make[1]: Leaving directory
`/homes/woprf/n/niranjan/tmpfiles/mysql-3.23.45'
make: *** [all-recursive-am] Error 2


__
Yahoo! - We Remember
9-11: A tribute to the more than 3,000 lives lost
http://dir.remember.yahoo.com/tribute

-
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

Selecting data from one table if it's NOT in another

[Steve Davies]

>
>
>Hi all
>
>There's probably a simple answer to this but I can't find it and it's 
>doing my head in.
>
>I have two tables:
>main contains user data, address,name,etc.
>activity contains user activity
>
>'user' in main has the same value as 'id' in activity
>
>I want to produce a list of users who have not been active, i.e. pull 
>all the data for users in main who do NNOT appear in activity
>
>I've tried running the following sql
>
>select * from main as t1, activity as t2 where t1.user !=  t2.id;
>select * from main left join activity on main.user = activity.id
>select @id:=id from activity; select * from main where user != @id;
>
>But each query produces near identical results - more or less a dump of main.
>
>Any ideas gratefully rec'd.
>
>Thanks
>
>Steve Davies
>
>  
>



-
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 on AIX 4.3.3 problem: errmsg.sys missing?

[Gerald Clark]

Make sure mysql has search privileges through all the
directories to the file.

Xiaolin Zhao wrote:

>Hi, 
>
>Yes, it is existing:
>
>ibmaix:/usr/local/mysql # ls -al
>./share/mysql/english/errmsg.sys
>-rw-r--r--   1 mysqlsystem 12183 Sep 09 17:02
>./share/mysql/english/errmsg.sys
>
>The mysqld is run as mysql user. 
>
>That is why I can not understand it. 
>
>Any idea?
>
>Best regards,
>
>Allen Zhao
>
>
>
>--- Gerald Clark <[EMAIL PROTECTED]>
>wrote:
>
>>Is the file there, and readable by the user 'mysql'
>>?
>>
>>Xiaolin Zhao wrote:
>>
>>>Hi, All
>>>
>>>I am trying to make MySQL 4.0.3b work with AIX
>>>
>>4.3.3.
>>
>>>But whenever I did the `./bin/safe_mysqld &`
>>>
>>command,
>>
>>>I get following error:
>>>
>>>020910 08:31:33  mysqld started
>>>020910  8:31:33  Can't find messagefile
>>>'mysql-4.0.3b/share/mysql/english/errmsg.sys'
>>>020910  8:31:33  Aborting
>>>
>>>020910 08:31:33  mysqld ended
>>>
>>>The mysql is installed under
>>>
>>/usr/local/mysql-4.0.3b,
>>
>>>and /usr/local/mysql is sym link to mysql-4.0.3b. 
>>>
>>>Can anyone pinpoint what the problem is? TIA
>>>
>>>Best regards,
>>>
>>>Allen Zhao
>>>
>>



-
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 database lockup (v3.23.49)

[Kevin Slean]

All,

We are experiencing a strange problem where one minute everything is running
fine on mysql, then the next minute, all queries seem to lockup.

Can anybody provide guidance to me so I can determine the cause of the
lockups?

So far I dump the proc logs every minute via cron.  I have found that the
proclog before the "lockup" shows about 100 open connections to database in
sleep (1 or 2 actually doing work).  Then the proclog from a minute later
when the lockup is in progress shows almost every connection in query.
These lockups appear to be intermittent and I do not see anything in common
from one proclog to the next.

We are running mysql v3.23.49 on Solaris 5.7.

Kevin


-
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: Windows XP Installation Problems

[Lukoni, Bryan AG:EX]

Thanks, I have the installation files on the HD, not using the CD. I do have
admin access to the machine, never had a problem installing programs before.

Can you explain how to make XP can run in 16 bit mode.


-=Bryan=-

> -Original Message-
> From: b.ware [mailto:[EMAIL PROTECTED]] 
> Sent: Monday, September 09, 2002 5:27 PM
> To: Lukoni, Bryan AG:EX; '[EMAIL PROTECTED]'
> Subject: Re: Windows XP Installation Problems
> 
> 
> If it installed on Pro at home, it should do the same
> on another pc running Pro.(in a perfect world maybe)
> try these troubleshooting steps.
>   
> FIRST:  check you Privileges.  Make sure you are
> authorized to install software on the system.
> 
> 2ND:  instead of double clicking the setup.exe, use
> XP's add software app, and let XP find the setup.exe
> and auto install it.
> 
> 3RD:  check the settings, i.e. DMA, Disconnect, etc.
> of the CD Rom Drive you are using to install the
> software.  Some large apps dont install properly due
> to the CD Drive's buffer not being large enough to
> handle a continueous feed of data to the HD.
> 
> 4TH:  copy the complete CD to the HD and install from
> the hard drive, if necessary.
> 
> 5TH: Try to install it while in 16-bit mode. (XP
> option)
> 
> good luck dude...
> 
> --- "Lukoni, Bryan AG:EX"
> <[EMAIL PROTECTED]> wrote:
> > 
> > I am unable to install either version MySQL 4.03 or
> > the release MySQL 3.23
> > on a XP professional operating system. No error
> > message is produced, double
> > clicking the setup.exe file only produces a flashing 
> hourglass for a 
> > second and then nothing, no error messages. Suggestions
> > anyone.
> > 
> > Stange thing, is it installed fine on my home
> > computer which is running XP
> > professional.
> > 
> > 
> > -=Bryan=-
> > 
> >
> -
> > 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! Finance - Get real-time stock quotes http://finance.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: Missing an answer to an topic (Finding gaps in db)

[Gelu Gogancea]

Hi,

If you wish to find NUMBERS which are missing, i think you can try
this:
set @a:=0;/*initialise variable a*/
select @a:=@a+1,IF(YOUR_COLUMN_INT_TYPE= @a,'OK',@a:= @a+1) FROM YOUR TABLE;

Don't forget to initialise variable 'a' for every time when run the second
query.
This is work indeed but if you want to have a definitively solution i think
you should to do an UDF where you can make some rules and conditions to
checking what data is missing from the table field(column).
Hope it's help

Regards,

Gelu
_
G.NET SOFTWARE COMPANY

Permanent e-mail address : [EMAIL PROTECTED]
  [EMAIL PROTECTED]
- Original Message -
From: "Jan Broermann" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, September 10, 2002 6:01 AM
Subject: Missing an answer to an topic (Finding gaps in db)


> Hi,
> I'm missing an answer to a topic which came up a couple of days /weeks
ago.
> For a database i'm administrating I would like to find out, which numbers
> (of invoices)
> are missing in our database. Is there a way to get this result set thru
SQL?
> Or do I have to do it with for example Java?
> I think somebody else asked a question similar to my probleme, but I can't
> find
> an answer in my mails. I think it must be a construction of something like
> not in between [max]max(tab.invoice) and [min] min (tab,invoice) 
>
> thx from Germany
> Jan
>
>
> -
> 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

Unable to find MySQL-DBI-perl-bin RPM?

[Paul Laska]

Hello,

I recently started trying to learn MySQL, and toward that goal I thought it
would be a good idea to put it on my Redhat Linux system.  I downloaded all
the RPMs I could find, since I'm still fairly new to Linux and the whole
tarball idea is strange to me.  However when I go to install the
MySQL-bench-3.23.52 RPM I get a problem that it "requires
MySQL-DBI-perl-bin".  I've searched your site, and I can't find the required
RPM.

So, I searched through your manual next, and came up with section 2.7.1
Installing Perl on Unix as the next best answer.  While I haven't gone
through the steps yet, I feel pretty confident that your documentation is
clear, concise and will work with no problems.  But I would still like to
know if there is a MySQL-DBI-perl-bin RPM available on your site, since the
MySQL-bench-3.23.52 RPM  clearly requires it?

Thank you.

Sincerely,
Paul Laska
[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: mysterious disconnects during processing

[Joseph Bueno]

Your db admin should know that ;)
Otherwise, you can do a
mysqladmin variables
and look at 'datadir' value.
In this directory, you should find a file named .err
(see http://www.mysql.com/doc/en/Error_log.html).

Regards
-- 
Joseph Bueno

Derrell Durrett wrote:
> Joseph Bueno wrote:
> 
> 
>>Have you looked at mysql error log file on the server ?
> 
> 
> Where would I find that?
> 
> Derrell
> 
> 
>>Derrell Durrett wrote:
>>
>>>Since I didn't get a response, I tried one of the suggestions here.  See my 
>response to
>>>it below.
>>>
>>>Additionally, I've turned on the environment variables DBI_TRACE and PERL_DBI_DEBUG,
>>>both to level '8'.  This produces voluminous, but not particularly illuminating,
>>>output.  If anyone has a suggestion as to what I should be looking for in the output
>>>that would indicate the source of the problem, please feel free to share that
>>>information.
>>>
>>>If you have any additional suggestions as to things I should try I would be 
>grateful.
>>>FWIW, I have identified how to 'make the errors go away.'  Unfortunately, this comes
>>>solely from no longer performing the inserts into the database.  That's not 
>particularly
>>>useful.
>>>
>>>Derrell Durrett wrote:
>>>
>>>
>>>
walt wrote:



>Derrell Durrett wrote:
>
>
>
>>I'm running server version: 3.22.32, on SunOS 5.6 Generic_105181-17.
>>The code is perl 5.6.1, using DBI and DBD::mysql as the interface.  We
>>have code that prepares a group of statement handles for use in doing
>>various queries and inserts in a loop that is executed anywhere from
>>1-3 times per use of this program.  Another program drives this one,
>>calling it about 150 times.
>>
>>Last week (after I filled the local hard disk on the server), we began
>>to suffer disconnects from the database in these queries and inserts.
>>There is no obvious pattern to the disconnections, and they appear at
>>arbitrary times during the connections, but at approximately the same
>>time for each set of data (some of the shorter datasets are inserted
>>completely).
>>
>>The admin for this db is certain the problem is in the code.  However
>>I can't understand this since that code is unchanged.
>>
>>What should I look for, what should he look for, or what additional
>>information do I need to supply in order to pursue resolving this issue?
>
>Derrell,
>There are a few things I'd check.
>2. In your perl code, are you running ->finish on each query?

No.  If I understand the docs correctly, finish is only useful when all data has
been read from/written to the statement handle.  As the program exits almost
immediately when done with the batch of inserts/queries for a given dataset, this
seems appears unnecessary.  Is my understanding flawed?
>>>
>>>
>>>I've now added these.  There is no effect.  By this I mean that the same errors 
>continue
>>>to occur, at the same location in the process.  There is nothing unusual (that I can
>>>see) in the output from DBI_TRACE.
>>>
>>>
>>>
>4. What error message does perl give you from the db?

"No Database Selected" is the most common one, though it occaisionally returns 
>"Lost
connection to MySQL server during query".



>5. What is the load avg on the db and application server when query/update fails?

Don't know.  Not likely very high.  The host is a Sun Ultra 2.



>6. If the query or update fails, what happens if the perl app sleeps for a few
>seconds and trys again?

Haven't tried this, as it would result in unacceptably long-running programs.
>>>
>>>
>>>I'm going to try to implement this next, even though it cannot be a part of the
>>>production version.  As the errors indicate that the statement handle doesn't 
>connect to
>>>the database any longer, I fail to see how that will produce different results, but 
>I'm
>>>getting desperate here.
>>>
>>>Derrell
>>>
>>>--
>>>Derrell Durrett   Xilinx, Inc.  Productivity Engineering
>>>   Longmont, Colorado
>>>  720.652.3843
>>>
>>>
>>>
>>
> 
> --
> Derrell Durrett   Xilinx, Inc.  Productivity Engineering
>Longmont, Colorado
>   720.652.3843
> 
> 
> 
> 
> -
> 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 

Re: mysterious disconnects during processing

[Derrell Durrett]

Joseph Bueno wrote:

> Have you looked at mysql error log file on the server ?

Where would I find that?

Derrell

>
> Derrell Durrett wrote:
> > Since I didn't get a response, I tried one of the suggestions here.  See my 
>response to
> > it below.
> >
> > Additionally, I've turned on the environment variables DBI_TRACE and 
>PERL_DBI_DEBUG,
> > both to level '8'.  This produces voluminous, but not particularly illuminating,
> > output.  If anyone has a suggestion as to what I should be looking for in the 
>output
> > that would indicate the source of the problem, please feel free to share that
> > information.
> >
> > If you have any additional suggestions as to things I should try I would be 
>grateful.
> > FWIW, I have identified how to 'make the errors go away.'  Unfortunately, this 
>comes
> > solely from no longer performing the inserts into the database.  That's not 
>particularly
> > useful.
> >
> > Derrell Durrett wrote:
> >
> >
> >>walt wrote:
> >>
> >>
> >>>Derrell Durrett wrote:
> >>>
> >>>
> I'm running server version: 3.22.32, on SunOS 5.6 Generic_105181-17.
> The code is perl 5.6.1, using DBI and DBD::mysql as the interface.  We
> have code that prepares a group of statement handles for use in doing
> various queries and inserts in a loop that is executed anywhere from
> 1-3 times per use of this program.  Another program drives this one,
> calling it about 150 times.
> 
> Last week (after I filled the local hard disk on the server), we began
> to suffer disconnects from the database in these queries and inserts.
> There is no obvious pattern to the disconnections, and they appear at
> arbitrary times during the connections, but at approximately the same
> time for each set of data (some of the shorter datasets are inserted
> completely).
> 
> The admin for this db is certain the problem is in the code.  However
> I can't understand this since that code is unchanged.
> 
> What should I look for, what should he look for, or what additional
> information do I need to supply in order to pursue resolving this issue?
> >>>
> >>>Derrell,
> >>>There are a few things I'd check.
> >>>2. In your perl code, are you running ->finish on each query?
> >>
> >>No.  If I understand the docs correctly, finish is only useful when all data has
> >>been read from/written to the statement handle.  As the program exits almost
> >>immediately when done with the batch of inserts/queries for a given dataset, this
> >>seems appears unnecessary.  Is my understanding flawed?
> >
> >
> > I've now added these.  There is no effect.  By this I mean that the same errors 
>continue
> > to occur, at the same location in the process.  There is nothing unusual (that I 
>can
> > see) in the output from DBI_TRACE.
> >
> >
> >>>4. What error message does perl give you from the db?
> >>
> >>"No Database Selected" is the most common one, though it occaisionally returns 
>"Lost
> >>connection to MySQL server during query".
> >>
> >>
> >>>5. What is the load avg on the db and application server when query/update fails?
> >>
> >>Don't know.  Not likely very high.  The host is a Sun Ultra 2.
> >>
> >>
> >>>6. If the query or update fails, what happens if the perl app sleeps for a few
> >>>seconds and trys again?
> >>
> >>Haven't tried this, as it would result in unacceptably long-running programs.
> >
> >
> > I'm going to try to implement this next, even though it cannot be a part of the
> > production version.  As the errors indicate that the statement handle doesn't 
>connect to
> > the database any longer, I fail to see how that will produce different results, 
>but I'm
> > getting desperate here.
> >
> > Derrell
> >
> > --
> > Derrell Durrett   Xilinx, Inc.  Productivity Engineering
> >Longmont, Colorado
> >   720.652.3843
> >
> >
> >

--
Derrell Durrett   Xilinx, Inc.  Productivity Engineering
   Longmont, Colorado
  720.652.3843




-
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: mysterious disconnects during processing

[Joseph Bueno]

Hi,

Have you looked at mysql error log file on the server ?

Regards
-- 
Joseph Bueno

Derrell Durrett wrote:
> Since I didn't get a response, I tried one of the suggestions here.  See my response 
>to
> it below.
> 
> Additionally, I've turned on the environment variables DBI_TRACE and PERL_DBI_DEBUG,
> both to level '8'.  This produces voluminous, but not particularly illuminating,
> output.  If anyone has a suggestion as to what I should be looking for in the output
> that would indicate the source of the problem, please feel free to share that
> information.
> 
> If you have any additional suggestions as to things I should try I would be grateful.
> FWIW, I have identified how to 'make the errors go away.'  Unfortunately, this comes
> solely from no longer performing the inserts into the database.  That's not 
>particularly
> useful.
> 
> Derrell Durrett wrote:
> 
> 
>>walt wrote:
>>
>>
>>>Derrell Durrett wrote:
>>>
>>>
I'm running server version: 3.22.32, on SunOS 5.6 Generic_105181-17.
The code is perl 5.6.1, using DBI and DBD::mysql as the interface.  We
have code that prepares a group of statement handles for use in doing
various queries and inserts in a loop that is executed anywhere from
1-3 times per use of this program.  Another program drives this one,
calling it about 150 times.

Last week (after I filled the local hard disk on the server), we began
to suffer disconnects from the database in these queries and inserts.
There is no obvious pattern to the disconnections, and they appear at
arbitrary times during the connections, but at approximately the same
time for each set of data (some of the shorter datasets are inserted
completely).

The admin for this db is certain the problem is in the code.  However
I can't understand this since that code is unchanged.

What should I look for, what should he look for, or what additional
information do I need to supply in order to pursue resolving this issue?
>>>
>>>Derrell,
>>>There are a few things I'd check.
>>>2. In your perl code, are you running ->finish on each query?
>>
>>No.  If I understand the docs correctly, finish is only useful when all data has
>>been read from/written to the statement handle.  As the program exits almost
>>immediately when done with the batch of inserts/queries for a given dataset, this
>>seems appears unnecessary.  Is my understanding flawed?
> 
> 
> I've now added these.  There is no effect.  By this I mean that the same errors 
>continue
> to occur, at the same location in the process.  There is nothing unusual (that I can
> see) in the output from DBI_TRACE.
> 
> 
>>>4. What error message does perl give you from the db?
>>
>>"No Database Selected" is the most common one, though it occaisionally returns "Lost
>>connection to MySQL server during query".
>>
>>
>>>5. What is the load avg on the db and application server when query/update fails?
>>
>>Don't know.  Not likely very high.  The host is a Sun Ultra 2.
>>
>>
>>>6. If the query or update fails, what happens if the perl app sleeps for a few
>>>seconds and trys again?
>>
>>Haven't tried this, as it would result in unacceptably long-running programs.
> 
> 
> I'm going to try to implement this next, even though it cannot be a part of the
> production version.  As the errors indicate that the statement handle doesn't 
>connect to
> the database any longer, I fail to see how that will produce different results, but 
>I'm
> getting desperate here.
> 
> Derrell
> 
> --
> Derrell Durrett   Xilinx, Inc.  Productivity Engineering
>Longmont, Colorado
>   720.652.3843
> 
> 
> 


-
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: Missing an answer to an topic (Finding gaps in db)

[Paul DuBois]

At 4:54 +0200 9/10/02, Jan Broermann wrote:
>Hi,
>I'm missing an answer to a topic which came up a couple of days /weeks ago.
>For a database i'm administrating I would like to find out, which numbers
>(of invoices)
>are missing in our database. Is there a way to get this result set thru SQL?
>Or do I have to do it with for example Java?
>I think somebody else asked a question similar to my probleme, but I can't
>find
>an answer in my mails. I think it must be a construction of something like
>not in between [max]max(tab.invoice) and [min] min (tab,invoice) 


You need a reference table that lists all the invoice IDs in the range
that you want to check.  Then you can perform a left join of this table
against your invoice table to find non-matching records.

If you have no such reference, then you can select the IDs that do happen
to lie within the range, and apply some programming logic to figure out
which ones aren't there.

>
>thx from Germany
>Jan


-
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 LOGS

[Paul DuBois]

At 7:32 +0100 9/10/02, nick gatsis wrote:
>Does anybody know how to make log files for each of my
>databases?

Log files are not written on a per-database basis.

>Thanx
>
>sql, 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

Re: mySQL on AIX 4.3.3 problem: errmsg.sys missing?

[Xiaolin Zhao]

Hi, 

Yes, it is existing:

ibmaix:/usr/local/mysql # ls -al
./share/mysql/english/errmsg.sys
-rw-r--r--   1 mysqlsystem 12183 Sep 09 17:02
./share/mysql/english/errmsg.sys

The mysqld is run as mysql user. 

That is why I can not understand it. 

Any idea?

Best regards,

Allen Zhao



--- Gerald Clark <[EMAIL PROTECTED]>
wrote:
> Is the file there, and readable by the user 'mysql'
> ?
> 
> Xiaolin Zhao wrote:
> 
> >Hi, All
> >
> >I am trying to make MySQL 4.0.3b work with AIX
> 4.3.3.
> >But whenever I did the `./bin/safe_mysqld &`
> command,
> >I get following error:
> >
> >020910 08:31:33  mysqld started
> >020910  8:31:33  Can't find messagefile
> >'mysql-4.0.3b/share/mysql/english/errmsg.sys'
> >020910  8:31:33  Aborting
> >
> >020910 08:31:33  mysqld ended
> >
> >The mysql is installed under
> /usr/local/mysql-4.0.3b,
> >and /usr/local/mysql is sym link to mysql-4.0.3b. 
> >
> >Can anyone pinpoint what the problem is? TIA
> >
> >Best regards,
> >
> >Allen Zhao
> >
> 
> 


__
Do You Yahoo!?
Yahoo! Finance - Get real-time stock quotes
http://finance.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: mysterious disconnects during processing

[Derrell Durrett]

Since I didn't get a response, I tried one of the suggestions here.  See my response to
it below.

Additionally, I've turned on the environment variables DBI_TRACE and PERL_DBI_DEBUG,
both to level '8'.  This produces voluminous, but not particularly illuminating,
output.  If anyone has a suggestion as to what I should be looking for in the output
that would indicate the source of the problem, please feel free to share that
information.

If you have any additional suggestions as to things I should try I would be grateful.
FWIW, I have identified how to 'make the errors go away.'  Unfortunately, this comes
solely from no longer performing the inserts into the database.  That's not 
particularly
useful.

Derrell Durrett wrote:

> walt wrote:
>
> > Derrell Durrett wrote:
> >
> > > I'm running server version: 3.22.32, on SunOS 5.6 Generic_105181-17.
> > > The code is perl 5.6.1, using DBI and DBD::mysql as the interface.  We
> > > have code that prepares a group of statement handles for use in doing
> > > various queries and inserts in a loop that is executed anywhere from
> > > 1-3 times per use of this program.  Another program drives this one,
> > > calling it about 150 times.
> > >
> > > Last week (after I filled the local hard disk on the server), we began
> > > to suffer disconnects from the database in these queries and inserts.
> > > There is no obvious pattern to the disconnections, and they appear at
> > > arbitrary times during the connections, but at approximately the same
> > > time for each set of data (some of the shorter datasets are inserted
> > > completely).
> > >
> > > The admin for this db is certain the problem is in the code.  However
> > > I can't understand this since that code is unchanged.
> > >
> > > What should I look for, what should he look for, or what additional
> > > information do I need to supply in order to pursue resolving this issue?
> >
> > Derrell,
> > There are a few things I'd check.
> > 2. In your perl code, are you running ->finish on each query?
>
> No.  If I understand the docs correctly, finish is only useful when all data has
> been read from/written to the statement handle.  As the program exits almost
> immediately when done with the batch of inserts/queries for a given dataset, this
> seems appears unnecessary.  Is my understanding flawed?

I've now added these.  There is no effect.  By this I mean that the same errors 
continue
to occur, at the same location in the process.  There is nothing unusual (that I can
see) in the output from DBI_TRACE.

> > 4. What error message does perl give you from the db?
>
> "No Database Selected" is the most common one, though it occaisionally returns "Lost
> connection to MySQL server during query".
>
> > 5. What is the load avg on the db and application server when query/update fails?
>
> Don't know.  Not likely very high.  The host is a Sun Ultra 2.
>
> > 6. If the query or update fails, what happens if the perl app sleeps for a few
> > seconds and trys again?
>
> Haven't tried this, as it would result in unacceptably long-running programs.

I'm going to try to implement this next, even though it cannot be a part of the
production version.  As the errors indicate that the statement handle doesn't connect 
to
the database any longer, I fail to see how that will produce different results, but I'm
getting desperate here.

Derrell

--
Derrell Durrett   Xilinx, Inc.  Productivity Engineering
   Longmont, Colorado
  720.652.3843




-
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: Confused, discombobulated, weirded out, upset! --Windowsstandalone user

[Paul DuBois]

At 23:52 +0800 9/10/02, Uriel Wittenberg wrote:
>  >If mysql works fine, then you've already started the server.
>
>Then does a normal Windows installation set it up so the server autostarts
>whenever you boot up? I did not manually start the server.

It might be installed as a service.

>  >You have to restart the server before it will notice the [mysqld] option
>group change.
>
>After I added local-infile=1 in the [mysqld] and [mysql] sections, the LOAD
>DATA LOCAL INFILE command started working. I did not do anything to shut
>down and restart the server.


I don't understand.  In your previous message, you said:

At 23:37 +0800 9/10/02, Uriel Wittenberg wrote:
>
>Also, per advice here, I tried putting local-infile=1 in the [mysqld] and
>[mysql] sections of my.cnf(my.ini), but that does not change the behavior.
>

Which seems to contradict what you're saying now.

-
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: Confused, discombobulated, weirded out, upset! --Windows standalone user

[Uriel Wittenberg]

>If mysql works fine, then you've already started the server.

Then does a normal Windows installation set it up so the server autostarts
whenever you boot up? I did not manually start the server.

>You have to restart the server before it will notice the [mysqld] option
group change.

After I added local-infile=1 in the [mysqld] and [mysql] sections, the LOAD
DATA LOCAL INFILE command started working. I did not do anything to shut
down and restart the server.



-
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: Re: LOAD DATA LOCAL INFILE "not allowed this version"?

[Uriel Wittenberg]

THANKS VERY MUCH! That worked!

- Original Message - 
From: "Victoria Reznichenko" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, September 10, 2002 9:15 PM
Subject: re: Re: LOAD DATA LOCAL INFILE "not allowed this version"?


[.]

Put local-infile=1 in the [mysqld] and [mysql] section of
my.cnf(my.ini)




-
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: Confused, discombobulated, weirded out, upset! --Windows standalone user

[Uriel Wittenberg]

Sorry! I made a mistake here. I still have the questions below but my
problem with LOAD DATA is SOLVED! I made an editing mistake when updating
the my.cnf(my.ini) files.

- Original Message -
From: "Uriel Wittenberg" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, September 10, 2002 11:37 PM
Subject: Confused, discombobulated, weirded out, upset! --Windows standalone
user


I seem to have a version problem. I'm using v. 3.23.51 on a Windows
standalone system -- there is no network here. *ALL I want* is to run MySQL
standalone on this machine. So do I need to "start the server"? MySQL seems
to mostly work fine if I just go and do:

C:\mysql\bin> mysql

without "starting the server."

The manual's Windows directions seem to assume a network situation, which is
not my case.

Also of concern is that when I inquire about version as follows I get "for
Win95/Win98" although I'm using Win XP (Home).


C:\mysql\bin>mysql --version
mysql  Ver 11.18 Distrib 3.23.51, for Win95/Win98 (i32)

C:\mysql\bin>mysqld --version
mysqld  Ver 3.23.51-max-debug for Win95/Win98 on i32


[.]


-
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.2, 4.0.3,4.0.4 replication circle broken.

[Paul DuBois]

At 12:09 +0400 9/10/02, Artem V. Ryabov wrote:
>Hello Victoria,
>
>   As far as I see bug of muliple log files still not fixed regardless
>   of last change in 4.0.4:
>   'FLUSH LOGS removed numerical extension for all future update logs.'

This bugfix affects the update log, not the binary update log.  It
has no effect on replication.

>
>--
>Best regards,
>  Artem  mailto:[EMAIL PROTECTED]
>
>sql 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

Re: MySQL Monitoring Alerts

[Eric Lamendola]

Mike,

I totally agree.  The log solution wasn't my idea though .

No matter what language you write the script in, any type of ""Get some 
kind of response by throwing something against the server and seeing if it 
sticks"" response will get you the information you need.

I set up a dummy account and use a simple shell with a "mysqladmin status" 
command.  Works fine for me.  This just lets me know whether the server is 
up or down.

Your way would work well also, because if you have to get a "data 
response", it would probably provide greater detail as to the status and 
response time of the server.

If not - hey what do I know 

Eric Lamendola




At 10:26 AM 9/10/02 -0500, mos wrote:
>Eric,
> Isn't letting an outside connection access to your log file a 
> "little dangerous"?  Why not create a dummy table with just one record in 
> it, restrict it to read access only, then use your chron job on a remote 
> computer to run a PHP/Perl script to access that record over the net. If 
> it returns an error, then examine the error number to determine what the 
> problem is. (Maybe the connection is down, or the database is down.) 
> There may be better ways to do it but this should be more secure.
>
>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: Confused, discombobulated, weirded out, upset! --Windowsstandalone user

[Paul DuBois]

At 23:37 +0800 9/10/02, Uriel Wittenberg wrote:
>I seem to have a version problem. I'm using v. 3.23.51 on a Windows
>standalone system -- there is no network here. *ALL I want* is to run MySQL
>standalone on this machine. So do I need to "start the server"? MySQL seems
>to mostly work fine if I just go and do:
>
>C:\mysql\bin> mysql
>
>without "starting the server."

If mysql works fine, then you've already started the server.

Yes, you need a server.  It can run on the same machine as the client
programs, though, which is your situation.

>
>The manual's Windows directions seem to assume a network situation, which is
>not my case.
>
>Also of concern is that when I inquire about version as follows I get "for
>Win95/Win98" although I'm using Win XP (Home).
>
>
>C:\mysql\bin>mysql --version
>mysql  Ver 11.18 Distrib 3.23.51, for Win95/Win98 (i32)
>
>C:\mysql\bin>mysqld --version
>mysqld  Ver 3.23.51-max-debug for Win95/Win98 on i32
>
>
>One thing that's currently NOT working is the following command:
>
>
>LOAD DATA LOCAL INFILE "C:\\MO10.txt"
>INTO TABLE stud1
>fields terminated by "/"
>lines terminated by '\r\n';
>
>
>That produces:
>
>"ERROR 1148 at line 1: The used command is not allowed with this MySQL
>version."
>
>That's what's making me wonder about version issues. I've checked the manual
>and see no other reason for that message.
>
>Also, per advice here, I tried putting local-infile=1 in the [mysqld] and
>[mysql] sections of my.cnf(my.ini), but that does not change the behavior.

You have to restart the server before it will notice the [mysqld] option
group change.

>
>Help would be appreciated!
>
>Uriel


-
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

Confused, discombobulated, weirded out, upset! --Windows standalone user

[Uriel Wittenberg]

I seem to have a version problem. I'm using v. 3.23.51 on a Windows
standalone system -- there is no network here. *ALL I want* is to run MySQL
standalone on this machine. So do I need to "start the server"? MySQL seems
to mostly work fine if I just go and do:

C:\mysql\bin> mysql

without "starting the server."

The manual's Windows directions seem to assume a network situation, which is
not my case.

Also of concern is that when I inquire about version as follows I get "for
Win95/Win98" although I'm using Win XP (Home).


C:\mysql\bin>mysql --version
mysql  Ver 11.18 Distrib 3.23.51, for Win95/Win98 (i32)

C:\mysql\bin>mysqld --version
mysqld  Ver 3.23.51-max-debug for Win95/Win98 on i32


One thing that's currently NOT working is the following command:


LOAD DATA LOCAL INFILE "C:\\MO10.txt"
INTO TABLE stud1
   fields terminated by "/"
   lines terminated by '\r\n';


That produces:

"ERROR 1148 at line 1: The used command is not allowed with this MySQL
version."

That's what's making me wonder about version issues. I've checked the manual
and see no other reason for that message.

Also, per advice here, I tried putting local-infile=1 in the [mysqld] and
[mysql] sections of my.cnf(my.ini), but that does not change the behavior.

Help would be appreciated!

Uriel




-
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 Monitoring Alerts

[mos]

Eric,
 Isn't letting an outside connection access to your log file a 
"little dangerous"?  Why not create a dummy table with just one record in 
it, restrict it to read access only, then use your chron job on a remote 
computer to run a PHP/Perl script to access that record over the net. If it 
returns an error, then examine the error number to determine what the 
problem is. (Maybe the connection is down, or the database is down.) There 
may be better ways to do it but this should be more secure.

Mike


At 08:06 AM 9/10/2002, you wrote:
>Hey,
>
>I noticed another response about "tailing the log" and looking for 
>information in the "err" log which looks like a great solution.
>
>However, if you have an extra computer laying around, you can also set up 
>a cron job with a shell script that connects to the server (via telnet or 
>using a mysql client to connect) and checks the output.  Then quickly 
>disconnects so as not to tie up a connection.
>
>If the connection is refused or unavailable, then the server is not 
>responding.  You could even put in some extra lines in the script for 
>checking more than once to see if it was a fluke the first time.
>
>This would be a little more real time and allows you to set the frequency 
>in which you want to monitor the server.  Plus, you could set the script 
>to Email you if the server isnt working.
>
>If not - hey what do I know 
>
>Eric Lamendola
>
>At 10:04 AM 9/10/02 +0100, Tom Freeman wrote:
>>Hi,
>>I hope this question hasn't been asked loads of times before but I can't see
>>any reference to it in the documentation.
>>Basically I need a way to monitor MySQL to ensure it hasn't gone down. We
>>are using MySQL as the backend of some important sites and need to ensure
>>that if it does crash for whatever reason, an alert (email and SMS) is sent
>>out to an engineer to resolve the problem.
>>
>>We are presently using a program known as NetSaint to monitor our services
>>but it sometimes doesn't seem to be 100% reliable at detecting a MySQL
>>error.
>>
>>Anyway, can anyone tell me a better way to monitor MySQL so that if it has
>>any problems an oncall engineer can respond quickly. I'm sure this must be a
>>common problem so there must be something out there already.
>>
>>Many thanks,
>>Tom
>>
>>
>>-
>>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: MySQL Monitoring Tool

[Jeremy Tinley]

Tom,

What type of problems AREN'T you detecting?

I'd take a wild guess and say you're only checking MySQL every 5 minutes
or so.  You can decrease the frequency between checks for more updated
status.  There are two variables that you need to look at:

normal_check_interval, which is part of the services.cfg file.  This
determines how often to check your host.  The second is interval_length
in the nagios.cfg file.

normal_check_interval * interval_length = time between checks in s.

We decreased interval_length from 60 to 30, so each interval was 30
seconds instead of 60.  This cuts the time between checks in half across
the board.

-J

-Original Message-
From: Tom Freeman [mailto:[EMAIL PROTECTED]] 
Sent: Tuesday, September 10, 2002 5:04 AM
To: [EMAIL PROTECTED]
Subject: MySQL Monitoring Tool

Hi,
I hope this question hasn't been asked loads of times before but I can't
see
any reference to it in the documentation.
Basically I need a way to monitor MySQL to ensure it hasn't gone down.
We
are using MySQL as the backend of some important sites and need to
ensure
that if it does crash for whatever reason, an alert (email and SMS) is
sent
out to an engineer to resolve the problem.

We are presently using a program known as NetSaint to monitor our
services
but it sometimes doesn't seem to be 100% reliable at detecting a MySQL
error.

Anyway, can anyone tell me a better way to monitor MySQL so that if it
has
any problems an oncall engineer can respond quickly. I'm sure this must
be a
common problem so there must be something out there already.

Many thanks,
Tom



-
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: Goodday

[Markus Gieppner]

Yeah, you missed this: http://home.rica.net/alphae/419coal/

It's a really old, particulary disgusting and quite successful scam.

Markus




-Original Message-
From: Andrew Pickett [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, September 10, 2002 10:03 AM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: Re: Goodday


Hitch free? Incredible, in that case I'll give you all my personal bank
details.
I can't lose!
Am I a sucker or did I miss something here.

Ocita Gabriel wrote:

> Attn: mysql ,
>
> My name is Ocita G, the manager, credit
> and foreign bills of Ecobank Plc. I am writing in
> respect of a foreign customer of my bank with account
> number 14-255-2004/utb/t who perished in a plane crash
> [Korean Air Flight 801] with the whole passengers
> aboard on August 6, 1997.
>
> Since the demise of this our customer, I personally
> has watched with keen interest to see the next of kin
> but all has proved abortive as no one has come to
> claim his funds of usd.20.5 m, [twenty million five
> hundred thousand united states dollars] which has been
> with my branch for a very long time.
> On this note, I decided to seek for whom his name
> shall be used as the next of kin as no one has come up
> to be the next of kin. And the banking ethics here
> does not allow such money to stay more than Six
> years, because money will be recalled to the bank
> treasury as unclaimed after this period.   In view of
> this I got your contact through a trade journal after
> realizing that your name and country is similar to the
> deceased. I will give you 25% of the total.
>
> Upon the receipt of your response, I will send you by
> fax or e-mail the application, bank's fax number and
> the next step to take. I will not fail to bring to
> your notice that this business is hitch free and that
> you should not entertain any fear as all modalities
> for fund transfer can be finalized within five banking
> days, after you apply to the bank as a relation to the
> deceased.
>
> When you receive this letter. Kindly send me an e-mail
> signifying
> Your decision including your private Tel/Fax numbers
> for quick communication.
>
> Respectfully submitted,
>
> Ocita G.
>
> -
> 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


---
Incoming mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.385 / Virus Database: 217 - Release Date: 9/4/2002

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.385 / Virus Database: 217 - Release Date: 9/4/2002


-
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 Monitoring Tool

[Ken Menzel]

Hi Tom,
   If you are not happy with netsaint you might want to try
http://jfontain.free.fr/moodss/index.html .
I do not use this,  however I understand alot of work has gone into
it.

I am curious as to why you say:

> We are presently using a program known as NetSaint to monitor our
services
> but it sometimes doesn't seem to be 100% reliable at detecting a
MySQL
> error.

Because we use netsaint and have found it very reliable,  (but maybe
it works better on FreeBSD :)

MySQL OK 09-10-2002 10:32:15 49d 11h 10m 18s 1/3 Version
3.23.51-log -- 102 Threads
Uptime 39 days 12 hours 53 min 27 sec

Are you using the MySQL plugin.  What version of netsaint are you
using?  The latest netsaint is now called Nagios.  What errors are you
trying to detect?  It is only meant to monitor if MySQL is up/down.
Errors do not get tracked with netsaint, only up/down time (try Moodss
for charts of errors!).

This along with load monitoring using the NRPE utility and MRTG to
chart query usage gives us some great information.

Hope some of this helps you.

Best of luck,
Ken

- Original Message -
From: "Tom Freeman" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, September 10, 2002 6:03 AM
Subject: MySQL Monitoring Tool


> Hi,
> I hope this question hasn't been asked loads of times before but I
can't see
> any reference to it in the documentation.
> Basically I need a way to monitor MySQL to ensure it hasn't gone
down. We
> are using MySQL as the backend of some important sites and need to
ensure
> that if it does crash for whatever reason, an alert (email and SMS)
is sent
> out to an engineer to resolve the problem.
>
> We are presently using a program known as NetSaint to monitor our
services
> but it sometimes doesn't seem to be 100% reliable at detecting a
MySQL
> error.
>
> Anyway, can anyone tell me a better way to monitor MySQL so that if
it has
> any problems an oncall engineer can respond quickly. I'm sure this
must be a
> common problem so there must be something out there already.
>
> Many thanks,
> Tom
>
>
>
> 
-
> 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

deleting frequently = OK?

[Erick Papadakis]

hello

  sql, query 

for various reasons, i need to do a cron job that will take a snapshot of
table1 (by snapshot i mean a temporary table), do some processing, and
then save some scientific calculations to table2. after this, i need to
"refresh" table1 -- i.e., truncate it entirely. i need to do this every 5
minutes so that table1 is "rotated" every 5 mins after my scientific
calculations off it.  

my question is: does this have a negative impact on the table1 since it
is being truncated every 5 minutes? That is roughly about 
  
365 days * 24 hours * 12 times 
 =  105,120 times a year !!!


my questions: 

1. is there something else i can do? i considered writing text files
instead of the DB, but then the 'processing' becomes a lot more
complicated. 

2. i considered making this special table1 in a separate tablespace ...

   2a. would a different database be a different "table space" in mysql?
   2b. would this help at all?

would appreciate any insight/advice. 

thanks/erick





__
Yahoo! - We Remember
9-11: A tribute to the more than 3,000 lives lost
http://dir.remember.yahoo.com/tribute

-
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: Processing the join

[Brent Baisley]

It depends on your database & query structure and especially what 
indexes are available. If you just put "explain" in front of your query 
you will be able to see how mysql will execute your query.

On Tuesday, September 10, 2002, at 09:45 AM, Toni Strandell wrote:

>
> How does MySQL process a join between tables? Does it always use
> nested-loop join, or does it use sort-merge join if the table is sorted
> before joining it? Is the join algorithm merge if the tables are already
> sorted on the join attributes (through an index)?
>
> Sincerely,
>  Toni Strandell
>
> -
> 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
>
>
--
Brent Baisley
Systems Architect
Landover Associates, Inc.
Search & Advisory Services for Advanced Technology Environments
p: 212.759.6400/800.759.0577


-
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: Goodday

[Chuck Payne]

'mysql' there need to be a better filter. Yes, We get this letter 20 times a
weeks. I will forward this on to the FBI to add to their list.

-Original Message-
From: Clive Smart [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, September 10, 2002 9:55 AM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: Re: Goodday


How did this get past the filters?

Ocita Gabriel wrote:
> Attn: mysql ,
>
> My name is Ocita G, the manager, credit
> and foreign bills of Ecobank Plc. I am writing in
> respect of a foreign customer of my bank with account
> number 14-255-2004/utb/t who perished in a plane crash
> [Korean Air Flight 801] with the whole passengers
> aboard on August 6, 1997.
>
> Since the demise of this our customer, I personally
> has watched with keen interest to see the next of kin
> but all has proved abortive as no one has come to
> claim his funds of usd.20.5 m, [twenty million five
> hundred thousand united states dollars] which has been
> with my branch for a very long time.
> On this note, I decided to seek for whom his name
> shall be used as the next of kin as no one has come up
> to be the next of kin. And the banking ethics here
> does not allow such money to stay more than Six
> years, because money will be recalled to the bank
> treasury as unclaimed after this period.   In view of
> this I got your contact through a trade journal after
> realizing that your name and country is similar to the
> deceased. I will give you 25% of the total.
>
> Upon the receipt of your response, I will send you by
> fax or e-mail the application, bank's fax number and
> the next step to take. I will not fail to bring to
> your notice that this business is hitch free and that
> you should not entertain any fear as all modalities
> for fund transfer can be finalized within five banking
> days, after you apply to the bank as a relation to the
> deceased.
>
> When you receive this letter. Kindly send me an e-mail
> signifying
> Your decision including your private Tel/Fax numbers
> for quick communication.
>
> Respectfully submitted,
>
> Ocita G.
>
>
>
>
>
>
> -
> 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
>
>
> .
>


--
  
|  _  __  ___    |
| | |/ / ___/ __ \/ ___| Clive W. Smart  |
| | |   / / /__/ /_/ / / R & D Director  |
| | |/|/ / ___/ __  |\_ \WEBServ a div.  |
| | / /__/ /_/ /__/ /of Melange Hold |
| |_/|_//_//ERV  [EMAIL PROTECTED] |
||
| Tel: +27 11 372-9800  Fax: +27 11 372-9801 |
||



-
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: Goodday

[Rick Cronan]

> -Original Message-
> From: Andrew Pickett [mailto:[EMAIL PROTECTED]]
>
>
> Hitch free? Incredible, in that case I'll give you all
> my personal bank details.
> I can't lose!
> Am I a sucker or did I miss something here.

As I understand it, they start by requesting that you finance some bank
operations to the tune of a couple of hundred dollars.  If you're sucker
enough to go for that, they tell you they need to meet face to face, and
either get you to pay for their airfare, or get you to go to them, at
which point they go for a good, old-fashioned, 'pointing a gun at you'
style stick up.

And apparently mysql is a name similar to that of their ex-client.

Odd fella.

- rick


-
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: Goodday

[Keith Burke [Experience IT]]

Don't reply or they'll get your Email address. ;-)





Regards

**
*   K   e   i   t   h   B   u   r   k   e*
**
* Experience IT Ltd   * Phone : +353 1 xxx   *
* Unit G6 * GSM   : +353 86 xxx  *
* Riverview Business Park * Email : [EMAIL PROTECTED] *
* New Nangor Road * WWW   : http://www.experience.ie *
* Dublin 12   *  *
* Ireland *  *
**


-Original Message-
From: Weaver, Walt [mailto:[EMAIL PROTECTED]] 
Sent: 10 September 2002 14:59
To: [EMAIL PROTECTED]
Subject: RE: Goodday


This must be a great scam. I'm starting to see'em all over the place.

--Walt

-Original Message-
From: Ocita Gabriel [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, September 10, 2002 3:53 PM
To: [EMAIL PROTECTED]
Subject: Goodday


Attn: mysql ,

My name is Ocita G, the manager, credit
and foreign bills of Ecobank Plc. I am writing in
respect of a foreign customer of my bank with account
number 14-255-2004/utb/t who perished in a plane crash
[Korean Air Flight 801] with the whole passengers
aboard on August 6, 1997.

Since the demise of this our customer, I personally
has watched with keen interest to see the next of kin
but all has proved abortive as no one has come to
claim his funds of usd.20.5 m, [twenty million five
hundred thousand united states dollars] which has been
with my branch for a very long time. 
On this note, I decided to seek for whom his name
shall be used as the next of kin as no one has come up
to be the next of kin. And the banking ethics here
does not allow such money to stay more than Six
years, because money will be recalled to the bank
treasury as unclaimed after this period.   In view of
this I got your contact through a trade journal after
realizing that your name and country is similar to the deceased. I will
give you 25% of the total.

Upon the receipt of your response, I will send you by
fax or e-mail the application, bank's fax number and
the next step to take. I will not fail to bring to
your notice that this business is hitch free and that
you should not entertain any fear as all modalities
for fund transfer can be finalized within five banking
days, after you apply to the bank as a relation to the deceased.

When you receive this letter. Kindly send me an e-mail signifying 
Your decision including your private Tel/Fax numbers
for quick communication. 

Respectfully submitted,

Ocita G.






-
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: Goodday

[Justin French]

I think the only filters on this list are that it must contain 'sql' or
'query'... The message starts with 'Attn: mysql', so I guess it got thru.

Justin


on 10/09/02 11:55 PM, Clive Smart ([EMAIL PROTECTED]) wrote:

> How did this get past the filters?
> 
> Ocita Gabriel wrote:
>> Attn: mysql ,
>> 
>> My name is Ocita G, the manager, credit
>> and foreign bills of Ecobank Plc. I am writing in
>> respect of a foreign customer of my bank with account
>> number 14-255-2004/utb/t who perished in a plane crash
>> [Korean Air Flight 801] with the whole passengers
>> aboard on August 6, 1997.
>> 
>> Since the demise of this our customer, I personally
>> has watched with keen interest to see the next of kin
>> but all has proved abortive as no one has come to
>> claim his funds of usd.20.5 m, [twenty million five
>> hundred thousand united states dollars] which has been
>> with my branch for a very long time.
>> On this note, I decided to seek for whom his name
>> shall be used as the next of kin as no one has come up
>> to be the next of kin. And the banking ethics here
>> does not allow such money to stay more than Six
>> years, because money will be recalled to the bank
>> treasury as unclaimed after this period.   In view of
>> this I got your contact through a trade journal after
>> realizing that your name and country is similar to the
>> deceased. I will give you 25% of the total.
>> 
>> Upon the receipt of your response, I will send you by
>> fax or e-mail the application, bank's fax number and
>> the next step to take. I will not fail to bring to
>> your notice that this business is hitch free and that
>> you should not entertain any fear as all modalities
>> for fund transfer can be finalized within five banking
>> days, after you apply to the bank as a relation to the
>> deceased.
>> 
>> When you receive this letter. Kindly send me an e-mail
>> signifying 
>> Your decision including your private Tel/Fax numbers
>> for quick communication.
>> 
>> Respectfully submitted,
>> 
>> Ocita G.
>> 
>> 
>> 
>> 
>> 
>> 
>> -
>> 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: Goodday

[Iikka Meriläinen]

Simply having that Attn: mysql , row in it. The word 'mysql' passes
through the filter. Not making that Ocita G less of an idiot, though.

On Tue, 10 Sep 2002, Clive Smart wrote:

> How did this get past the filters?
>
> Ocita Gabriel wrote:
> > Attn: mysql ,
> >
> > My name is Ocita G, the manager, credit
> > and foreign bills of Ecobank Plc. I am writing in
> > respect of a foreign customer of my bank with account
> > number 14-255-2004/utb/t who perished in a plane crash
> > [Korean Air Flight 801] with the whole passengers
> > aboard on August 6, 1997.
> >
> > Since the demise of this our customer, I personally
> > has watched with keen interest to see the next of kin
> > but all has proved abortive as no one has come to
> > claim his funds of usd.20.5 m, [twenty million five
> > hundred thousand united states dollars] which has been
> > with my branch for a very long time.
> > On this note, I decided to seek for whom his name
> > shall be used as the next of kin as no one has come up
> > to be the next of kin. And the banking ethics here
> > does not allow such money to stay more than Six
> > years, because money will be recalled to the bank
> > treasury as unclaimed after this period.   In view of
> > this I got your contact through a trade journal after
> > realizing that your name and country is similar to the
> > deceased. I will give you 25% of the total.
> >
> > Upon the receipt of your response, I will send you by
> > fax or e-mail the application, bank's fax number and
> > the next step to take. I will not fail to bring to
> > your notice that this business is hitch free and that
> > you should not entertain any fear as all modalities
> > for fund transfer can be finalized within five banking
> > days, after you apply to the bank as a relation to the
> > deceased.
> >
> > When you receive this letter. Kindly send me an e-mail
> > signifying
> > Your decision including your private Tel/Fax numbers
> > for quick communication.
> >
> > Respectfully submitted,
> >
> > Ocita G.
> >
> >
> >
> >
> >
> >
> > -
> > 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
> >
> >
> > .
> >
>
>
> --
>   
> |  _  __  ___    |
> | | |/ / ___/ __ \/ ___| Clive W. Smart  |
> | | |   / / /__/ /_/ / / R & D Director  |
> | | |/|/ / ___/ __  |\_ \WEBServ a div.  |
> | | / /__/ /_/ /__/ /of Melange Hold |
> | |_/|_//_//ERV  [EMAIL PROTECTED] |
> ||
> | Tel: +27 11 372-9800  Fax: +27 11 372-9801 |
> ||
>
>
>
> -
> 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
>

**
* Iikka Meriläinen   *
* E-mail: [EMAIL PROTECTED] *
* Vaala, Finland *
**


-
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: Goodday

[Andrew Pickett]

Hitch free? Incredible, in that case I'll give you all my personal bank details.
I can't lose!
Am I a sucker or did I miss something here.

Ocita Gabriel wrote:

> Attn: mysql ,
>
> My name is Ocita G, the manager, credit
> and foreign bills of Ecobank Plc. I am writing in
> respect of a foreign customer of my bank with account
> number 14-255-2004/utb/t who perished in a plane crash
> [Korean Air Flight 801] with the whole passengers
> aboard on August 6, 1997.
>
> Since the demise of this our customer, I personally
> has watched with keen interest to see the next of kin
> but all has proved abortive as no one has come to
> claim his funds of usd.20.5 m, [twenty million five
> hundred thousand united states dollars] which has been
> with my branch for a very long time.
> On this note, I decided to seek for whom his name
> shall be used as the next of kin as no one has come up
> to be the next of kin. And the banking ethics here
> does not allow such money to stay more than Six
> years, because money will be recalled to the bank
> treasury as unclaimed after this period.   In view of
> this I got your contact through a trade journal after
> realizing that your name and country is similar to the
> deceased. I will give you 25% of the total.
>
> Upon the receipt of your response, I will send you by
> fax or e-mail the application, bank's fax number and
> the next step to take. I will not fail to bring to
> your notice that this business is hitch free and that
> you should not entertain any fear as all modalities
> for fund transfer can be finalized within five banking
> days, after you apply to the bank as a relation to the
> deceased.
>
> When you receive this letter. Kindly send me an e-mail
> signifying
> Your decision including your private Tel/Fax numbers
> for quick communication.
>
> Respectfully submitted,
>
> Ocita G.
>
> -
> 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: Goodday

[Weaver, Walt]

This must be a great scam. I'm starting to see'em all over the place.

--Walt

-Original Message-
From: Ocita Gabriel [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, September 10, 2002 3:53 PM
To: [EMAIL PROTECTED]
Subject: Goodday


Attn: mysql ,

My name is Ocita G, the manager, credit
and foreign bills of Ecobank Plc. I am writing in
respect of a foreign customer of my bank with account
number 14-255-2004/utb/t who perished in a plane crash
[Korean Air Flight 801] with the whole passengers
aboard on August 6, 1997.

Since the demise of this our customer, I personally
has watched with keen interest to see the next of kin
but all has proved abortive as no one has come to
claim his funds of usd.20.5 m, [twenty million five
hundred thousand united states dollars] which has been
with my branch for a very long time. 
On this note, I decided to seek for whom his name
shall be used as the next of kin as no one has come up
to be the next of kin. And the banking ethics here
does not allow such money to stay more than Six
years, because money will be recalled to the bank
treasury as unclaimed after this period.   In view of
this I got your contact through a trade journal after
realizing that your name and country is similar to the
deceased. I will give you 25% of the total.

Upon the receipt of your response, I will send you by
fax or e-mail the application, bank's fax number and
the next step to take. I will not fail to bring to
your notice that this business is hitch free and that
you should not entertain any fear as all modalities
for fund transfer can be finalized within five banking
days, after you apply to the bank as a relation to the
deceased.

When you receive this letter. Kindly send me an e-mail
signifying 
Your decision including your private Tel/Fax numbers
for quick communication. 

Respectfully submitted,

Ocita G.






-
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: Goodday

[Clive Smart]

How did this get past the filters?

Ocita Gabriel wrote:
> Attn: mysql ,
> 
> My name is Ocita G, the manager, credit
> and foreign bills of Ecobank Plc. I am writing in
> respect of a foreign customer of my bank with account
> number 14-255-2004/utb/t who perished in a plane crash
> [Korean Air Flight 801] with the whole passengers
> aboard on August 6, 1997.
> 
> Since the demise of this our customer, I personally
> has watched with keen interest to see the next of kin
> but all has proved abortive as no one has come to
> claim his funds of usd.20.5 m, [twenty million five
> hundred thousand united states dollars] which has been
> with my branch for a very long time. 
> On this note, I decided to seek for whom his name
> shall be used as the next of kin as no one has come up
> to be the next of kin. And the banking ethics here
> does not allow such money to stay more than Six
> years, because money will be recalled to the bank
> treasury as unclaimed after this period.   In view of
> this I got your contact through a trade journal after
> realizing that your name and country is similar to the
> deceased. I will give you 25% of the total.
> 
> Upon the receipt of your response, I will send you by
> fax or e-mail the application, bank's fax number and
> the next step to take. I will not fail to bring to
> your notice that this business is hitch free and that
> you should not entertain any fear as all modalities
> for fund transfer can be finalized within five banking
> days, after you apply to the bank as a relation to the
> deceased.
> 
> When you receive this letter. Kindly send me an e-mail
> signifying 
> Your decision including your private Tel/Fax numbers
> for quick communication. 
> 
> Respectfully submitted,
> 
> Ocita G.
> 
> 
> 
> 
> 
> 
> -
> 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
> 
> 
> .
> 


-- 
  
|  _  __  ___    |
| | |/ / ___/ __ \/ ___| Clive W. Smart  |
| | |   / / /__/ /_/ / / R & D Director  |
| | |/|/ / ___/ __  |\_ \WEBServ a div.  |
| | / /__/ /_/ /__/ /of Melange Hold |
| |_/|_//_//ERV  [EMAIL PROTECTED] |
||
| Tel: +27 11 372-9800  Fax: +27 11 372-9801 |
||



-
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: Cannot create Full-Text INDEX

[Pekka Saarinen]

At 9/9/2002, you wrote:
>Dear all,
>I have installed mysql 4.0.2 alpha log (actually compiled by me) in a 
>linux box (Mandrake 8.2) and for 2 months was working perfectly. After 
>migrating some data from an other installation (Windows 2000 / mysql 4.0.1 
>alpha log) my FULL-TEXT indexes stop functioning. I am issuing the 
>following statement but no FULL-TEXT index is created.
>DROP TABLE IF EXISTS e_genlogmatergroup;
>CREATE TABLE `e_genlogmatergroup` (
>   `genlogmatergroupid` decimal(10,0) NOT NULL default '0',
>   `genlogmatergrouptitle` text,
>   `genlogmatergroupcont` text,
>   `genlogmatergroupparent` decimal(10,0) default '0',
>   `chapter` varchar(255) default NULL,
>   `genlogmatergroup` varchar(255) default NULL,
>   `genlogmaterdateins` date default NULL,
>   `infopg` tinyint(3) unsigned default '0',
>   PRIMARY KEY  (`genlogmatergroupid`),
>   FULLTEXT KEY `genlogmatergrouptitle` (`genlogmatergrouptitle`),
>   FULLTEXT KEY `genlogmatergroupcont` (`genlogmatergroupcont`),
>   FULLTEXT KEY `compound_e_genlogmatergroup` 
> (`genlogmatergroupcont`,`genlogmatergrouptitle`)
>) TYPE=MyISAM;
>
>Any Ideas??
>Thanks in advance


Try

OPTIMIZE TABLE `e_genlogmatergroup`

This should get indexes running (you need to have a couple of rows of data 
there first).



-
Pekka Saarinen
http://photography-on-the.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 on AIX 4.3.3 problem: errmsg.sys missing?

[Gerald Clark]

Is the file there, and readable by the user 'mysql' ?

Xiaolin Zhao wrote:

>Hi, All
>
>I am trying to make MySQL 4.0.3b work with AIX 4.3.3.
>But whenever I did the `./bin/safe_mysqld &` command,
>I get following error:
>
>020910 08:31:33  mysqld started
>020910  8:31:33  Can't find messagefile
>'mysql-4.0.3b/share/mysql/english/errmsg.sys'
>020910  8:31:33  Aborting
>
>020910 08:31:33  mysqld ended
>
>The mysql is installed under /usr/local/mysql-4.0.3b,
>and /usr/local/mysql is sym link to mysql-4.0.3b. 
>
>Can anyone pinpoint what the problem is? TIA
>
>Best regards,
>
>Allen Zhao
>



-
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

Goodday

[Ocita Gabriel]

Attn: mysql ,

My name is Ocita G, the manager, credit
and foreign bills of Ecobank Plc. I am writing in
respect of a foreign customer of my bank with account
number 14-255-2004/utb/t who perished in a plane crash
[Korean Air Flight 801] with the whole passengers
aboard on August 6, 1997.

Since the demise of this our customer, I personally
has watched with keen interest to see the next of kin
but all has proved abortive as no one has come to
claim his funds of usd.20.5 m, [twenty million five
hundred thousand united states dollars] which has been
with my branch for a very long time.
On this note, I decided to seek for whom his name
shall be used as the next of kin as no one has come up
to be the next of kin. And the banking ethics here
does not allow such money to stay more than Six
years, because money will be recalled to the bank
treasury as unclaimed after this period.   In view of
this I got your contact through a trade journal after
realizing that your name and country is similar to the
deceased. I will give you 25% of the total.

Upon the receipt of your response, I will send you by
fax or e-mail the application, bank's fax number and
the next step to take. I will not fail to bring to
your notice that this business is hitch free and that
you should not entertain any fear as all modalities
for fund transfer can be finalized within five banking
days, after you apply to the bank as a relation to the
deceased.

When you receive this letter. Kindly send me an e-mail
signifying
Your decision including your private Tel/Fax numbers
for quick communication.

Respectfully submitted,

Ocita G.






-
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

Processing the join

[Toni Strandell]

How does MySQL process a join between tables? Does it always use 
nested-loop join, or does it use sort-merge join if the table is sorted 
before joining it? Is the join algorithm merge if the tables are already 
sorted on the join attributes (through an index)? 


Sincerely,
 Toni Strandell


-
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: Cannot create Full-Text INDEX

[Nikolaos Georgiafentis]

At 04:05 PM 9/10/2002 +0300, you wrote:
>Nikolaos,
>Monday, September 09, 2002, 7:51:43 PM, you wrote:
>
>NG> I have installed mysql 4.0.2 alpha log (actually compiled by me) in a 
>linux
>NG> box (Mandrake 8.2) and for 2 months was working perfectly. After 
>migrating
>NG> some data from an other installation (Windows 2000 / mysql 4.0.1 alpha 
>log)
>NG> my FULL-TEXT indexes stop functioning. I am issuing the following 
>statement
>NG> but no FULL-TEXT index is created.
>NG> DROP TABLE IF EXISTS e_genlogmatergroup;
>NG> CREATE TABLE `e_genlogmatergroup` (
>NG>`genlogmatergroupid` decimal(10,0) NOT NULL default '0',
>NG>`genlogmatergrouptitle` text,
>NG>`genlogmatergroupcont` text,
>NG>`genlogmatergroupparent` decimal(10,0) default '0',
>NG>`chapter` varchar(255) default NULL,
>NG>`genlogmatergroup` varchar(255) default NULL,
>NG>`genlogmaterdateins` date default NULL,
>NG>`infopg` tinyint(3) unsigned default '0',
>NG>PRIMARY KEY  (`genlogmatergroupid`),
>NG>FULLTEXT KEY `genlogmatergrouptitle` (`genlogmatergrouptitle`),
>NG>FULLTEXT KEY `genlogmatergroupcont` (`genlogmatergroupcont`),
>NG>FULLTEXT KEY `compound_e_genlogmatergroup`
>NG> (`genlogmatergroupcont`,`genlogmatergrouptitle`)
>NG> ) TYPE=MyISAM;
>
>NG> Any Ideas??
>
>I tested your example on 4.0.3 and it worked fine for me.

I have tested on 4.0.3 and it worked fine also for me. Perfect job also 
with Greek charset and full-text search. Remains a little problem with the 
sorting order of accented capital letters caused by the erroneous 
../share/mysql/charsets/greek.conf file. I have already look in the 
documentation bat i could not understand understand how to correct the 
existing one or write one from the scratch. Could you advise me on this 
issue
Also i discovered a bug of mysqlfront and phpmyadmin 2.3.0 (they dont 
report correctly the fulltext indexes.)

With thanks
Nikos





>--
>For technical support contracts, goto https://order.mysql.com/?ref=ensita
>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

Georgiafentis Nikolaos
Project Manager
[EMAIL PROTECTED] 
iTEL LTD
409 Vouliagmenis Ave.
Ilioupoli, 16346
Tel: +30 10 9790050
Fax: +30 10 9790051


-
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 on AIX 4.3.3 problem: errmsg.sys missing?

[Xiaolin Zhao]

Hi, All

I am trying to make MySQL 4.0.3b work with AIX 4.3.3.
But whenever I did the `./bin/safe_mysqld &` command,
I get following error:

020910 08:31:33  mysqld started
020910  8:31:33  Can't find messagefile
'mysql-4.0.3b/share/mysql/english/errmsg.sys'
020910  8:31:33  Aborting

020910 08:31:33  mysqld ended

The mysql is installed under /usr/local/mysql-4.0.3b,
and /usr/local/mysql is sym link to mysql-4.0.3b. 

Can anyone pinpoint what the problem is? TIA

Best regards,

Allen Zhao

__
Do You Yahoo!?
Yahoo! Finance - Get real-time stock quotes
http://finance.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: 'mysqladmin shutdown' doesn't shut it down...

[Eric Lamendola]

Hey,

I thought you could just use

mysqladmin refresh -pPASSWORD -- or
mysqladmin reload -pPASSWORD

To kickstart logging again?

If not - hey, what do I know 

Eric Lamendola

At 11:12 AM 9/10/02 +1000, Daniel Kasak wrote:
>Hi all.
>
>I've been using MySQL-4.0.3 (on Slackware-8.0) for a week or so now, and 
>have noticed that the command:
>   mysqladmin shutdown -ppassword
>doesn't shut down all mysql processes.
>I use the following script to backup our database and restart mysql:
>
>---
>cd /root/sql/backups
>for I in EnergyShop NUS ebills irm mysql sales Fuel
>do
>/usr/local/mysql-4.0.3/bin/mysqldump -v --opt $I > $I.dump -pPASSWORD
>done
>
>/usr/local/mysql-4.0.3/bin/mysqladmin shutdown -pPASSWORD
>/usr/bin/nice -n -10 /usr/local/mysql-4.0.3/bin/mysqld_safe 
>--enable-locking --log-update --log-slow-queries --
>log-long-format &
>cd ..
>tar -ycvf backups.tar.bz2 backups
>---
>
>If you're wondering why I shutdown & restart the server - I used to have a 
>problem with telling mysql to start another log file after backing up the 
>database. I'm not sure whether this was a bug or just my lack of 
>understanding, but anyway it worked so I used it...
>
>The script used to work with MySQL-4.0.1 and MySQL-4.0.2 but now I get 
>processes hanging around, usually 'mysqld_safe' and 1 or 2 'mysqld' 
>processes. This appears to happen whether I leave a client connected or 
>not. Under previous versions, if I left a client running (eg mysqltop - 
>accidentally of course), mysql would shut down and mysqltop would loose 
>it's connection - which is what I had expected to happen. So I'm not sure 
>whether mysql keeps running because there are client connections still 
>open (MS Access sometimes doesn't disconnect properly, and we have 40 MS 
>Access clients...).
>
>So ...
>Is this behaviour expected if clients are leaving connections open?
>Has this behaviour been changed intentionally since MySQL-4.0.2?
>Is this likely to cause a problem? I have had to kill the processes with 
>kill -9. There is nothing in the transaction or error log at all. And I 
>haven't noticed any data corruption yet.
>
>Thanks in advance!
>
>--
>Daniel Kasak
>IT Developer
>* NUS Consulting Group*
>Level 18, 168 Walker Street
>North Sydney, NSW, Australia 2060
>T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989
>email: [EMAIL PROTECTED]
>website: www.nusconsulting.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: MySQL Monitoring Alerts

[Eric Lamendola]

Hey,

I noticed another response about "tailing the log" and looking for 
information in the "err" log which looks like a great solution.

However, if you have an extra computer laying around, you can also set up a 
cron job with a shell script that connects to the server (via telnet or 
using a mysql client to connect) and checks the output.  Then quickly 
disconnects so as not to tie up a connection.

If the connection is refused or unavailable, then the server is not 
responding.  You could even put in some extra lines in the script for 
checking more than once to see if it was a fluke the first time.

This would be a little more real time and allows you to set the frequency 
in which you want to monitor the server.  Plus, you could set the script to 
Email you if the server isnt working.

If not - hey what do I know 

Eric Lamendola

At 10:04 AM 9/10/02 +0100, Tom Freeman wrote:
>Hi,
>I hope this question hasn't been asked loads of times before but I can't see
>any reference to it in the documentation.
>Basically I need a way to monitor MySQL to ensure it hasn't gone down. We
>are using MySQL as the backend of some important sites and need to ensure
>that if it does crash for whatever reason, an alert (email and SMS) is sent
>out to an engineer to resolve the problem.
>
>We are presently using a program known as NetSaint to monitor our services
>but it sometimes doesn't seem to be 100% reliable at detecting a MySQL
>error.
>
>Anyway, can anyone tell me a better way to monitor MySQL so that if it has
>any problems an oncall engineer can respond quickly. I'm sure this must be a
>common problem so there must be something out there already.
>
>Many thanks,
>Tom
>
>
>-
>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: Cannot create Full-Text INDEX

[Egor Egorov]

Nikolaos,
Monday, September 09, 2002, 7:51:43 PM, you wrote:

NG> I have installed mysql 4.0.2 alpha log (actually compiled by me) in a linux
NG> box (Mandrake 8.2) and for 2 months was working perfectly. After migrating 
NG> some data from an other installation (Windows 2000 / mysql 4.0.1 alpha log) 
NG> my FULL-TEXT indexes stop functioning. I am issuing the following statement 
NG> but no FULL-TEXT index is created.
NG> DROP TABLE IF EXISTS e_genlogmatergroup;
NG> CREATE TABLE `e_genlogmatergroup` (
NG>`genlogmatergroupid` decimal(10,0) NOT NULL default '0',
NG>`genlogmatergrouptitle` text,
NG>`genlogmatergroupcont` text,
NG>`genlogmatergroupparent` decimal(10,0) default '0',
NG>`chapter` varchar(255) default NULL,
NG>`genlogmatergroup` varchar(255) default NULL,
NG>`genlogmaterdateins` date default NULL,
NG>`infopg` tinyint(3) unsigned default '0',
NG>PRIMARY KEY  (`genlogmatergroupid`),
NG>FULLTEXT KEY `genlogmatergrouptitle` (`genlogmatergrouptitle`),
NG>FULLTEXT KEY `genlogmatergroupcont` (`genlogmatergroupcont`),
NG>FULLTEXT KEY `compound_e_genlogmatergroup` 
NG> (`genlogmatergroupcont`,`genlogmatergrouptitle`)
NG> ) TYPE=MyISAM;

NG> Any Ideas??

I tested your example on 4.0.3 and it worked fine for me.



-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
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: Crash, 98 and 2000

[Victoria Reznichenko]

Mustafa,
Tuesday, September 10, 2002, 10:19:14 AM, you wrote:

MY> we use mysql 3.23.46-max-nt at customer pc. Some customers use Windows2000,
MY> but some use Win98. Mysql Database that run at Win98 platform, sometimes
MY> crashes, and i cannot repair it. The error often ise 144 Error that "TABLE
MY> CRASHED AND LAST REPAIR FAILED".

MY> Tables that crashed Win2000 can be repair but, they that crashed Win98
MY> cannot be repaired?

How did you repair table? With REPAIR TABLE statement or with
myisamchk utility? If you use myisamchk did you use -r or -o options?
What error did you received during repairing?


-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
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: show tables

[Nicholas Stuart]

DB independent? As in an entire list of tables in your MySQL server? Or as
in independent from MySQL to say MS SQL Server? If the later then I'm sure
each db as some form of query to get a list of tables, just look it up. I
don't think there would be a unified way simple because each db is
completly different (unless they all use the same "SHOW TABLES" command
which I don't know if they do or not.)
As far as the first way goes you could only do it, as far as I know, in
some form of program.
-Nick

p.s. this really isn't related to MySQL becuase you are asking about other
db's but I thought I would be nice and answer it any how  :)

> hi all,
> how do i retrieve a list of all tablenames in the database? i know i can

> do it with a "show tables" query in MySQL, but i'd like to try to make
> this db-independent..
> thanx!
> jasper
>
>
>
> -
> Please check "http://www.mysql.com/Manual_chapter/manual_toc.html";
before
> posting. To request this thread, e-mail [EMAIL PROTECTED]
>
> To unsubscribe, send a message to the address shown in the
> List-Unsubscribe header of this message. If you cannot see it,
> e-mail [EMAIL PROTECTED] instead.
>




-
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: Select question

[Nicholas Stuart]

You would have to do something like:
SELECT * FROM users WHERE CONCAT(firstname, " ", lastname) = "John Smith"
That should get you what you want.
If your taking your DB from MS SQL to MySQL only a few queries will port
directly over. You have to be careful that you follow the MySQL syntax and
functions as they are slightly different.
-Nick

>
> Hi,
>
> I have a table called users with the columns firstname and lastname. I
would
> like to do a search on the fullname and have tried:
>
> select * from users where (firstname + ' ' + lastname) = "John Smith"
>
> which returns all rows for some reason and not only the rows with users
> named John Smith (which SQL Server does). Any ideas?
>
> Kind regards, Elin
>
>
>
>
> -
> 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