Re: reports? from MySQL (oops, on a Mac)

[Grigory Bakunov]

Date |Wed, 29 Aug 2001 03:15:50 -0400
>From |[EMAIL PROTECTED]

Hello!

G> dumb question: what do i put for macintosh G4/450 OS X?

I all case you need 3 things - X Window, gcc, Mysql.
I use Siag on OS/2, MS Windows and all Unixes - so it's
will work with MacOS X.

___
For technical support contracts, visit https://order.mysql.com/
This email is sponsored by SWSoft, http://www.asplinux.ru/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Grigory Bakunov <[EMAIL PROTECTED]>
 / /|_/ / // /\ \/ /_/ / /__   MySQL AB / SWSoft
/_/  /_/\_, /___/\___\_\___/
   <___/   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: reports? from MySQL (oops, on a Mac)

[get86]

so, does this mean:

siag works in Mac OS X, but in X Windows, i.e., XonX?

and, do i then have to use MySQL for X Windows (XFree86) system also 
or can i use the same MySQL i have for/on OS X itself?

thank you.

At 12:22 PM +0500 8/29/01, Grigory Bakunov wrote:
>Date |Wed, 29 Aug 2001 03:15:50 -0400
>From |[EMAIL PROTECTED]
>
>Hello!
>
>G> dumb question: what do i put for macintosh G4/450 OS X?
>
>I all case you need 3 things - X Window, gcc, Mysql.
>I use Siag on OS/2, MS Windows and all Unixes - so it's
>will work with MacOS X.
>
>___
>For technical support contracts, visit https://order.mysql.com/
>This email is sponsored by SWSoft, http://www.asplinux.ru/
>__  ___ ___   __
>   /  |/  /_ __/ __/ __ \/ /Grigory Bakunov <[EMAIL PROTECTED]>
>  / /|_/ / // /\ \/ /_/ / /__   MySQL AB / SWSoft
>/_/  /_/\_, /___/\___\_\___/
><___/   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 BLOB field -- need help

[Zhenjiang Guo]

I'm exhausted by the BLOB field in MySQL.
 I cann't get the content of the BLOB field. 
Is there anyone who will kindly point out the correct direction for me?
A piece of code will be especially appreciated.
I'm using VC and ADO.
Thanks.

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

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

Re: Roles

[Grigory Bakunov]

Date |Tue, 28 Aug 2001 09:41:02 -0700
>From |John Meyer <[EMAIL PROTECTED]>

Hello!

JM> In Oracle, I remember working with roles that I could assign to a user.  Is 
JM> there such a mechanism, or are there plans to implement such a mechanism, 
JM> in MySQL.

If you mean level based priveleges then no, mysql doesn't support it.
More about mysql priveleges system you can read here:
http://www.mysql.com/doc/P/r/Privilege_system.html

___
For technical support contracts, visit https://order.mysql.com/
This email is sponsored by SWSoft, http://www.asplinux.ru/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Grigory Bakunov <[EMAIL PROTECTED]>
 / /|_/ / // /\ \/ /_/ / /__   MySQL AB / SWSoft
/_/  /_/\_, /___/\___\_\___/
   <___/   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: Please..Desperate for Help |||||||

[Grigory Bakunov]

Date |Tue, 28 Aug 2001 12:30:25 -0400
>From |<[EMAIL PROTECTED]>

Hello!

N> I am trying to install the "dbf2mysql" converter and really 
N> getting a headache. Someone told me that I need to 
N> install the "Include files and libraries for MySQL" and I 
N> have been searching frantically all over the web for the 
N> source for this. All I have been able to find is the RPM's.
N> I am on Mac OS X Server and would like to set this up. 
N> Is it possible to install the developer edition of MySQL 
N> for X Server ??  If so, can someone point me to where I 
N> can get this. I have got to get this converter to work 
N> under X Server but it seems that I have to have the 
N> mysql-devel installed. Can someone please help me?
N> Thanks.


Just get the source packages and compile it.
You can get latest tarball with sources here:
http://www.mysql.com/Downloads/MySQL-3.23/mysql-3.23.41.tar.gz
___
For technical support contracts, visit https://order.mysql.com/
This email is sponsored by SWSoft, http://www.asplinux.ru/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Grigory Bakunov <[EMAIL PROTECTED]>
 / /|_/ / // /\ \/ /_/ / /__   MySQL AB / SWSoft
/_/  /_/\_, /___/\___\_\___/
   <___/   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 create table URGENT

[Grigory Bakunov]

Date |Tue, 28 Aug 2001 23:43:16 +0200
>From |"Martin Jeremic" <[EMAIL PROTECTED]>

Hello!

MJ> This is really stupid, but I can remember how to save results of "SHOW
MJ> CREATE TABLE tbl_name" and "SHOW COLUMNS FROM tbl_name" in to text file. I'm
MJ> running mysql 23.41 on Win2k.

MJ> Thanks in advance
mysql -e 'use mybase; show columns from tbl_name" >file.txt

___
For technical support contracts, visit https://order.mysql.com/
This email is sponsored by SWSoft, http://www.asplinux.ru/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Grigory Bakunov <[EMAIL PROTECTED]>
 / /|_/ / // /\ \/ /_/ / /__   MySQL AB / SWSoft
/_/  /_/\_, /___/\___\_\___/
   <___/   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: Root password revisited

[Grigory Bakunov]

Date |Tue, 28 Aug 2001 19:09:49 -0700
>From |"Gregg Baker" <[EMAIL PROTECTED]>

Hello!

GB> Hi all, I got a "No Database Chosen". What's the syntax for adding the
GB> database? I tried *.*, mysql, and test between UPDATE and user but all
GB> returned syntax error.

GB> Thanks much, Gregg

GB> UPDATE user SET Password=PASSWORD("desiredpasswordhere") WHERE User="root";


Try to execute 'USE mysql' before your UPDATE command.

___
For technical support contracts, visit https://order.mysql.com/
This email is sponsored by SWSoft, http://www.asplinux.ru/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Grigory Bakunov <[EMAIL PROTECTED]>
 / /|_/ / // /\ \/ /_/ / /__   MySQL AB / SWSoft
/_/  /_/\_, /___/\___\_\___/
   <___/   www.mysql.com


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

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

RE: mySQL

[Bruce Stewart]

Thomas,

What is the connection string you are using?

Bruce

-Original Message-
From: Thomas Ekegren Christensen [mailto:[EMAIL PROTECTED]]
Sent: Tue, 28 August 2001 18:43
To: [EMAIL PROTECTED]
Subject: mySQL


Hi mySQL,

I have a huge problem and unfortunately my Domain Hosting Services has no
interest in helping me. I am running mySQL with ASP and use a DSN-less call
to connect to mySQL.
The problem is a little bit weird because running the query using phpmyadmin
gives me a perfect recordset. Running it in ASP using ADO returns an empty
recordset. The MySQL manual talks about setting the option flag "return
matching rows". Since I haven't got the faintest idea of how to do this, I
assume that's the reason for my empty recordset.
Can anyone please tell me how to do this and preferable using a DSN-less
call to MySQL.

Kind regards,

Thomas Christensen

NB! The SQL query is listed below.

strSQL = "SELECT COUNT(Bog.Bogid), Brugere.Navn FROM Brugere INNER JOIN Bog
ON Bog.mailadresse = Brugere.mailadresse GROUP BY Brugere.Navn"
objRs.CursorLocation = adUseClient

objRs.Open strSQL, strConnect, adCmdText




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

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: reports? from MySQL (oops, on a Mac)

[Grigory Bakunov]

Date |Wed, 29 Aug 2001 03:33:45 -0400
>From |[EMAIL PROTECTED]

Hello!

G> so, does this mean:

G> siag works in Mac OS X, but in X Windows, i.e., XonX?
yes.

G> and, do i then have to use MySQL for X Windows (XFree86) system also 
G> or can i use the same MySQL i have for/on OS X itself?
you can use your standart mysql.

___
For technical support contracts, visit https://order.mysql.com/
This email is sponsored by SWSoft, http://www.asplinux.ru/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Grigory Bakunov <[EMAIL PROTECTED]>
 / /|_/ / // /\ \/ /_/ / /__   MySQL AB / SWSoft
/_/  /_/\_, /___/\___\_\___/
   <___/   www.mysql.com


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

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

Re: mysql BLOB field -- need help

[Carl Troein]

On 29-Aug-01, Zhenjiang Guo wrote:

> I'm exhausted by the BLOB field in MySQL.
> I cann't get the content of the BLOB field. 
> Is there anyone who will kindly point out the correct direction for me?
> A piece of code will be especially appreciated.
> I'm using VC and ADO.
> Thanks.

As far as I know a BLOB is just a TEXT with string comparisons
defaulting to be case sensitive. Have you tried storing whatever
data you're handling in TEXT fields to see if that works? Just
a random thought. :-o

//C

-- 
 Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280
 [EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~cirdan/
 Amiga user since '89, and damned proud of it too.


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

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 + ODBC + palm + security?

[Brett Geer]

Why not just setup a ssh tunnel and replicate?

brett

Venu wrote:

> Hi !!!
> 
> Can anyone has the answer for him ? How we can have a secure data transfer
> over the web using MySQL and its APIs ? He is desperately needed some idea
> in order to take further steps with MySQL ?
> 
> Regards
> Venu
> 
> )-Original Message-
> )From: A. Chris Nichols [mailto:[EMAIL PROTECTED]]
> )Sent: Friday, August 24, 2001 7:08 AM
> )To: [EMAIL PROTECTED]
> )Subject: RE: MySQL + ODBC + palm + security?
> )
> )
> )Venu,
> )
> )I was wondering if you had had any luck finding anything out about
> )this.  I've got to try to find a way to synch some clients that are out on
> )the net with out MySQL database that is available on the web.  If they
> )can't do it securely though it doesn't make sense since the data is
> )sensitive.  Do you know of any other possibilities other than ODBC for
> )something like this?
> )
> )-Chris
> )
> )At 01:13 PM 8/14/2001, you wrote:
> )>Hi !
> )>
> )>)-Original Message-
> )>)From: A. Chris Nichols [mailto:[EMAIL PROTECTED]]
> )>)Sent: Tuesday, August 14, 2001 7:45 AM
> )>)To: [EMAIL PROTECTED]
> )>)Subject: RE: MySQL + ODBC + palm + security?
> )>)
> )>)
> )>)Any more thoughts on this?  Are there any secure methods out there for
> )>)synching over the internet?
> )>)
> )>)-Chris
> )>)
> )>)At 03:56 PM 8/13/2001, you wrote:
> )>)>Hi !
> )>)>
> )>)>)-Original Message-
> )>)>)From: A. Chris Nichols [mailto:[EMAIL PROTECTED]]
> )>)>)Sent: Monday, August 13, 2001 11:53 AM
> )>)>)To: [EMAIL PROTECTED]
> )>)>)Subject: MySQL + ODBC + palm + security?
> )>)>)
> )>)>)
> )>)>)Hey everyone,
> )>)>)
> )>)>)Has anyone had any experience establishing a secure connection
> )between a
> )>)>)palm device and MySQL database that's on the net?  I've setup
> )secure web
> )>)>)pages on our webserver that are visible on the web and viewable by
> )>)>)wireless
> )>)>)palms (securely).  Scripts on that interface provide a way to get
> )>)>)data into
> )>)>)the DB securely.
> )>)>)
> )>)>)What I'm hoping to find is an alternative for when wireless
> )access is not
> )>)>)available.  I've got a working form on Pendragon forms that can
> )>)synch with
> )>)>)the MySQL database using the MyODBC driver and a local DSN for
> )the MySQL
> )>)>)database.  As I understand ODBC has no inherent security but there are
> )>)>)secure drivers that talk with some RDBMSs.  Is anyone aware of a secure
> )>)>)version ODBC driver for MySQL?  Or is there any other way that
> )people are
> )>)>)aware of to accomplish this weird goal?
> )>)>)
> )>)>
> )
> Regards
> Venu
> --
> For technical support contracts, go to https://order.mysql.com/
>__  ___ ___   __
>   /  |/  /_ __/ __/ __ \/ /Mr. Venu <[EMAIL PROTECTED]>
>  / /|_/ / // /\ \/ /_/ / /__   MySQL AB, Developer
> /_/  /_/\_, /___/\___\_\___/   Woodside, California  USA
><___/   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
> 
> 


-- 

UNIX Ad/DBA/Teaboy/Analyst/Gopher - Intratex Holdings - Pinetown
Tel. +27 31 717 4000/4146   Fax. +27 31 717 4001

  Rule 1. Before calling me... if its a Windows box... REBOOT IT!
  Rule 2. If its a Windows box... Don't call me...
  Rule 3. Windows isn't much good for anything aside from games.
  Rule 4. Repeat.



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

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 Still a wise choice for developers?

[Brett Geer]

Hi, just a quick note.


> A) There's no *point* in keeping the image in the database.
> A DBMS is all about searching, comparing, relations, etc. You
> get *none* of these by storing the image data in the DB.


Correct if you have a small amount of images, problem if you
have thousands of these puppies in one directory. Solution
there of course is to split it up across other directories
or just change your fs type/


> B) Unless you're careful, you totally defeat both the
> web servers and the clients ability to make use of caching
> mechanisms. While you may not see a big difference on the
> server, it can make one h... of a difference to the user
> stuck behind a 33.6K modem.


So very true.

brett

-- 

UNIX Ad/DBA/Teaboy/Analyst/Gopher - Intratex Holdings - Pinetown
Tel. +27 31 717 4000/4146   Fax. +27 31 717 4001

  Rule 1. Before calling me... if its a Windows box... REBOOT IT!
  Rule 2. If its a Windows box... Don't call me...
  Rule 3. Windows isn't much good for anything aside from games.
  Rule 4. Repeat.



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

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 + ODBC + palm + security?

[Peter Rydesäter]

If the webbrowser is your client program and you access the
database via the webserver. 

Wy not use http commands "POST" or "GET" to transmitt the
sensitive data to the www server runnning encrypted
transmission via "https://";

/Peter



Brett Geer wrote:
> 
> Why not just setup a ssh tunnel and replicate?
> 
> brett
> 
> Venu wrote:
> 
> > Hi !!!
> >
> > Can anyone has the answer for him ? How we can have a secure data transfer
> > over the web using MySQL and its APIs ? He is desperately needed some idea
> > in order to take further steps with MySQL ?
> >
> > Regards
> > Venu
> >
> > )-Original Message-
> > )From: A. Chris Nichols [mailto:[EMAIL PROTECTED]]
> > )Sent: Friday, August 24, 2001 7:08 AM
> > )To: [EMAIL PROTECTED]
> > )Subject: RE: MySQL + ODBC + palm + security?
> > )
> > )
> > )Venu,
> > )
> > )I was wondering if you had had any luck finding anything out about
> > )this.  I've got to try to find a way to synch some clients that are out on
> > )the net with out MySQL database that is available on the web.  If they
> > )can't do it securely though it doesn't make sense since the data is
> > )sensitive.  Do you know of any other possibilities other than ODBC for
> > )something like this?
> > )
> > )-Chris
> > )
> > )At 01:13 PM 8/14/2001, you wrote:
> > )>Hi !
> > )>
> > )>)-Original Message-
> > )>)From: A. Chris Nichols [mailto:[EMAIL PROTECTED]]
> > )>)Sent: Tuesday, August 14, 2001 7:45 AM
> > )>)To: [EMAIL PROTECTED]
> > )>)Subject: RE: MySQL + ODBC + palm + security?
> > )>)
> > )>)
> > )>)Any more thoughts on this?  Are there any secure methods out there for
> > )>)synching over the internet?
> > )>)
> > )>)-Chris
> > )>)
> > )>)At 03:56 PM 8/13/2001, you wrote:
> > )>)>Hi !
> > )>)>
> > )>)>)-Original Message-
> > )>)>)From: A. Chris Nichols [mailto:[EMAIL PROTECTED]]
> > )>)>)Sent: Monday, August 13, 2001 11:53 AM
> > )>)>)To: [EMAIL PROTECTED]
> > )>)>)Subject: MySQL + ODBC + palm + security?
> > )>)>)
> > )>)>)
> > )>)>)Hey everyone,
> > )>)>)
> > )>)>)Has anyone had any experience establishing a secure connection
> > )between a
> > )>)>)palm device and MySQL database that's on the net?  I've setup
> > )secure web
> > )>)>)pages on our webserver that are visible on the web and viewable by
> > )>)>)wireless
> > )>)>)palms (securely).  Scripts on that interface provide a way to get
> > )>)>)data into
> > )>)>)the DB securely.
> > )>)>)
> > )>)>)What I'm hoping to find is an alternative for when wireless
> > )access is not
> > )>)>)available.  I've got a working form on Pendragon forms that can
> > )>)synch with
> > )>)>)the MySQL database using the MyODBC driver and a local DSN for
> > )the MySQL
> > )>)>)database.  As I understand ODBC has no inherent security but there are
> > )>)>)secure drivers that talk with some RDBMSs.  Is anyone aware of a secure
> > )>)>)version ODBC driver for MySQL?  Or is there any other way that
> > )people are
> > )>)>)aware of to accomplish this weird goal?
> > )>)>)
> > )>)>
> > )
> > Regards
> > Venu
> > --
> > For technical support contracts, go to https://order.mysql.com/
> >__  ___ ___   __
> >   /  |/  /_ __/ __/ __ \/ /Mr. Venu <[EMAIL PROTECTED]>
> >  / /|_/ / // /\ \/ /_/ / /__   MySQL AB, Developer
> > /_/  /_/\_, /___/\___\_\___/   Woodside, California  USA
> ><___/   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
> >
> >
> 
> --
> 
> UNIX Ad/DBA/Teaboy/Analyst/Gopher - Intratex Holdings - Pinetown
> Tel. +27 31 717 4000/4146   Fax. +27 31 717 4001
> 
>   Rule 1. Before calling me... if its a Windows box... REBOOT IT!
>   Rule 2. If its a Windows box... Don't call me...
>   Rule 3. Windows isn't much good for anything aside from games.
>   Rule 4. Repeat.
> 
> 
> -
> Before posting, please check:
>http://www.mysql.com/manual.php   (the manual)
>http://lists.mysql.com/   (the list archive)
> 
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail <[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

-- 
===
Peter Rydesäter[EMAIL PROTECTED]  Privat:Önevägen 15
ITM, Mitthögskolan Tel: 063-165580   832 51 FRÖSÖN
83125 ÖstersundFax: 063-165700   063-138889,070-5606816
==

Re: FULLTEXT exact match queries?

[Sergei Golubchik]

Hi!

On Aug 28, Alok K. Dhir wrote:
> 
> > select * from Laws WHERE MATCH(Line) AGAINST ('growth 
> > hormone') AND Line like '%growth hormone%' ORDER BY ID;
> 
> This defeats the purpose of the fulltext index, don't you think?
> 
> Al

Not really, as fulltext index is used to find the documents that contain
either "growth" or "hormone", and LIKE is applied only to those documents,
not to all the rows.

But, indeed, this is a hack and at some point - not in 4.0 though,
MySQL will have support for phrase searches.

Regards,
Sergei

-- 
MySQL Development Team
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /   Sergei Golubchik <[EMAIL PROTECTED]>
 / /|_/ / // /\ \/ /_/ / /__  MySQL AB, http://www.mysql.com/
/_/  /_/\_, /___/\___\_\___/  Osnabrueck, Germany
   <___/

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

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 BLOB field -- need help

[Zhenjiang Guo]

Yes, I tried a TEXT field. Error occurs when calling 
Recordset->Fields->GetItem(0L)->AppendChunk(lSize). But the same code runs well when I 
changed to an Access table.
Thanks

On Wed, 29 Aug 2001 10:18:54 +0200
Carl Troein <[EMAIL PROTECTED]> wrote:

> 
> As far as I know a BLOB is just a TEXT with string comparisons
> defaulting to be case sensitive. Have you tried storing whatever
> data you're handling in TEXT fields to see if that works? Just
> a random thought. :-o

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

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: Root password revisited

[B. van Ouwerkerk]

At 17:44 28-8-01 -0700, Gregg Baker wrote:
>Hi all, I just joined list. I spent a couple hours in the archive and
>decided MySQL better improve their install message regarding setting the
>root password! Half the posts are about it going badly. ;)

When installing from source you will get a messages telling you to set the 
root password (mysql_install_db does this) but it is NOT mentioned in the 
manual.txt
I didn't see it in the online manual but I didn't look to long..

Perhaps one of the maintainers could think about changing this.. everything 
is explained in the docs except this little thing..

Bye,


B.


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

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

ANNOUNCE: moodss-14.5

[Jean-Luc Fontaine]

Hi everybody: here is a new version of moodss.


Check it out! (or at least the screenshots at
http://jfontain.free.fr/moodss3.gif or
http://jfontain.free.fr/moodss4.gif :).


### CHANGES ###

--- version 14.5 ---
added panes to thresholds dialog box for easier user interaction
thresholds dialog box table now properly get the input focus
tabbing to thresholds table invisible cells is now possible
thresholds dialog box keeps its size when reopened if user previously
   re-dimensioned it
fixed MySQL myvars module for 3.23.41 servers, by removing ansi_mode
   and adding log_long_queries variable
all MySQL modules now use mysqltcl library instead of Mytcl library
   (rpm can be found at http://www.xdobry.de/mysqltcl/) because mysqltcl
   in written in C instead of C++, has more functionality, and should
   give more performance thanks to the Tcl object API
improved Linux diskstats documentation on the 2.4 kernels problem
some HTML documentation screenshots updated


### README ###

This is moodss (Modular Object Oriented Dynamic SpreadSheet) version
14.5.

Moodss won in the Best System Admin Technology category (Tcl Tips and
Tricks, Valuable Real World Programming Examples) at the O'Reilly
Tcl/Tk 1999 Conference.
Linux Magazine calls it a "lifesaver".
Tucows gives it 5 stars (cows or penguins :-).

Moodss is a modular application. It displays data described and
updated in one or more modules, which can be specified in the command
line or dynamically loaded or unloaded while the application is
running. Data is originally displayed in tables. Graphical views
(graph, bar, 3D pie charts, ...), summary tables (with current,
average, minimum and maximum values) and free text viewers can be
created from any number of table cells, originating from any of the
displayed viewers. Thresholds can be set on any number of cells.

Specific modules can easily be developed in the Tcl, Perl and Python
scripting languages or in C.

A thorough and intuitive drag'n'drop scheme is used for most viewer
editing tasks: creation, modification, type mutation, destruction,
... and thresholds creation. Table rows can be sorted in increasing or
decreasing order by clicking on column titles. The current
configuration (modules, tables and viewers geometry, ...) can be saved
in a file at any time, and later reused through a command line switch,
thus achieving a dashboard functionality.

The module code is the link between the moodss core and the data to be
displayed. All the specific code is kept in the module package. Since
module data access is entirely customizable (through C code, Tcl,
Perl, Python, HTTP, ...) and since several modules can be loaded at
once, applications for moodss become limitless.
For example, thoroughly monitor a dynamic web server on a single
dashboard with graphs, using the Apache, MySQL, cpustats, memstats,
...  modules. If you have replicated servers, dynamically add them to
your view, even load the snmp module on the fly and let your
imagination take over...

Along with a core trace module, random, ps, cpustats, memstats,
diskstats, mounts, route, arp, kernmods, netdev, pci, system, MySQL
(myquery, mystatus, myprocs, myvars) modules for Linux, ping, snmp and
snmptrap for UNIX, apache and apachex modules are included (running
"wish moodss ps cpustats memstats" mimics the "top" application with a
graphic edge and remote monitoring capability).

Thorough help is provided through menus, widget tips, a message area,
a module help window and a global help window with a complete HTML
documentation.

Moodss is multi-langual thanks to Tcl internationalization
capabilities. So far only English and partially French are
supported. Help with other languages will be very warmly welcomed.

Development of moodss is continuing and as more features are added in
future versions, backward module code compatibility will be maintained.

I cannot thank the authors of the tkTable, BLT, MIME/SMTP and the HTML
libraries enough for their great work.

In order to run moodss, you need to install the following packages
(unless you can use the rpm utility, see below):
Tcl/Tk 8.3.1 or above, at (or at a mirror near you)
   http://dev.scriptics.com/ or ftp://ftp.scriptics.com/
the latest tkTable widget library at:
   http://www.hobbs.wservice.com/tcl/main.html
the latest BLT library at:
   ftp://tcltk.sourceforge.net/pub/tcltk/blt/
eventually the latest tclperl library for writing modules in Perl, or
the latest tclpython library for writing modules in Python at:
   http://jfontain.free.fr/
(see the INSTALL file for complete instructions, for UNIX and also
Windows platforms).

You also have the option of using the moodss rpm file (also in my
homepage), if you are using a Redhat Linux system (6.0 or above).
You can find the required tcl, tk, tktable, blt, tcpperl and other
rpms at: http://jfontain.free.fr/

Whether you like it (or hate it), please let me know. I would like to
hear about bugs and improvements you would like to see. I will correct
th

Re: MySQLgui problems

[Sinisa Milivojevic]

Stefan Murariu writes:
> 
> 
> [EMAIL PROTECTED] wrote:
> 
> >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:
> >
> >database,sql,query,table
> >
> >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:
> >
> >I didn't find file edfile.o even in Fl_Editor package but I suppose that 
> >libfleditor is enough.
> >The really problem is that I didn't find (and I don't imagine where to 
> >search) the rcl (maybe librcl.so) and rcleditor (maybe librcleditor.so).
> >Please help
> >Regards,
> >Stefan Murariu
> >
> >
> >

Get fl_editor 0.3, not 0.4.

And why are you building it ??

Just use static Linux binary.

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


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

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

Re: MySQLGUI Version 1.7.5 Question and Comment

[Sinisa Milivojevic]

Marion Berryman writes:
> I've been trying out MySQLGUI Version 1.7.5, and it seems to work fine on my Win 
>98SE client. I do have a question about the menu entries under Commands, Tables for 
>"Edit table" and "Create tables".  I've searched through the help file and didn't 
>find any mention of these two menu entries, and when I select them nothing seems to 
>happen. What is the purpose of these menu items and shouldn't they at least give me 
>an "Info" message when I select them? 
> 
> My comment or suggestion is that the help needs to have a section relating 
>functional capabilities to user interface items such as menus and mouse actions.  I 
>really liked your program, but it wasn't so easy to decipher how to operate the user 
>interface, which I thought was clean and useful once I begin to see how things 
>worked. Something along the lines of a short How-To list would be useful.  Or, one 
>could make a list of all user interface items with a description of what they do. 
> 
> Thank you for your consideration.
> 
> Marion Berryman
> [EMAIL PROTECTED]
> 

Edit table is 50 % over and Create table is on TODO.

And yes, our help system should be better.


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


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

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

Re: problems compiling on FreeBSD 3.3 (mysql-3.23.41)

[Sinisa Milivojevic]

Angel Behar writes:
> I just update the gcc version and still the same problem :
> 
> absa# gcc -v
> Reading specs from
> /usr/local/lib/gcc-lib/i386-unknown-freebsd3.3/3.0.1/specs
> Configured with: ../configure --enable-languages=c++
> Thread model: posix
> gcc version 3.0.1
> 
> 
> Any Ideas ?
> 
> thanks

Of course. Use FBSD 3.4 STABLE. 3.3 is not stable enough for MySQL.

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


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

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

Setting User Privilges ? Confused !!

[Peter Moscatt]

I am pretty new to MySQL, in fact that also covers Linux as well.

I have Mandrake 8.0 which I have installed MySQL using the RPM format. 
 I plan to write code (python) to access the database to manage what 
data it may hold.

The server automatically starts on boot - which is fine.

To be able to do anything with MySQL I have to be logged on as 'root'

If I try to access the database I have created under my normal logon 
('pmoscatt') I get the following error message:

ERROR 1044: Access denied for user '@localhost' to database 'MCMaint'

I have read the manual to see how I can get around this but find it 
confusing.

Can anyone help me to allow me to access databases under my normal user 
account.

Pete



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

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

Lost Root password

[temi odurinde]

Dear List,
I have lost the root password to my MySQL installation. What is the quickest way to 
remedy this situation, uninstall and reinstall MySQL or what???. My installation  runs 
on a RaQ4 server.

Thanks for your help in advance

Regards
Temi

==

Tel: +44(0)702 112 0990 * Fax: +44(0)8707 440 151

_
FREE email? get it at www.odurinde.com *** Affordable domain names? available at 
www.velnet.co.uk

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

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: Lost Root password

[B. van Ouwerkerk]

At 03:39 29-8-01 -0700, temi odurinde wrote:
>Dear List,
>I have lost the root password to my MySQL installation. What is the 
>quickest way to remedy this situation, uninstall and reinstall MySQL or 
>what???. My installation  runs on a RaQ4 server.

Take a look at the manual and this lists archive.

Bye,


B.


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

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: compiling mysql with InnoDB for AMD Athlon cpu

[Sinisa Milivojevic]

Stanislav Dmitrenko writes:
> G'day,
> 
> Is it possible to compile mysql with InnoDB for AMD Athlon processor ?
> Error produced during compilation follows:
> 
> make[4]: Entering directory `/usr/local/src/mysql-3.23.41/innobase/sync'
> gcc -DHAVE_CONFIG_H -I. -I. -I.. -I../../include -I../include
> -DDBUG_OFF -O3
> -DDBUG_OFF-DDEBUG_OFF -DUNIV_INTEL_X86 -c sync0sync.c
> sync0sync.c: In function `sync_gnuc_intelx86_test_and_set':
> sync0sync.c:187: impossible register constraint in `asm'
> sync0sync.c:187: impossible register constraint in `asm'
> sync0sync.c:187: impossible register constraint in `asm'
> sync0sync.c:1259: confused by earlier errors, bailing out
> make[4]: *** [sync0sync.o] Error 1
> make[4]: Leaving directory `/usr/local/src/mysql-3.23.41/innobase/sync'
> make[3]: *** [all-recursive] Error 1
> make[3]: Leaving directory `/usr/local/src/mysql-3.23.41/innobase'
> make[2]: *** [all-recursive-am] Error 2
> make[2]: Leaving directory `/usr/local/src/mysql-3.23.41/innobase'
> make[1]: *** [all-recursive] Error 1
> make[1]: Leaving directory `/usr/local/src/mysql-3.23.41'
> make: *** [all-recursive-am] Error 2
> 
> Thank you beforehand.
> 
> With best regards,
> Stanislav Dmitrenko
> 

This bug will be fixed in 3.23.42 which will come up on Friday or
Saturday. 

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


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

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

[Fwd: Maximum number of keys]

[joseph . bueno]

Hi,

Sorry to repost my question but I did not get any answer.

What is the maximum number of keys for a MyISAM table (without rebuilding
mysqld from source), 16 as specified in error message or 32 as in doc. ? 

Thanks

 Original Message 
Subject: Maximum number of keys
Date: Tue, 28 Aug 2001 16:42:38 +0200
From: [EMAIL PROTECTED]
To: "[EMAIL PROTECTED]" <[EMAIL PROTECTED]>

Hello,

According to MySQL documentation (Chap. 7.1 "MyISAM Tables"):
"Maximum number of keys/table is 32 as default." 

However when I try to create more than 16 keys, I get:
ERROR 1069 at line 1: Too many keys specified. Max 16 keys allowed

This table is of MyISAM type.

I am currently running MySQL 3.23.41 on Linux (2.4.5) from precompiled
binaries (MySQL-3.23.41-1.i386.rpm).

Is there any way to use more than 16 keys ?

Thanks your help
--
Joseph Bueno
NetClub/Trader.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

Use of the MySQL logo - licensing agreement

[Ed Carp]

I've been looking at upgrading the logo on several of my personal web sites
to the new, cooler logo, so I popped over to
http://www.mysql.com/downloads/logos.html, which led me to
http://www.mysql.com/company/trademark.html and the shock of my life:

[...] Generally, no person or entity may use any MySQL AB Mark without the
prior, express written permission of MySQL AB.

[...] As a general rule, no person or entity may use (or authorize the use
of) any of the MySQL AB Marks in any manner other than as expressly
authorized by MySQL AB in a written agreement.

[...] When using a MySQL AB logo, you must never modify the design, add or
delete any words, or change any colors or proportions. Only the logo art
provided by MySQL AB may be used. You may, however, adjust the typesize of
the trademark notice symbol.

[...] If you are a user of the MySQL database server, (whether under the GPL
licence or a MySQL commercial licence) and have not modified the source code
for the application or use in question, you may request permission to
display the "Powered by MySQL" logo, as shown in the MySQL AB Mark Table in
Section 4(A), in the user interface (including your website) of the
application that runs on the MySQL server. To request permission, simply
send an email to [EMAIL PROTECTED] in which you identify your name (and
company name, if applicable) and the application, and you agree to adhere
strictly to this Trademark Policy.

-
What is this?  Have the folks at MySQL gone out of their minds?  Have they
abdicated the management of the company to lawyers?

I found the previous policy regarding the use of buttons, logos, etc., to be
very liberal, and beneficial to both the MySQL folks and to site
developers - it gave developers an opportunity to advertise a little for a
great database and to show a cool-looking logo on their site at the same
time and it gave MySQL a bit of free advertising.  I find this existing
policy as written to be restrictive in the extreme - I can't show our pride
at having developed several significant products that rely on the MySQL
database engine without someone's specific *written* permission?  I can't
diddle with the logo, like so many other people have done with the old logo
to make it cooler and stand out more?  That's pretty nuts, if you ask me...

I read this new logo policy as a slap in the face to all the developers and
admins who have worked hard at spreading the "MySQL religion" to the far
corners of the web, at showing our pride at having a database engine that
one could install almost anywhere, that supported SQL, that flat-out
*screamed* performance-wise, and that was supported by a team of very cool
folks at MySQL.  It reads as a knee-jerk reaction to the MySQL/NuSphere
brouhaha - one bad experience has screwed it up for the rest of us?

Tell me it ain't so, folks...tell me the greatest database on the face of
the planet hasn't sold out to the bean counters and lawsuit-filers...please!
--
Ed Carp, N7EKG  -  [EMAIL PROTECTED]  -  214/341-4420 -
http://www.pobox.com/~erc

Squished Mosquito, Inc.
Internet Applications Development
Escapade Server-Side Scripting Language Development Team
http://www.squishedmosquito.com
Pensacola - Dallas - Dresden - London - Paris


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

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: Use of the MySQL logo - licensing agreement

[Gerald R. Jensen]

This is just a WAG ... but do you suppose this is a result of the flap with
NuSphere?

Gerry

- Original Message -
From: "Ed Carp" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, August 29, 2001 6:27 AM
Subject: Use of the MySQL logo - licensing agreement


I've been looking at upgrading the logo on several of my personal web sites
to the new, cooler logo, so I popped over to
http://www.mysql.com/downloads/logos.html, which led me to
http://www.mysql.com/company/trademark.html and the shock of my life:

[...] Generally, no person or entity may use any MySQL AB Mark without the
prior, express written permission of MySQL AB.

[...] As a general rule, no person or entity may use (or authorize the use
of) any of the MySQL AB Marks in any manner other than as expressly
authorized by MySQL AB in a written agreement.

[...] When using a MySQL AB logo, you must never modify the design, add or
delete any words, or change any colors or proportions. Only the logo art
provided by MySQL AB may be used. You may, however, adjust the typesize of
the trademark notice symbol.

[...] If you are a user of the MySQL database server, (whether under the GPL
licence or a MySQL commercial licence) and have not modified the source code
for the application or use in question, you may request permission to
display the "Powered by MySQL" logo, as shown in the MySQL AB Mark Table in
Section 4(A), in the user interface (including your website) of the
application that runs on the MySQL server. To request permission, simply
send an email to [EMAIL PROTECTED] in which you identify your name (and
company name, if applicable) and the application, and you agree to adhere
strictly to this Trademark Policy.

-
What is this?  Have the folks at MySQL gone out of their minds?  Have they
abdicated the management of the company to lawyers?

I found the previous policy regarding the use of buttons, logos, etc., to be
very liberal, and beneficial to both the MySQL folks and to site
developers - it gave developers an opportunity to advertise a little for a
great database and to show a cool-looking logo on their site at the same
time and it gave MySQL a bit of free advertising.  I find this existing
policy as written to be restrictive in the extreme - I can't show our pride
at having developed several significant products that rely on the MySQL
database engine without someone's specific *written* permission?  I can't
diddle with the logo, like so many other people have done with the old logo
to make it cooler and stand out more?  That's pretty nuts, if you ask me...

I read this new logo policy as a slap in the face to all the developers and
admins who have worked hard at spreading the "MySQL religion" to the far
corners of the web, at showing our pride at having a database engine that
one could install almost anywhere, that supported SQL, that flat-out
*screamed* performance-wise, and that was supported by a team of very cool
folks at MySQL.  It reads as a knee-jerk reaction to the MySQL/NuSphere
brouhaha - one bad experience has screwed it up for the rest of us?

Tell me it ain't so, folks...tell me the greatest database on the face of
the planet hasn't sold out to the bean counters and lawsuit-filers...please!
--
Ed Carp, N7EKG  -  [EMAIL PROTECTED]  -  214/341-4420 -
http://www.pobox.com/~erc

Squished Mosquito, Inc.
Internet Applications Development
Escapade Server-Side Scripting Language Development Team
http://www.squishedmosquito.com
Pensacola - Dallas - Dresden - London - Paris


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

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: Use of the MySQL logo - licensing agreement

[Ed Carp]

> This is just a WAG ... but do you suppose this is a result of the
> flap with
> NuSphere?

I agree - but man, have they ever screwed it up for the rest of us!  For
this great database engine to be led around by the nose by lawyers is sad.
I mean, I understand protecting the corporate jewels, but jeez...



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

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: Use of the MySQL logo - licensing agreement

[Gerald Jensen]

Ed:

I would hope that someone from MySQL AB will address this. It is
particularly important to those of us who purchased blocks of licenses under
TcX's OEM arrangement.

We have an OEM agreement for another software product with a Canadian
company. The written agreement is very simple, but grants us specific rights
to use their logo and trademark. Compliance is easy, and we don't have to
check with anybody.

Gerald Jensen

-Original Message-
From: Ed Carp [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, August 29, 2001 6:38 AM
To: Gerald R. Jensen; [EMAIL PROTECTED]
Subject: RE: Use of the MySQL logo - licensing agreement


> This is just a WAG ... but do you suppose this is a result of the
> flap with
> NuSphere?

I agree - but man, have they ever screwed it up for the rest of us!
--
Ed Carp, N7EKG  -  [EMAIL PROTECTED]  -  214/341-4420 -
http://www.pobox.com/~erc

Squished Mosquito, Inc.
Internet Applications Development
Escapade Server-Side Scripting Language Development Team
http://www.squishedmosquito.com
Pensacola - Dallas - Dresden - London - Paris



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

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: Use of the MySQL logo - licensing agreement

[Sinisa Milivojevic]

Gerald Jensen writes:
> Ed:
> 
> I would hope that someone from MySQL AB will address this. It is
> particularly important to those of us who purchased blocks of licenses under
> TcX's OEM arrangement.
> 
> We have an OEM agreement for another software product with a Canadian
> company. The written agreement is very simple, but grants us specific rights
> to use their logo and trademark. Compliance is easy, and we don't have to
> check with anybody.
> 
> Gerald Jensen
> 

What exactly would you like us to clear out ??

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


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

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

Re: MySQL Web Site Changes

[Philip Molter]

The new web site looks great and none of the old functionality has been
lost.

Except ...

On the documentation listing for one-page-per-chapter and one-big-page,
the keywords and commands, like 'SELECT' and 'GRANT' used to be in a
different color (purple in that case) which made it very easy to scan
through the document to find the command you needed (especially when
the order was changed so that the commands weren't all listed in
Chapter 7).  Can that color-change be reimplemented?  It's incredibly
useful for day-to-day use of those chapters.

And let's put in the word 'MySQL' to get around the spam filters.

Thanks,
Philip

* Philip Molter
* DataFoundry.net
* http://www.datafoundry.net/
* [EMAIL PROTECTED]

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

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

RE: Use of the MySQL logo - licensing agreement

[Gerald Jensen]

Sinisa:

I'm not looking for anything to be cleared out (as in removed).

My point, and I believe Ed's point, is that I'm not clear on use of the
MySQL logo in my software, printed material, etc.

Gerry

-Original Message-
From: Sinisa Milivojevic [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, August 29, 2001 7:52 AM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: RE: Use of the MySQL logo - licensing agreement


Gerald Jensen writes:
> Ed:
>
> I would hope that someone from MySQL AB will address this. It is
> particularly important to those of us who purchased blocks of licenses
under
> TcX's OEM arrangement.
>
> We have an OEM agreement for another software product with a Canadian
> company. The written agreement is very simple, but grants us specific
rights
> to use their logo and trademark. Compliance is easy, and we don't have to
> check with anybody.
>
> Gerald Jensen
>

What exactly would you like us to clear out ??

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



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

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

Server overload problems

[Catalin Tenita]

Hi people,

Can you tell me how to monitor the server load and the mysql processes for a
a normal user on a shared Linux sistem.

We've launched a new version of our BestJobs.ro site (more complex in sql
queries than the last version) and it apperar that is crasching the machine,
by overloading it with mysql processes.
The machine is a dual 933's with 2 gig of ram and scsi drives, acting as
shared-hosting server.


Best Regards,
Catalin Tenita


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

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: Use of the MySQL logo - licensing agreement

[Ed Carp]

> My point, and I believe Ed's point, is that I'm not clear on use of the
> MySQL logo in my software, printed material, etc.

What concerns me is that the new logo licensing stuff is so restrictive,
*anyone* who even displays the logo on a web site ("powered by MySQL") has
to get WRITTEN PERMISSION to do so from MySQL AB.  I'm uncomfortable with
that, particularly since it's free advertising for MySQL, and the way I look
at it, anyone who displays the logo on their web site (except for blatantly
trying to rip off MySQL in some way) is doing MySQL a favor, and it seems
particularly ungrateful to the developer community to force them to jump
through all kinds of hoops to do MySQL a favor.

Does that make any sense?  I'm not trying to slam MySQL, I'm just concerned
about displaying the logo on a web site that says "powered by MySQL" or
modifying the logo like folks used to do to produce all kinds of cool
enhancements to the name MySQL.


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

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

RE: Use of the MySQL logo - licensing agreement

[B. van Ouwerkerk]

>Does that make any sense?  I'm not trying to slam MySQL, I'm just concerned
>about displaying the logo on a web site that says "powered by MySQL" or
>modifying the logo like folks used to do to produce all kinds of cool
>enhancements to the name MySQL.

Did you try to get permission?? I'll bet it's quite easy. I'll even bet you 
don't have to pay for it..

I guess this has everything to do with the NuSphere stuff.. Most of the 
intellectual property (trademark) laws do require the person (company) who 
has the trademark to enforce it. Otherwise it's useless.

If they require you to ask permission then it's their right and a 
requirement of the law. In most laws the holder of the trademark can give 
others permission to use their logo..

Now.. what would you prefer.. many forks all using the same logo or that 
they require you to ask for their permission.

Bye,


B.


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

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: Use of the MySQL logo - licensing agreement

[Ganz, Will]

Unfortunately if they don't have something in place like this, then a
company can come along and hijack the 'mySQL' name/logo for their own ends.
A company has to make a sincere effort to protect its trademarks else it
will fall into the public domain. Then a NuSpherish company can come along,
use the 'mySQL' in a malicious manner with harm to your company and the
reputation of mySQL, and there would be nothing to stop them.   

I don't like it anymore than you, but welcome to the New Millenium and the
DMCA. 

Shalom,

Will

PS Shakespeare said it best as 'The first thing we do is kill all the
lawyers.'

-Original Message-
From: Ed Carp [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, August 29, 2001 8:25 AM
To: [EMAIL PROTECTED]; 'Sinisa Milivojevic'
Cc: [EMAIL PROTECTED]
Subject: RE: Use of the MySQL logo - licensing agreement


> My point, and I believe Ed's point, is that I'm not clear on use of the
> MySQL logo in my software, printed material, etc.

What concerns me is that the new logo licensing stuff is so restrictive,
*anyone* who even displays the logo on a web site ("powered by MySQL") has
to get WRITTEN PERMISSION to do so from MySQL AB.  I'm uncomfortable with
that, particularly since it's free advertising for MySQL, and the way I look
at it, anyone who displays the logo on their web site (except for blatantly
trying to rip off MySQL in some way) is doing MySQL a favor, and it seems
particularly ungrateful to the developer community to force them to jump
through all kinds of hoops to do MySQL a favor.

Does that make any sense?  I'm not trying to slam MySQL, I'm just concerned
about displaying the logo on a web site that says "powered by MySQL" or
modifying the logo like folks used to do to produce all kinds of cool
enhancements to the name MySQL.


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

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

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

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: Setting User Privilges ? Confused !!

[Roman Festchook]

By default you have record for anonimous user with any name and no pass in 
your access tables, thats lock access any other user from localhost with 
password to database. Just delete this anonimous user from mysql access tables

On Wed 29 Aug 2001 13:08, Peter Moscatt wrote:
> I am pretty new to MySQL, in fact that also covers Linux as well.
>
> I have Mandrake 8.0 which I have installed MySQL using the RPM format.
>  I plan to write code (python) to access the database to manage what
> data it may hold.
>
> The server automatically starts on boot - which is fine.
>
> To be able to do anything with MySQL I have to be logged on as 'root'
>
> If I try to access the database I have created under my normal logon
> ('pmoscatt') I get the following error message:
>
> ERROR 1044: Access denied for user '@localhost' to database 'MCMaint'
>
> I have read the manual to see how I can get around this but find it
> confusing.
>
> Can anyone help me to allow me to access databases under my normal user
> account.
>
> Pete
>
>
>
> -
> Before posting, please check:
>http://www.mysql.com/manual.php   (the manual)
>http://lists.mysql.com/   (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail <[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

-- 
Roman Festchook
Network Engineer
ISP ORTA Polesye
http://www.polesye.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

Join Problem

[Urb LeJeune]

I've been staring at the following query for a day. I'm sure it's
something obvious but I just don't see it.

There are two table, Recipes which contains one row per
recipe. The second in Ingredients while holds one row per
ingredient. The Ingredients table has a field containing the
parent recipe ID. I want to perform a query on the Ingredients
Description field and return from the Recipes table distinct
parent ID, Category Code, and Title. Here is my query:

SELECT DISTINCT R.ID, R.CatCode, R.Title
   FROM Recipes R, Ingredients I
   WHERE I.Description LIKE "%$SearchKey%"

If the LIKE clause produces any match, all Recipe rows are returned.
If there are no matches, zero rows are returned. To wit. if
$SearchKey = "e" all rows in Recipes are returned as they should.
If $SearchKey = "rice" all rows in Recipes are returned but only one
should be returned.

Any suggests would be appreciated.

Urb


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

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: Use of the MySQL logo - licensing agreement

[Ed Carp]

B. van Ouwerkerk ([EMAIL PROTECTED]) writes:

> Now.. what would you prefer.. many forks all using the same logo or that 
> they require you to ask for their permission.

Actually, I'd prefer a bunch of derivitive logos, like before, so I could
choose the best-looking database logo based on my web site look-and-feel :)
--
Ed Carp, N7EKG  -  [EMAIL PROTECTED]  -  214/341-4420 - http://www.pobox.com/~erc

Is your web site data driven?  Are you swamped with work managing, updating,
and deploying that data on to your web site?  You need Escapade!  Check us
out at http://www.squishedmosquito.com/cgi-bin/esp?PAGE=esp_intro.html

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

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

im puzzled

[Jeremy Morano]

Hi ,

this is my query

SELECT users.uid FROM users, picks WHERE users.uid = picks.user_id;

this works correctly. The results are what they are supposed to be:
However, when I change the = sign to a <> or !=, The results are completely
incorrect.

--

picks.user_id contains: 5, 1, 7, 8, 9, 12, 13, 15

users.uid contains: 1, 8, 9, 5, 7, 10, 11, 12, 13, 14, 15


the result for SELECT users.uid FROM users, picks WHERE users.uid =
picks.user_id; is:

5, 1, 7, 8, 9, 12, 13, 15

and the result for SELECT users.uid FROM users, picks WHERE users.uid <>
picks.user_id; is:

1, 7, 8, 9, 10, 11, 12, 13, 14, 15, 5, 7, 8, 9, 10, 11,12, 13, 14, 15, 1, 5,
8, 9, 10 ,11...etc

it goes on for 80 rows with no particular pattern..H.E.L.P.!.


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

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: Join Problem

[Andrew Murphy]

You could try using an AND in the WHERE statement.

EG.  SELECT DISTINCT R.ID, R.CatCode, R.Title
 FROM Recipes R, Ingredients I
 WHERE I.Description LIKE "%$SearchKey%"
 AND R.ID = I.ID;

Hope this helps.

Andrew Murphy


-Original Message-
From: Urb LeJeune [mailto:[EMAIL PROTECTED]]
Sent: 29 August 2001 3:32 pm
To: [EMAIL PROTECTED]
Subject: Join Problem


I've been staring at the following query for a day. I'm sure it's
something obvious but I just don't see it.

There are two table, Recipes which contains one row per
recipe. The second in Ingredients while holds one row per
ingredient. The Ingredients table has a field containing the
parent recipe ID. I want to perform a query on the Ingredients
Description field and return from the Recipes table distinct
parent ID, Category Code, and Title. Here is my query:

SELECT DISTINCT R.ID, R.CatCode, R.Title
   FROM Recipes R, Ingredients I
   WHERE I.Description LIKE "%$SearchKey%"

If the LIKE clause produces any match, all Recipe rows are returned.
If there are no matches, zero rows are returned. To wit. if
$SearchKey = "e" all rows in Recipes are returned as they should.
If $SearchKey = "rice" all rows in Recipes are returned but only one
should be returned.

Any suggests would be appreciated.

Urb


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

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

Primary Key pairs and auto-incrementing

[Ferrara, Joseph C]

I want to create a table with two Primary Keys.  The first key is a category
field, and the second is auto-incremented.  Example: Key 1=Chapter name, Key
2 =section number.  For example, (Chapter1, 1) (Chapter1, 2) (Chapter1, 3)
then with a new Cheaper, I want to restart the auto-incremented field back
to 1 (Chapter2, 1) (Chapter2, 2).  How do I get the auto-incrementer to
restart with each new chapter?

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

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: Server overload problems

[Ed Carp]

Catalin Tenita ([EMAIL PROTECTED]) writes:

> Hi people,
> 
> Can you tell me how to monitor the server load and the mysql processes for a
> a normal user on a shared Linux sistem.

For monitoring the machine itself, I usually use "top".  For monitoring the
database, I like "mysqladmin processlist" and "mysqladmin status".  YMMV :)
--
Ed Carp, N7EKG  -  [EMAIL PROTECTED]  -  214/341-4420 - http://www.pobox.com/~erc

Squished Mosquito, Inc.
Internet Applications Development
Escapade Server-Side Scripting Language Development Team
http://www.squishedmosquito.com
Pensacola - Dallas - Dresden - London

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

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: Lost Root password

[Ed Carp]

temi odurinde ([EMAIL PROTECTED]) writes:

> Dear List,
> I have lost the root password to my MySQL installation. What is the quickest way to 
>remedy this situation, uninstall and reinstall MySQL or what???. My installation  
>runs on a RaQ4 server.

The quickest way is to RTFM :)  The searchable manual is online at
http://www.mysql.com/doc/ - it took me all of 30 seconds to return the
following URL (although I ought to know this one by heart!):

"Hot to Reset a Forgotten Password" -
http://www.mysql.com/doc/R/e/Resetting_permissions.html

OBList: database,sql,query,table
--
Ed Carp, N7EKG  -  [EMAIL PROTECTED]  -  214/341-4420 - http://www.pobox.com/~erc

Squished Mosquito, Inc.
Internet Applications Development
Escapade Server-Side Scripting Language Development Team
http://www.squishedmosquito.com
Pensacola - Dallas - Dresden - London

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

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: Use of the MySQL logo - licensing agreement

[Sinisa Milivojevic]

Gerald Jensen writes:
> Sinisa:
> 
> I'm not looking for anything to be cleared out (as in removed).
> 
> My point, and I believe Ed's point, is that I'm not clear on use of the
> MySQL logo in my software, printed material, etc.
> 
> Gerry
> 

You are quite correct.

This issue will be set straight, so someone responsilble for those
issue will adress MySQL community.


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


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

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

Re: MySQL Web Site Changes

[Sinisa Milivojevic]

Philip Molter writes:
> The new web site looks great and none of the old functionality has been
> lost.
> 
> Except ...
> 
> On the documentation listing for one-page-per-chapter and one-big-page,
> the keywords and commands, like 'SELECT' and 'GRANT' used to be in a
> different color (purple in that case) which made it very easy to scan
> through the document to find the command you needed (especially when
> the order was changed so that the commands weren't all listed in
> Chapter 7).  Can that color-change be reimplemented?  It's incredibly
> useful for day-to-day use of those chapters.
> 
> And let's put in the word 'MySQL' to get around the spam filters.
> 
> Thanks,
> Philip
> 
> * Philip Molter
> * DataFoundry.net
> * http://www.datafoundry.net/
> * [EMAIL PROTECTED]


I have forwarded your message to our Web team.

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


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

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

Problem running mysql_install_db

[Oswalt, Vincent]

Platform: Solaris 2.6 SPARC

I am attempting to install the binary distribution of MySQL on a Sun Netra
1120 running Solaris 2.6. 

The file I downloaded is:
mysql-3.23.39-sparc-sun-solaris2.6.tar

I used GNU tar to unpack the distribution.

When I try running the script my_install_db, I get the following error:

010829 10:20:03  mysqld started
ld.so.1: /usr/local/mysql-3.23.39-sparc-sun-solaris2.6/bin/mysqld: fatal:
libCrun.so.1: open failed: No such file or directory
010829 10:20:03  mysqld ended

I have read the section "4.16.1 Problems Running mysql_install_db" in the
reference manual, but I found nothing dealing with this specific problem. 
Thank you very much for any help you might provide.
- Vince Oswalt



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

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: im puzzled

[Gerald Clark]

And that is correct.
You are getting each users.uid that doesn't match each picks.userid.

Jeremy Morano wrote:

> Hi ,
> 
> this is my query
> 
> SELECT users.uid FROM users, picks WHERE users.uid = picks.user_id;
> 
> this works correctly. The results are what they are supposed to be:
> However, when I change the = sign to a <> or !=, The results are completely
> incorrect.
> 
> --
> 
> picks.user_id contains: 5, 1, 7, 8, 9, 12, 13, 15
> 
> users.uid contains: 1, 8, 9, 5, 7, 10, 11, 12, 13, 14, 15
> 
> 
> the result for SELECT users.uid FROM users, picks WHERE users.uid =
> picks.user_id; is:
> 
> 5, 1, 7, 8, 9, 12, 13, 15
> 
> and the result for SELECT users.uid FROM users, picks WHERE users.uid <>
> picks.user_id; is:
> 
> 1, 7, 8, 9, 10, 11, 12, 13, 14, 15, 5, 7, 8, 9, 10, 11,12, 13, 14, 15, 1, 5,
> 8, 9, 10 ,11...etc
> 
> it goes on for 80 rows with no particular pattern..H.E.L.P.!.
> 
> 
> -
> Before posting, please check:
>http://www.mysql.com/manual.php   (the manual)
>http://lists.mysql.com/   (the list archive)
> 
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail 
><[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php


-- 
Gerald L. Clark
[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: RE: Use of the MySQL logo - licensing agreement

[Andrew Murphy]

Why not get MySQL to make a series of slightly different logos you can
choose from like Sun and other companies do. Some are colour, others
greyscale, and some are inverse for placement on black backgrounds.

Andrew Murphy


-Original Message-
From: Ed Carp [mailto:[EMAIL PROTECTED]]
Sent: 29 August 2001 3:34 pm
To: [EMAIL PROTECTED]
Subject: Re: RE: Use of the MySQL logo - licensing agreement


B. van Ouwerkerk ([EMAIL PROTECTED]) writes:

> Now.. what would you prefer.. many forks all using the same logo or that 
> they require you to ask for their permission.

Actually, I'd prefer a bunch of derivitive logos, like before, so I could
choose the best-looking database logo based on my web site look-and-feel :)
--
Ed Carp, N7EKG  -  [EMAIL PROTECTED]  -  214/341-4420 -
http://www.pobox.com/~erc

Is your web site data driven?  Are you swamped with work managing, updating,
and deploying that data on to your web site?  You need Escapade!  Check us
out at http://www.squishedmosquito.com/cgi-bin/esp?PAGE=esp_intro.html

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

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

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

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

multiple PRI indexes

[shawn reed]

is it generally recommended / a good idea to have more than one PRI index
in the same table?  i've never seen that before until today while trying
to track down bugs in someone else's system and noticed a table with 2 PRI
indexes.  will this cause any problems?

tia.

~shawn


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

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: im puzzled

[Paul DuBois]

At 10:36 AM -0400 8/29/01, Jeremy Morano wrote:
>Hi ,
>
>this is my query
>
>SELECT users.uid FROM users, picks WHERE users.uid = picks.user_id;
>
>this works correctly. The results are what they are supposed to be:
>However, when I change the = sign to a <> or !=, The results are completely
>incorrect.
>
>--
>
>picks.user_id contains: 5, 1, 7, 8, 9, 12, 13, 15
>
>users.uid contains: 1, 8, 9, 5, 7, 10, 11, 12, 13, 14, 15
>
>
>the result for SELECT users.uid FROM users, picks WHERE users.uid =
>picks.user_id; is:
>
>5, 1, 7, 8, 9, 12, 13, 15
>
>and the result for SELECT users.uid FROM users, picks WHERE users.uid <>
>picks.user_id; is:
>
>1, 7, 8, 9, 10, 11, 12, 13, 14, 15, 5, 7, 8, 9, 10, 11,12, 13, 14, 15, 1, 5,
>8, 9, 10 ,11...etc
>
>it goes on for 80 rows with no particular pattern..H.E.L.P.!.


Why do you think this is incorrect?  Change the query to begin like this:

SELECT users.uid, picks.user_id FROM ...

and then you'll see that there is a pattern, and that the query is producing
exactly what it's supposed to.

I'm guessing that you're really trying to ask a different question
than the one the query is answering.  What exactly are you expecting
as output?

-- 
Paul DuBois, [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: multiple PRI indexes

[Chris Bolt]

> is it generally recommended / a good idea to have more than one PRI index
> in the same table?  i've never seen that before until today while trying
> to track down bugs in someone else's system and noticed a table with 2 PRI
> indexes.  will this cause any problems?

It shouldn't cause any problems, as long as the creator intended to have a
unique index on two columns instead of just one.


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

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: Primary Key pairs and auto-incrementing

[Chris Bolt]

> I want to create a table with two Primary Keys.  The first key is
> a category
> field, and the second is auto-incremented.  Example: Key
> 1=Chapter name, Key
> 2 =section number.  For example, (Chapter1, 1) (Chapter1, 2) (Chapter1, 3)
> then with a new Cheaper, I want to restart the auto-incremented field back
> to 1 (Chapter2, 1) (Chapter2, 2).  How do I get the auto-incrementer to
> restart with each new chapter?

Try this:

mysql> CREATE TABLE test (chapter INT NOT NULL, section INT NOT NULL
AUTO_INCREMENT, PRIMARY KEY (chapter, section));
Query OK, 0 rows affected (0.00 sec)

mysql> INSERT INTO test (chapter) VALUES (1);
Query OK, 1 row affected (0.00 sec)

mysql> INSERT INTO test (chapter) VALUES (2);
Query OK, 1 row affected (0.00 sec)

mysql> INSERT INTO test (chapter) VALUES (2);
Query OK, 1 row affected (0.00 sec)

mysql> SELECT * FROM test;
+-+-+
| chapter | section |
+-+-+
|   1 |   1 |
|   2 |   1 |
|   2 |   2 |
+-+-+
3 rows in set (0.00 sec)

You can't have two primary keys, but you can have a single primary key on
two columns.


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

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: im puzzled

[Gerald Clark]

I suspect he wants:

SELECT users.uid
FROM users LEFT JOIN picks
ON users.uid = picks.user_id
WHERE picks.user_id IS NULL

Paul DuBois wrote:

> At 10:36 AM -0400 8/29/01, Jeremy Morano wrote:
> 
>> Hi ,
>> 
>> this is my query
>> 
>> SELECT users.uid FROM users, picks WHERE users.uid = picks.user_id;
>> 
>> this works correctly. The results are what they are supposed to be:
>> However, when I change the = sign to a <> or !=, The results are 
>> completely
>> incorrect.
>> 
>> --
>> 
>> picks.user_id contains: 5, 1, 7, 8, 9, 12, 13, 15
>> 
>> users.uid contains: 1, 8, 9, 5, 7, 10, 11, 12, 13, 14, 15
>> 
>> 
>> the result for SELECT users.uid FROM users, picks WHERE users.uid =
>> picks.user_id; is:
>> 
>> 5, 1, 7, 8, 9, 12, 13, 15
>> 
>> and the result for SELECT users.uid FROM users, picks WHERE users.uid <>
>> picks.user_id; is:
>> 
>> 1, 7, 8, 9, 10, 11, 12, 13, 14, 15, 5, 7, 8, 9, 10, 11,12, 13, 14, 15, 
>> 1, 5,
>> 8, 9, 10 ,11...etc
>> 
>> it goes on for 80 rows with no particular pattern..H.E.L.P.!.
> 
> 
> 
> Why do you think this is incorrect?  Change the query to begin like this:
> 
> SELECT users.uid, picks.user_id FROM ...
> 
> and then you'll see that there is a pattern, and that the query is 
> producing
> exactly what it's supposed to.
> 
> I'm guessing that you're really trying to ask a different question
> than the one the query is answering.  What exactly are you expecting
> as output?


-- 
Gerald L. Clark
[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: Lost Root password

[Chris Lathem]

i don't know how your RaQ4 works, but on the Qube3 I had a time getting
mySQL to shut down.. it did not show up in the list of processes running...
ended up using "killall mysql", then restarted the mysql in "safe" mode..
issue a set password query to update root password, and you are on your way!

Hope this helps,
Chris

- Original Message -
From: "Ed Carp" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Wednesday, August 29, 2001 9:51 AM
Subject: Re: Lost Root password


> temi odurinde ([EMAIL PROTECTED]) writes:
>
> > Dear List,
> > I have lost the root password to my MySQL installation. What is the
quickest way to remedy this situation, uninstall and reinstall MySQL or
what???. My installation  runs on a RaQ4 server.
>
> The quickest way is to RTFM :)  The searchable manual is online at
> http://www.mysql.com/doc/ - it took me all of 30 seconds to return the
> following URL (although I ought to know this one by heart!):
>
> "Hot to Reset a Forgotten Password" -
> http://www.mysql.com/doc/R/e/Resetting_permissions.html
>
> OBList: database,sql,query,table
> --
> Ed Carp, N7EKG  -  [EMAIL PROTECTED]  -  214/341-4420 -
http://www.pobox.com/~erc
>
> Squished Mosquito, Inc.
> Internet Applications Development
> Escapade Server-Side Scripting Language Development Team
> http://www.squishedmosquito.com
> Pensacola - Dallas - Dresden - London
>
> -
> Before posting, please check:
>http://www.mysql.com/manual.php   (the manual)
>http://lists.mysql.com/   (the list archive)
>
> 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

Replication problems involving time

[Michael Eklund]

Am I the only one that thinks that mysql ought to replicate
NOW, CURRENT_DATE, etc. as the time when those actual
inserts happened not as NOW,CURRENT_DATE,etc.  If you are
replicating accross a distance (12,15,20 hops) and there is
a connectivity problem, then you end up with data that is
out of sync.  Also my master.info ends up being wrong
whenever the server is rebooted.  (binlog.100 becomes
binlog.100\n).

Thanks,

Mike Eklund
DB Admin
Netmechanic, Inc
[EMAIL PROTECTED]
http://www.netmechanic.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

Problems getting into MySQL.com

[Philip Daggett]

Is anybody else not able to get onto mysql.com???


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

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

Re: [MySQL] Problems getting into MySQL.com

[Ashley M. Kirchner]

Philip Daggett wrote:

> Is anybody else not able to get onto mysql.com???

Looks like, it'd be down...

--
W | I haven't lost my mind; it's backed up on tape somewhere.
  +
  Ashley M. Kirchner    .   303.442.6410 x130
  IT Director / SysAdmin / WebSmith . 800.441.3873 x130
  Photo Craft Laboratories, Inc.. 3550 Arapahoe Ave. #6
  http://www.pcraft.com . .  ..   Boulder, CO 80303, U.S.A.



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

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 getting into MySQL.com

[David Ayliffe]

Seems dead from where I am in the UK,  Was up earlier (3PM GMT).
Strange

-Original Message-
From: Philip Daggett [mailto:[EMAIL PROTECTED]] 
Sent: 29 August 2001 17:51
To: [EMAIL PROTECTED]
Subject: Problems getting into MySQL.com


Is anybody else not able to get onto mysql.com???


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

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


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

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

Re: Problems getting into MySQL.com

[Matt Wagner]

Philip Daggett writes:
> Is anybody else not able to get onto mysql.com???

Hi,

We're working on it. The eth card seems to have bombed, and the admins
at our hosting facility (andover, where slashdot and freshmeat are)
are working on it ASAP.


Matt

-- 
For technical support contracts, visit https://order.mysql.com/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Mr. Matt Wagner <[EMAIL PROTECTED]>
 / /|_/ / // /\ \/ /_/ / /__   MySQL AB, Herr Direktor
/_/  /_/\_, /___/\___\_\___/   Hopkins, Minnesota  USA
   <___/   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: Problems getting into MySQL.com

[Gregg Baker]

yes, i just tried and failed

- Original Message -
From: "Philip Daggett" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, August 29, 2001 9:50 AM
Subject: Problems getting into MySQL.com


> Is anybody else not able to get onto mysql.com???
>
>
> -
> Before posting, please check:
>http://www.mysql.com/manual.php   (the manual)
>http://lists.mysql.com/   (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
<[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>


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

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

Re: multiple PRI indexes

[Paul DuBois]

At 10:33 AM -0500 8/29/01, shawn reed wrote:
>is it generally recommended / a good idea to have more than one PRI index
>in the same table?  i've never seen that before until today while trying
>to track down bugs in someone else's system and noticed a table with 2 PRI
>indexes.  will this cause any problems?

?

In MySQL, you cannot have two PRIMARY KEY indexes.  You can have a PRIMARY
KEY and and a UNIQUE index, or two UNIQUE indexes, but that's a slightly
different situation.

>
>tia.
>
>~shawn
>
>
>-
>Before posting, please check:
>http://www.mysql.com/manual.php   (the manual)
>http://lists.mysql.com/   (the list archive)
>
>To request this thread, e-mail <[EMAIL PROTECTED]>
>To unsubscribe, e-mail <[EMAIL PROTECTED]>
>Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php


-- 
Paul DuBois, [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: Primary Key pairs and auto-incrementing

[Paul DuBois]

At 10:37 AM -0400 8/29/01, Ferrara, Joseph C wrote:
>I want to create a table with two Primary Keys.  The first key is a category
>field, and the second is auto-incremented.  Example: Key 1=Chapter name, Key
>2 =section number.  For example, (Chapter1, 1) (Chapter1, 2) (Chapter1, 3)
>then with a new Cheaper, I want to restart the auto-incremented field back
>to 1 (Chapter2, 1) (Chapter2, 2).  How do I get the auto-incrementer to
>restart with each new chapter?

Create a single PRIMARY KEY that consists of the two columns chapter and
section, and make section an AUTO_INCREMENT column.  When you insert
rows, set chapter to the proper chapter number and section to NULL.
This will cause MySQL to generate independent sequences for each chapter.
(In essence, you have multiple sequences within the same table.)

This requires that you have MySQL 3.22.25 or later.  That's when this
feature was introduced.

-- 
Paul DuBois, [EMAIL PROTECTED]

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

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

Re: [MySQL] Problems getting into MySQL.com

[portasio]

seems like a dns problem... anybody
knows mysql.com's ip?

- Original Message -
From: "Ashley M. Kirchner" <[EMAIL PROTECTED]>
To: "Philip Daggett" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Wednesday, August 29, 2001 2:54 PM
Subject: Re: [MySQL] Problems getting into MySQL.com


> Philip Daggett wrote:
>
> > Is anybody else not able to get onto mysql.com???
>
> Looks like, it'd be down...
>
> --
> W | I haven't lost my mind; it's backed up on tape somewhere.
>   +
>   Ashley M. Kirchner    .   303.442.6410 x130
>   IT Director / SysAdmin / WebSmith . 800.441.3873 x130
>   Photo Craft Laboratories, Inc.. 3550 Arapahoe Ave. #6
>   http://www.pcraft.com . .  ..   Boulder, CO 80303, U.S.A.
>
>
>
> -
> Before posting, please check:
>http://www.mysql.com/manual.php   (the manual)
>http://lists.mysql.com/   (the list archive)
>
> 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] Problems getting into MySQL.com

[Sica, Bill]

Name:www.mysql.com
Address:  64.28.67.70

at least according to my NSlookup..


-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, August 29, 2001 1:22 PM
To: [EMAIL PROTECTED]; Philip Daggett
Cc: [EMAIL PROTECTED]
Subject: Re: [MySQL] Problems getting into MySQL.com


seems like a dns problem... anybody
knows mysql.com's ip?

- Original Message -
From: "Ashley M. Kirchner" <[EMAIL PROTECTED]>
To: "Philip Daggett" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Wednesday, August 29, 2001 2:54 PM
Subject: Re: [MySQL] Problems getting into MySQL.com


> Philip Daggett wrote:
>
> > Is anybody else not able to get onto mysql.com???
>
> Looks like, it'd be down...
>
> --
> W | I haven't lost my mind; it's backed up on tape somewhere.
>
+
>   Ashley M. Kirchner    .   303.442.6410
x130
>   IT Director / SysAdmin / WebSmith . 800.441.3873
x130
>   Photo Craft Laboratories, Inc.. 3550 Arapahoe Ave.
#6
>   http://www.pcraft.com . .  ..   Boulder, CO 80303,
U.S.A.
>
>
>
> -
> Before posting, please check:
>http://www.mysql.com/manual.php   (the manual)
>http://lists.mysql.com/   (the list archive)
>
> 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] Problems getting into MySQL.com

[portasio]

it's up again. with a content management system.
nice work, guys. it was down for a good cause, after
all... great! new site ;)

rds mau

- Original Message -
From: "Sica, Bill" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, August 29, 2001 2:29 PM
Subject: RE: [MySQL] Problems getting into MySQL.com


> Name:www.mysql.com
> Address:  64.28.67.70
>
> at least according to my NSlookup..
>
>
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, August 29, 2001 1:22 PM
> To: [EMAIL PROTECTED]; Philip Daggett
> Cc: [EMAIL PROTECTED]
> Subject: Re: [MySQL] Problems getting into MySQL.com
>
>
> seems like a dns problem... anybody
> knows mysql.com's ip?
>
> - Original Message -
> From: "Ashley M. Kirchner" <[EMAIL PROTECTED]>
> To: "Philip Daggett" <[EMAIL PROTECTED]>
> Cc: <[EMAIL PROTECTED]>
> Sent: Wednesday, August 29, 2001 2:54 PM
> Subject: Re: [MySQL] Problems getting into MySQL.com
>
>
> > Philip Daggett wrote:
> >
> > > Is anybody else not able to get onto mysql.com???
> >
> > Looks like, it'd be down...
> >
> > --
> > W | I haven't lost my mind; it's backed up on tape somewhere.
> >
> +
> >   Ashley M. Kirchner    .   303.442.6410
> x130
> >   IT Director / SysAdmin / WebSmith . 800.441.3873
> x130
> >   Photo Craft Laboratories, Inc.. 3550 Arapahoe Ave.
> #6
> >   http://www.pcraft.com . .  ..   Boulder, CO 80303,
> U.S.A.
> >
> >
> >
> > -
> > Before posting, please check:
> >http://www.mysql.com/manual.php   (the manual)
> >http://lists.mysql.com/   (the list archive)
> >
> > 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: Use of the MySQL logo - licensing agreement

[Van]

Sinisa Milivojevic wrote:
> 
> Gerald Jensen writes:
> > Sinisa:
> >
> > I'm not looking for anything to be cleared out (as in removed).
> >
> > My point, and I believe Ed's point, is that I'm not clear on use of the
> > MySQL logo in my software, printed material, etc.
> >
> > Gerry
> >
> 
> You are quite correct.
> 
> This issue will be set straight, so someone responsilble for those
> issue will adress MySQL community.
> 
> --
> Regards,
>__  ___ ___   __
>   /  |/  /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]>
>  / /|_/ / // /\ \/ /_/ / /__   MySQL AB, FullTime Developer
> /_/  /_/\_, /___/\___\_\___/   Larnaca, Cyprus
><___/   www.mysql.com
> 

I'm also advertising for MySQL all over my site with the original logo.

Do I need to remove it?  I'd rather not, since it's just a link to point people
to a valuable resource.  Is my site violating the terms of the trademark?

Van
-- 
=
Linux rocks!!!   http://www.dedserius.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: multiple PRI indexes

[David Turner]

He may mean a composite primary key, which is a primary key based on two columns. On
whether this is a good idea or not it's really a question of whether you want to use 
natural or surrogate keys on your tables. 

A composite key is typically a natural key. A natural key is a key with information
attached to the columns in the key. Examples of a natural key would be a user's email
address. The problem with natural keys is that the data in the key frequently needs
to be changed. In the example of an email address as the key you would have to update
the key whenever anyone changed their email. Also on performance , joins tend to be
slower because the natural keys take more space then say a number to uniquely identify
the row.

I prefer surrogate keys which are keys that don't have any information tied to them. 
They are simply a sequence or autoincrement. Their only purpose is to to uniquely 
identify 
the row. They're better on join performance and you don't find people updating them 
because 
of changes in the data. 

If I were he, I would create an additional autoincrement field for the primary key and 
create a
unique index on the two fields he planned on being the primary key.

Dave Turner


On Wed, Aug 29, 2001 at 12:22:22PM -0500, Paul DuBois wrote:
> At 10:33 AM -0500 8/29/01, shawn reed wrote:
> >is it generally recommended / a good idea to have more than one PRI index
> >in the same table?  i've never seen that before until today while trying
> >to track down bugs in someone else's system and noticed a table with 2 PRI
> >indexes.  will this cause any problems?
> 
> ?
> 
> In MySQL, you cannot have two PRIMARY KEY indexes.  You can have a PRIMARY
> KEY and and a UNIQUE index, or two UNIQUE indexes, but that's a slightly
> different situation.
> 
> >
> >tia.
> >
> >~shawn
> >
> >
> >-
> >Before posting, please check:
> >http://www.mysql.com/manual.php   (the manual)
> >http://lists.mysql.com/   (the list archive)
> >
> >To request this thread, e-mail <[EMAIL PROTECTED]>
> >To unsubscribe, e-mail <[EMAIL PROTECTED]>
> >Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
> 
> 
> -- 
> Paul DuBois, [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

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

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 Problem

[Morten Søndergaard]

i have a MySQL DB whit this tabel:

Id  ColPoint  CntDateTime  Cnt1  Cnt2 Cntx. Cnt32
11  2001-08-01 00:05:0012  14  
21  2001-08-01 00:10:0011  12  
31  2001-08-01 00:15:00109  
41  2001-08-01 00:20:00032  
51  2001-08-01 00:25:0064  
61  2001-08-01 00:30:0014  22  
71  2001-08-01 00:35:0011  17  
.
.

x122001-08-01 00:05:00324  
x222001-08-01 00:10:0031  22  
x322001-08-01 00:15:0030  19  
x422001-08-01 00:20:00022  
x522001-08-01 00:25:0026  14  
x622001-08-01 00:30:0024  22  
x72   2001-08-01 00:35:001  17  
.
.

Ect.
I am collecting data from 8 collecting points whit 32 counters each

I have made a delphi program to show the data in bars or curves, but the
uses shal
have the opportunite to add and subtrach the datas

Exampel for user 1
ColPoint(Cnt1) +ColPoint5(Cnt3) -ColPoint2(Cnt11)

How can i build a sql-string that satisfied this need




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

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

Group by

[Morten Søndergaard]

i have a tabel whit 5 min counting

Id  CntDateTime  Cnt1
1  2001-08-01 00:05:0012
2  2001-08-01 00:10:0011
3  2001-08-01 00:15:0010
4  2001-08-01 00:20:000
5  2001-08-01 00:25:006
6  2001-08-01 00:30:0014
7  2001-08-01 00:35:0011
.
.
What i want is to make a Select/group by, so tha i do have  15. min.
countings

The Resultatet of my SELECT shall be:

  CntDateTime  Cnt1
  2001-08-01 00:05:0033
  2001-08-01 00:20:0020
  2001-08-01 00:35:00xx


It can be made in acces whit this sql-string

SELECT Sum([CountTabel].[cnt1]) AS hmm, Year([CntDateTime]) &
Month([CntDateTime]) & Day([CntDateTime]) & Hour([CntDateTime]) &
Minute([CntDateTime])-(Minute([CntDateTime]) Mod 15)
FROM CountTabel
GROUP BY (Year([CntDateTime]) & Month([CntDateTime]) & Day([CntDateTime]) &
Hour([CntDateTime]) & Minute([CntDateTime])-(Minute([CntDateTime]) Mod 15));

Can anybody translate it to a working SQL-statement


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

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: Use of the MySQL logo - licensing agreement

[B. van Ouwerkerk]

At 16:10 29-8-01 +0100, Andrew Murphy wrote:
>Why not get MySQL to make a series of slightly different logos you can
>choose from like Sun and other companies do. Some are colour, others
>greyscale, and some are inverse for placement on black backgrounds.

It would still violate their trademark cause it's a look-alike. Legally the 
only way is to ask permission to the owner of the trademark.

Bye,



B.


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

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 get mysqld to start

[Sheena Sidhu]

Dana,
 Thanks for looking into this further. I did all that, and ran the
command mysql_install_db instead of mysql_install_db --user=mysql & as they
said in the install guide! I have no clue of the difference between the two
and reason why it should work on one and not on another.
Would appreciate if you could shed some light on this.

Thanks,
Sheena.

-Original Message-
From: Dana Powers [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, August 28, 2001 4:20 PM
To: Sheena Sidhu; Mysql (E-mail)
Subject: Re: cannot get mysqld to start


This is covered in the mysql manual here:
http://www.mysql.com/doc/P/o/Post-installation.html

First, you need to install the default databases ( installs
mysql/host.frm ):

bash> mysql_install_db

Then tell mysql not to use InnoDB:
put this in your /etc/my.cnf file:

[mysqld]
skip-innodb


dpk

- Original Message -
From: "Sheena Sidhu" <[EMAIL PROTECTED]>
To: "Mysql (E-mail)" <[EMAIL PROTECTED]>
Sent: Tuesday, August 28, 2001 2:42 PM
Subject: cannot get mysqld to start


> Hello,
>   I just installed mysql-max-3.23.41 on Linux. All went smooth but
> alas cannot get myqld to start. here is the log from the .err
> file in mysql/data directory:
>
> 010828 14:26:30  mysqld started
> Can't initialize InnoDB as 'innodb_data_file_path' is not set
> 010828 14:26:30
/usr/local/mysql-max-3.23.41-pc-linux-gnu-i686/bin/mysqld:
> Can't find file: './mysql/host.frm' (errno: 13)
> 010828 14:26:30  mysqld ended
>
> Now, I am interested in BDB only, so don't care about Innodb. Seems like I
> have to . But what do I do about the host.frm file ?
> Gosh , can someone PLEASE help me here ???
>
> Thanks,
> Sheena.
>
> -
> Before posting, please check:
>http://www.mysql.com/manual.php   (the manual)
>http://lists.mysql.com/   (the list archive)
>
> 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

Hot Backups

[Matthew Walker]

What's the best way of doing a hot backup on a database? Our server is
set up in such a way that it's not a simple matter to shut down
apache/mysql and do the backup then. So, is it safe to just copy the
mysql directories, or is there some recommended procedure for this?

Matthew Walker
System Administrator
Mountain Top Herbs




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

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: Hot Backups

[David Turner]

The way I am planning on doing it is setting up another server that I replicated to
and backing that server up. I would like to hear how other people are backing up 
servers
without interupting service.

Dave
On Wed, Aug 29, 2001 at 12:50:06PM -0600, Matthew Walker wrote:
> What's the best way of doing a hot backup on a database? Our server is
> set up in such a way that it's not a simple matter to shut down
> apache/mysql and do the backup then. So, is it safe to just copy the
> mysql directories, or is there some recommended procedure for this?
> 
> Matthew Walker
> System Administrator
> Mountain Top Herbs
> 
> 
> 
> 
> -
> Before posting, please check:
>http://www.mysql.com/manual.php   (the manual)
>http://lists.mysql.com/   (the list archive)
> 
> 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: SQL Problem

[Adams, Bill TQO]

SELECT (t1.cnt1 + t2.cnt3 - t3.cnt11) FROM table
t1, table t2, table t3 WHERE t1.ColPoint=1 AND
t2.ColPoint=5 AND t3.ColPoint=2 AND t1.id=1 AND
t2.id=t1.id AND t3.id=t1.id

Of course, self joins can be expensive, this grows
in complexity as you need to add/subtract more
counts ,and this is not general.

--Bill


Morten Søndergaard wrote:

> i have a MySQL DB whit this tabel:
>
> Id  ColPoint  CntDateTime  Cnt1  Cnt2
> Cntx. Cnt32
> 11  2001-08-01 00:05:0012  14
> 
> 21  2001-08-01 00:10:0011  12
> 
> 31  2001-08-01 00:15:00109
> 
> 41  2001-08-01 00:20:00032
> 
> 51  2001-08-01 00:25:0064
> 
> 61  2001-08-01 00:30:0014  22
> 
> 71  2001-08-01 00:35:0011  17
> 
> .
> .
>
> x122001-08-01 00:05:00324
> 
> x222001-08-01 00:10:0031  22
> 
> x322001-08-01 00:15:0030  19
> 
> x422001-08-01 00:20:00022
> 
> x522001-08-01 00:25:0026  14
> 
> x622001-08-01 00:30:0024  22
> 
> x72   2001-08-01 00:35:001  17  
>
> .
> .
>
> Ect.
> I am collecting data from 8 collecting points
> whit 32 counters each
>
> I have made a delphi program to show the data in
> bars or curves, but the
> uses shal
> have the opportunite to add and subtrach the
> datas
>
> Exampel for user 1
> ColPoint(Cnt1) +ColPoint5(Cnt3)
> -ColPoint2(Cnt11)
>
> How can i build a sql-string that satisfied this
> need
>
> 
> 
>
> Before posting, please check:
>http://www.mysql.com/manual.php   (the
> manual)
>http://lists.mysql.com/   (the list
> archive)
>
> To request this thread, e-mail
> <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
> <[EMAIL PROTECTED]>
>
> Trouble unsubscribing? Try:
> http://lists.mysql.com/php/unsubscribe.php

--
Bill Adams
TriQuint Semiconductor






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

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: Hot Backups

[Joshua J. Kugler]

I'm doing a mysqldump and then backing up the resulting text file.  Works 
fine, doesn't interupt anything, and doesn't have any problems with a live 
server.  IIRC, mysqldump locks a table before it dumps, so there won't be any 
funny records.  Or course, mysqldump could catch the database in the middle 
of a multi-table backup.  But so can any live backup system.

j- k-

On Wednesday 29 August 2001 10:52, David Turner wrote:
> The way I am planning on doing it is setting up another server that I
> replicated to and backing that server up. I would like to hear how other
> people are backing up servers without interupting service.
>
> Dave
>
> On Wed, Aug 29, 2001 at 12:50:06PM -0600, Matthew Walker wrote:
> > What's the best way of doing a hot backup on a database? Our server is
> > set up in such a way that it's not a simple matter to shut down
> > apache/mysql and do the backup then. So, is it safe to just copy the
> > mysql directories, or is there some recommended procedure for this?

-- 
Joshua Kugler, Information Services Director
Associated Students of the University of Alaska Fairbanks
[EMAIL PROTECTED], 907-474-7601

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

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: Hot Backups

[David Turner]

Any problems with data inconsistencies?

Dave
On Wed, Aug 29, 2001 at 10:52:26AM -0800, Joshua J. Kugler wrote:
> I'm doing a mysqldump and then backing up the resulting text file.  Works 
> fine, doesn't interupt anything, and doesn't have any problems with a live 
> server.  IIRC, mysqldump locks a table before it dumps, so there won't be any 
> funny records.  Or course, mysqldump could catch the database in the middle 
> of a multi-table backup.  But so can any live backup system.
> 
> j- k-
> 
> On Wednesday 29 August 2001 10:52, David Turner wrote:
> > The way I am planning on doing it is setting up another server that I
> > replicated to and backing that server up. I would like to hear how other
> > people are backing up servers without interupting service.
> >
> > Dave
> >
> > On Wed, Aug 29, 2001 at 12:50:06PM -0600, Matthew Walker wrote:
> > > What's the best way of doing a hot backup on a database? Our server is
> > > set up in such a way that it's not a simple matter to shut down
> > > apache/mysql and do the backup then. So, is it safe to just copy the
> > > mysql directories, or is there some recommended procedure for this?
> 
> -- 
> Joshua Kugler, Information Services Director
> Associated Students of the University of Alaska Fairbanks
> [EMAIL PROTECTED], 907-474-7601

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

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: Hot Backups

[David Turner]

Didn't read your last item before  I fired my last message off. If mysqldump locks the
table before it dumps then it is interupting service. If I have a high number of
transactions they're blocked until the lock is released.

Dave
On Wed, Aug 29, 2001 at 10:52:26AM -0800, Joshua J. Kugler wrote:
> I'm doing a mysqldump and then backing up the resulting text file.  Works 
> fine, doesn't interupt anything, and doesn't have any problems with a live 
> server.  IIRC, mysqldump locks a table before it dumps, so there won't be any 
> funny records.  Or course, mysqldump could catch the database in the middle 
> of a multi-table backup.  But so can any live backup system.
> 
> j- k-
> 
> On Wednesday 29 August 2001 10:52, David Turner wrote:
> > The way I am planning on doing it is setting up another server that I
> > replicated to and backing that server up. I would like to hear how other
> > people are backing up servers without interupting service.
> >
> > Dave
> >
> > On Wed, Aug 29, 2001 at 12:50:06PM -0600, Matthew Walker wrote:
> > > What's the best way of doing a hot backup on a database? Our server is
> > > set up in such a way that it's not a simple matter to shut down
> > > apache/mysql and do the backup then. So, is it safe to just copy the
> > > mysql directories, or is there some recommended procedure for this?
> 
> -- 
> Joshua Kugler, Information Services Director
> Associated Students of the University of Alaska Fairbanks
> [EMAIL PROTECTED], 907-474-7601

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

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: Group by

[Don Read]

On 29-Aug-2001 Morten Søndergaard wrote:
> i have a tabel whit 5 min counting
> 
> Id  CntDateTime  Cnt1
> 1  2001-08-01 00:05:0012
> 2  2001-08-01 00:10:0011
> 3  2001-08-01 00:15:0010
> 4  2001-08-01 00:20:000
> 5  2001-08-01 00:25:006
> 6  2001-08-01 00:30:0014
> 7  2001-08-01 00:35:0011
> .
> .
> What i want is to make a Select/group by, so tha i do have  15. min.
> countings
> 
> The Resultatet of my SELECT shall be:
> 
>   CntDateTime  Cnt1
>   2001-08-01 00:05:0033
>   2001-08-01 00:20:0020
>   2001-08-01 00:35:00xx
> 
> 
> It can be made in acces whit this sql-string
> 
> SELECT Sum([CountTabel].[cnt1]) AS hmm, Year([CntDateTime]) &
> Month([CntDateTime]) & Day([CntDateTime]) & Hour([CntDateTime]) &
> Minute([CntDateTime])-(Minute([CntDateTime]) Mod 15)
> FROM CountTabel
> GROUP BY (Year([CntDateTime]) & Month([CntDateTime]) & Day([CntDateTime]) &
> Hour([CntDateTime]) & Minute([CntDateTime])-(Minute([CntDateTime]) Mod 15));
> 
> Can anybody translate it to a working SQL-statement
> 
> 

try :
select concat(left(CntDateTime,14), round(minute(CntDateTime) /15) *15) as dt,
sum(Cnt1) as cnt fromo foo group by dt;

Regards,
-- 
Don Read   [EMAIL PROTECTED]
-- It's always darkest before the dawn. So if you are going to 
   steal the neighbor's newspaper, that's the time to do it.
(53kr33t w0rdz: sql table 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: Hot Backups

[Matthew Walker]

I've tried using mysqldump, and it doesn't seem to be working on our
computer. A little more info on our setup is in order, I think.

We're running on Iserver, and have a virtual BSD machine. Most of the
binaries are in the 'true' machine's folders, and a few are in our
virtual machine's folders. I'm not sure if this is what's messing up
mysqldump, but when I tried to use it as the manual describes, it
refused to output anything but the helpfile.

-Original Message-
From: Joshua J. Kugler [mailto:[EMAIL PROTECTED]] 
Sent: Wednesday, August 29, 2001 12:52 PM
To: David Turner; Matthew Walker
Cc: MySQL Mailling List
Subject: Re: Hot Backups

I'm doing a mysqldump and then backing up the resulting text file.
Works 
fine, doesn't interupt anything, and doesn't have any problems with a
live 
server.  IIRC, mysqldump locks a table before it dumps, so there won't
be any 
funny records.  Or course, mysqldump could catch the database in the
middle 
of a multi-table backup.  But so can any live backup system.

j- k-

On Wednesday 29 August 2001 10:52, David Turner wrote:
> The way I am planning on doing it is setting up another server that I
> replicated to and backing that server up. I would like to hear how
other
> people are backing up servers without interupting service.
>
> Dave
>
> On Wed, Aug 29, 2001 at 12:50:06PM -0600, Matthew Walker wrote:
> > What's the best way of doing a hot backup on a database? Our server
is
> > set up in such a way that it's not a simple matter to shut down
> > apache/mysql and do the backup then. So, is it safe to just copy the
> > mysql directories, or is there some recommended procedure for this?

-- 
Joshua Kugler, Information Services Director
Associated Students of the University of Alaska Fairbanks
[EMAIL PROTECTED], 907-474-7601

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

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: Hot Backups

[Barry L. Jeung]

First of all, I'd like to point to the documentation =]

http://www.mysql.com/doc/B/a/Backup.html

The other option not mentioned there but that another list member
suggested is the best way to backup a live database. The above two
methods work, but with larger databases, having the tables locked for
more than a few seconds while you back them up can cause timeouts.
Having a second machine with replication lets you back up the database
without this concern, and also gives you the benefit of having a server
to replace your primary server should it fail. Also note that if your
second server (replica) will never see production, then it can get by
with significantly lower machine requirements than any production server
since it won't be serving any queries or such. HTH
> -Original Message-
> From: Joshua J. Kugler [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, August 29, 2001 11:52 AM
> To: David Turner; Matthew Walker
> Cc: MySQL Mailling List
> Subject: Re: Hot Backups
> 
> 
> I'm doing a mysqldump and then backing up the resulting text 
> file.  Works 
> fine, doesn't interupt anything, and doesn't have any 
> problems with a live 
> server.  IIRC, mysqldump locks a table before it dumps, so 
> there won't be any 
> funny records.  Or course, mysqldump could catch the database 
> in the middle 
> of a multi-table backup.  But so can any live backup system.
> 
> j- k-
>
> 

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

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 get mysqld to start

[Dana Powers]

Quoteth the install guide:

shell> cd mysql_installation_directory
shell> ./bin/mysql_install_db
shell> ./bin/safe_mysqld --user=mysql &

This is always the way to start a fresh mysql install.
Note that safe_mysqld gets the --user arg ( and is run in the background
with & ).
Also remember to set your root password! Check the manual for this as well.
dpk


- Original Message -
From: "Sheena Sidhu" <[EMAIL PROTECTED]>
To: "Dana Powers" <[EMAIL PROTECTED]>; "Sheena Sidhu"
<[EMAIL PROTECTED]>; "Mysql (E-mail)" <[EMAIL PROTECTED]>
Sent: Wednesday, August 29, 2001 11:41 AM
Subject: RE: cannot get mysqld to start


> Dana,
>  Thanks for looking into this further. I did all that, and ran the
> command mysql_install_db instead of mysql_install_db --user=mysql & as
they
> said in the install guide! I have no clue of the difference between the
two
> and reason why it should work on one and not on another.
> Would appreciate if you could shed some light on this.
>
> Thanks,
> Sheena.
>
> -Original Message-
> From: Dana Powers [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, August 28, 2001 4:20 PM
> To: Sheena Sidhu; Mysql (E-mail)
> Subject: Re: cannot get mysqld to start
>
>
> This is covered in the mysql manual here:
> http://www.mysql.com/doc/P/o/Post-installation.html
>
> First, you need to install the default databases ( installs
> mysql/host.frm ):
>
> bash> mysql_install_db
>
> Then tell mysql not to use InnoDB:
> put this in your /etc/my.cnf file:
> 
> [mysqld]
> skip-innodb
> 
>
> dpk
>
> - Original Message -
> From: "Sheena Sidhu" <[EMAIL PROTECTED]>
> To: "Mysql (E-mail)" <[EMAIL PROTECTED]>
> Sent: Tuesday, August 28, 2001 2:42 PM
> Subject: cannot get mysqld to start
>
>
> > Hello,
> >   I just installed mysql-max-3.23.41 on Linux. All went smooth
but
> > alas cannot get myqld to start. here is the log from the
.err
> > file in mysql/data directory:
> >
> > 010828 14:26:30  mysqld started
> > Can't initialize InnoDB as 'innodb_data_file_path' is not set
> > 010828 14:26:30
> /usr/local/mysql-max-3.23.41-pc-linux-gnu-i686/bin/mysqld:
> > Can't find file: './mysql/host.frm' (errno: 13)
> > 010828 14:26:30  mysqld ended
> >
> > Now, I am interested in BDB only, so don't care about Innodb. Seems like
I
> > have to . But what do I do about the host.frm file ?
> > Gosh , can someone PLEASE help me here ???
> >
> > Thanks,
> > Sheena.
> >
> > -
> > Before posting, please check:
> >http://www.mysql.com/manual.php   (the manual)
> >http://lists.mysql.com/   (the list archive)
> >
> > 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: cannot get mysqld to start

[Sheena Sidhu]

HMM. Now I dont know why I always failed to get mysql up with the 'right'
command... I am looking into setting my root password right now But
please tell me if I am doing something wrong by running just safe_mysqld
instead of with the parameters...

Thanks,
Sheena.

-Original Message-
From: Dana Powers [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, August 29, 2001 12:19 PM
To: Sheena Sidhu; Mysql (E-mail)
Subject: Re: cannot get mysqld to start


Quoteth the install guide:

shell> cd mysql_installation_directory
shell> ./bin/mysql_install_db
shell> ./bin/safe_mysqld --user=mysql &

This is always the way to start a fresh mysql install.
Note that safe_mysqld gets the --user arg ( and is run in the background
with & ).
Also remember to set your root password! Check the manual for this as well.
dpk


- Original Message -
From: "Sheena Sidhu" <[EMAIL PROTECTED]>
To: "Dana Powers" <[EMAIL PROTECTED]>; "Sheena Sidhu"
<[EMAIL PROTECTED]>; "Mysql (E-mail)" <[EMAIL PROTECTED]>
Sent: Wednesday, August 29, 2001 11:41 AM
Subject: RE: cannot get mysqld to start


> Dana,
>  Thanks for looking into this further. I did all that, and ran the
> command mysql_install_db instead of mysql_install_db --user=mysql & as
they
> said in the install guide! I have no clue of the difference between the
two
> and reason why it should work on one and not on another.
> Would appreciate if you could shed some light on this.
>
> Thanks,
> Sheena.
>
> -Original Message-
> From: Dana Powers [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, August 28, 2001 4:20 PM
> To: Sheena Sidhu; Mysql (E-mail)
> Subject: Re: cannot get mysqld to start
>
>
> This is covered in the mysql manual here:
> http://www.mysql.com/doc/P/o/Post-installation.html
>
> First, you need to install the default databases ( installs
> mysql/host.frm ):
>
> bash> mysql_install_db
>
> Then tell mysql not to use InnoDB:
> put this in your /etc/my.cnf file:
> 
> [mysqld]
> skip-innodb
> 
>
> dpk
>
> - Original Message -
> From: "Sheena Sidhu" <[EMAIL PROTECTED]>
> To: "Mysql (E-mail)" <[EMAIL PROTECTED]>
> Sent: Tuesday, August 28, 2001 2:42 PM
> Subject: cannot get mysqld to start
>
>
> > Hello,
> >   I just installed mysql-max-3.23.41 on Linux. All went smooth
but
> > alas cannot get myqld to start. here is the log from the
.err
> > file in mysql/data directory:
> >
> > 010828 14:26:30  mysqld started
> > Can't initialize InnoDB as 'innodb_data_file_path' is not set
> > 010828 14:26:30
> /usr/local/mysql-max-3.23.41-pc-linux-gnu-i686/bin/mysqld:
> > Can't find file: './mysql/host.frm' (errno: 13)
> > 010828 14:26:30  mysqld ended
> >
> > Now, I am interested in BDB only, so don't care about Innodb. Seems like
I
> > have to . But what do I do about the host.frm file ?
> > Gosh , can someone PLEASE help me here ???
> >
> > Thanks,
> > Sheena.
> >
> > -
> > Before posting, please check:
> >http://www.mysql.com/manual.php   (the manual)
> >http://lists.mysql.com/   (the list archive)
> >
> > 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

discussion: mysql licensing issue and funding issues

[Neil Zanella]

I would like to comment on the following mysql.com question

 "We have made our product available at zero price under the GNU
 General Public Licence (GPL), and we also sell it under a commercial
 licence to those who do not wish to be bound by the terms of the GPL."

Out of curiosity, how does the second statement
not violate the GNU GPL? It seems like the GPL
can be bypassed by keeping two identical copies
of the source code, one under the GNU GPL bundled
with the GNU licence file called COPYING, and
another bundled with a proprietary license file.
Since the two source files can be considered as
being updated separately the two licenses can
be kept alive concurrently. This approach which
as I see it is perfactly legal (as long as it
is made clear which is the GPL'd release and
which is the proprietary release on the download
section of the mysqld.com web site) can lead
to forking. In particular, contributions made
to the GPL'd source code cannot be applied to
the proprietary source code unless the contributor
explicitly states that the contribution goes
to both the GPL'd software release and the
proprietary source code simultaneously.

Personally I would consider it ethical that
contributors provide patches to both the
commercial and GPL'd versions of mysql
simultaneously just as mysql developers
have kindly donated their code to the
community by placing it under the GPL.
It is my hope that more cooperation
will take place in the future.

This reminds me of something like
the emacs/xemacs split with the
sole difference of a licensing
issue. Personally, in the near
future there may be three
distributions (which is unfortunate):

(1) the mysql.com proprietary distribution
(2) the mysql.com GPL'd distribution (identical to 1)
(3) the mysql.org GPL'd distribution

mysql.org will not be able to start a proprietary
distribution as it would violate the GPL. The
reason mysql.com can have a proprietary distribution
is that they are the authors, as explained above.

I do not believe that the mysql.org folks have the
experience to improve on mysql otherwise they would
have started "theirsql" from scratch. For this very
reason I would urge mysql.com and mysql.org to come
to some compromise that would avoid the uglyness of
what I deem as unnecessary code forking. Let us not
have two separate code versions of mysql.
Let us all cooperate.

Also, how is mysql.org's funding strategy any better
than mysql.com? The two parties should perhaps merge.
Having two mysql's will simply weaken mysql's
popularity if there is no cooperation among
the two parties.


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

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: discussion: mysql licensing issue and funding issues

[Trond Eivind Glomsrød]

Neil Zanella <[EMAIL PROTECTED]> writes:

> I would like to comment on the following mysql.com question
> 
>  "We have made our product available at zero price under the GNU
>  General Public Licence (GPL), and we also sell it under a commercial
>  licence to those who do not wish to be bound by the terms of the GPL."
> 
> Out of curiosity, how does the second statement
> not violate the GNU GPL? 

They own the code, they can give it out under different licenses if
they like.

> In particular, contributions made to the GPL'd source code cannot be applied to
> the proprietary source code unless the contributor explicitly states that the 
>contribution goes
> to both the GPL'd software release and the proprietary source code
> simultaneously.

Which I'm pretty sure they're doing - no code accepted if it doesn't
satisfy their demands.

> This reminds me of something like the emacs/xemacs split with the
> sole difference of a licensing issue.

That has nothing to do with licensing - different groups of developers
have different targets (eyecandy vs. stability and speed ;) and
processes. 

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

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

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

Re: New kid on the block ...

[Csaba Horvath]

Hi,

We have developped commercial windows application using a software called
DataEase. We need a more professional development system and are presently
researching such a product. I checked the MySQL manual and the field types
needed are supported. Our basic question is whether or not MySQL can handle
the job of running under all version of windows in all different types of
configurations (networks). We would want our code in MySQL to be compiled. I
understand that its a backend, but we would still have proprietary formulas
and calculations that would need protection. We haven't worked with SQL in
quite some time so its a bit unfamiliar territory for us...

Any comments and suggestions would be greatly appreciated !!

Thanks,

Csaba Horvath
Service Info-Rapide Inc,
Tel: (514) 990-6574
Fax: (450) 670-8425


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

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: Setting User Privileges ? Confused !!

[Dennis Herndon]

I have the same problem and have looked all over for the solution.  You have
to delete the anonymous user from which table?  I would assume the users
table?

-Original Message-
From: Roman Festchook [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, August 29, 2001 10:05
To: Peter Moscatt; MySQL List
Subject: Re: Setting User Privilges ? Confused !!


By default you have record for anonimous user with any name and no pass in 
your access tables, thats lock access any other user from localhost with 
password to database. Just delete this anonimous user from mysql access
tables

On Wed 29 Aug 2001 13:08, Peter Moscatt wrote:
> I am pretty new to MySQL, in fact that also covers Linux as well.
>
> I have Mandrake 8.0 which I have installed MySQL using the RPM format.
>  I plan to write code (python) to access the database to manage what
> data it may hold.
>
> The server automatically starts on boot - which is fine.
>
> To be able to do anything with MySQL I have to be logged on as 'root'
>
> If I try to access the database I have created under my normal logon
> ('pmoscatt') I get the following error message:
>
> ERROR 1044: Access denied for user '@localhost' to database 'MCMaint'
>
> I have read the manual to see how I can get around this but find it
> confusing.
>
> Can anyone help me to allow me to access databases under my normal user
> account.
>
> Pete
>
>
>
> -
> Before posting, please check:
>http://www.mysql.com/manual.php   (the manual)
>http://lists.mysql.com/   (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
<[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

-- 
Roman Festchook
Network Engineer
ISP ORTA Polesye
http://www.polesye.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

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

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

MERGE TABLES

[Johnny Withers]

I'm not sure if this is a bug or if this is the way MERGE TABLES works
in MySQL.

It seems that if I have an INDEX in a field (id for instance), and I try
to
SELECT using a WHERE id=NUMBER, it will fail, even though that NUMBER is
a
valid id. ID is an int unsigned field with a key on it. However, when I
drop
the key, everything works as expected..

Is this a bug?

(also if I tried to ORDER BY id, while indexed, that didn't work either)

mysql> desc all_records;
+---+--+--+-+-+---+
| Field | Type | Null | Key | Default | Extra |
+---+--+--+-+-+---+
| id| int(10) unsigned |  | | 0   |   |
| field1| varchar(48)  | YES  | | NULL|   |
| field2| varchar(6)   | YES  | | NULL|   |
| field3| varchar(25)  | YES  | | NULL|   |
| field4| varchar(10)  | YES  | | NULL|   |
| field5| int(10) unsigned |  | | 0   |   |
| field6| int(10) unsigned |  | | 0   |   |
| pages | int(10) unsigned |  | | 0   |   |
| file_name | varchar(10)  | YES  | | NULL|   |
| catalog   | int(10) unsigned |  | | 0   |   |
| keywords  | varchar(255) | YES  | | NULL|   |
+---+--+--+-+-+---+


Here is some output from mysql client (before dropping keys):

mysql> select id from all_records where id=1;  
++
| id |
++
| 13 |
++
1 row in set (0.00 sec)


mysql> select * from all_records where id=12;
Empty set (0.01 sec)

however...

mysql> select id from all_records;
+-+
| id  |
+-+
|  .. |
|  12 |
|  .. |
-
336 rows in set (0.01 sec)

ID 12 does exist in all_records..

-
mysql> alter table all_records drop key id_key;
Query OK, 0 rows affected (0.00 sec)
Records: 0  Duplicates: 0  Warnings: 0

After dropping keys:

mysql> select * from all_records where id=240; 
+-+
| id  |
+-+
| 240 |
+-+
1 row in set (0.00 sec)

mysql> select * from all_records where id=158;
+-+
| id  |
+-+
| 158 |
+-+
1 row in set (0.00 sec)


everything works as expected...

System Information:
(mysql installed from RPM)
mysql  Ver 11.15 Distrib 3.23.39, for pc-linux-gnu (i686)
RedHat 7.0
Linux x.xx.xxx 2.4.8 #3 SMP Tue Aug 14 09:47:47 CDT 2001 i686
unknown




-
Johnny Withers
[EMAIL PROTECTED]
p. 601.853.0211
c. 601.209.4985
 


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

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

Licensing terms for an Intranet site

[John Meyer]

If I'm using MySQL for an intranet site within my corporation, is there any 
licensing required?


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

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: Licensing terms for an Intranet site

[Jeremy Zawodny]

On Wed, Aug 29, 2001 at 02:17:56PM -0700, John Meyer wrote:

> If I'm using MySQL for an intranet site within my corporation, is
> there any licensing required?

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

MySQL 3.23.41-max: up 12 days, processed 161,304,581 queries (148/sec. avg)

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

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

RE: Licensing terms for an Intranet site

[Mike Tiffee]

"For normal internal use, MySQL costs nothing. You do not have to pay us
(them) if you do not want to."

-Original Message-
From: John Meyer [mailto:[EMAIL PROTECTED]] 
Sent: Wednesday, August 29, 2001 5:18 PM
To: [EMAIL PROTECTED]
Subject: Licensing terms for an Intranet site

If I'm using MySQL for an intranet site within my corporation, is there
any 
licensing required?


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

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: discussion: mysql licensing issue and funding issues

[Carsten H. Pedersen]

> I would like to comment on the following mysql.com question
> 
>  "We have made our product available at zero price under the GNU
>  General Public Licence (GPL), and we also sell it under a commercial
>  licence to those who do not wish to be bound by the terms of the GPL."
> 
> Out of curiosity, how does the second statement
> not violate the GNU GPL?

Because MySQL AB is *not* bound by the GPL. They
*own* the code and are granting *you* a license, 
and that particular license puts some limits
on what *you* may do.

> It seems like the GPL
> can be bypassed by keeping two identical copies
> of the source code, one under the GNU GPL bundled
> with the GNU licence file called COPYING, and
> another bundled with a proprietary license file.
> Since the two source files can be considered as
> being updated separately the two licenses can
> be kept alive concurrently. This approach which
> as I see it is perfactly legal (as long as it
> is made clear which is the GPL'd release and
> which is the proprietary release on the download
> section of the mysqld.com web site) can lead
> to forking.

Yes and no. There is no need to keep two identical
copies. Again: MySQL AB are not bound by the license,
and may do whatever they wish with the code. For that
matter, they are perfectly free to suddenly stop
GPL'ing the source code and switch to distributing
only proprietary sources (which cannot prevent anyone
from using already released GPL distros)

> In particular, contributions made
> to the GPL'd source code cannot be applied to
> the proprietary source code unless the contributor
> explicitly states that the contribution goes
> to both the GPL'd software release and the
> proprietary source code simultaneously.

Which is why MySQL AB requires you to hand over
the copyright of the contribution before they
accept it.

The rest of your mail is based on some misconceptions
regarding copyrigt and licensing, as explained
above.

/ Carsten
--
Carsten H. Pedersen
keeper and maintainer of the bitbybit.dk MySQL FAQ
http://www.bitbybit.dk/mysqlfaq

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

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

Newbie question

[Tom Hicks]

I have put a new web server and would like to put a board on it. But when I
try to I get an error. I know it is a sql error. On the install I did the
configure with apache but I got a few errors. Not sure if I did it right.
Well at this point I need it configured for PHP4 and MySql. PHP4 is working
fine but the MySQL is not. I get this error.

Fatal error: Call to undefined function: mysql_connect() in
/home/httpd/zorum_1_0/forum.php on line 1910

I know this is because apache is not connected or configured to call mysql.
At this point and am wondering if I might be better off to reinstall the 3
rpm's and config them correctly. 

I am running Red Hat 7.1 with Apache/1.3.19 

Any help would be great. I am kind of new to this.. 


Thanks,
Thomas Hicks
IS Inc.
[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

mysqld as root

[Ken Menzel]

Wasn't there something awhile back that was supposed to prevent
running the daemon as root?  When the daemon was started through
safe_mysqld it would tell you to select a user as root you had to
use --user=root,  this seems to be gone!

from the manual:
F.2.26 Changes in release 3.23.15
 To start mysqld as root, you must now use the --user=root option.

This does not seem to be true (tested on freebsd 3.23.41 etc),   the
reason I have a problem with this is I am getting some files owned by
root,  which is a problem if someone restarts mysql as
"safe_mysqld&".  I am adding the user to my.cnf to avoid this, but it
does seem to confict with the manual unless I missed a change note to
remove that feature!


Ken
-
Ken Menzel  ICQ# 9325188
www.icarz.com  [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: Newbie question

[Trond Eivind Glomsrød]

Tom Hicks <[EMAIL PROTECTED]> writes:

> I have put a new web server and would like to put a board on it. But when I
> try to I get an error. I know it is a sql error. On the install I did the
> configure with apache but I got a few errors. Not sure if I did it right.
> Well at this point I need it configured for PHP4 and MySql. PHP4 is working
> fine but the MySQL is not. I get this error.
> 
> Fatal error: Call to undefined function: mysql_connect() in
> /home/httpd/zorum_1_0/forum.php on line 1910
> 
> I know this is because apache is not connected or configured to call mysql.
> At this point and am wondering if I might be better off to reinstall the 3
> rpm's and config them correctly. 
> 
> I am running Red Hat 7.1 with Apache/1.3.19 

You need to install php-mysql.

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

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

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

RE: Newbie question

[Gabriel Carbone]

Is php compiled with the mysql option?



-Mensaje original-
De: Tom Hicks [mailto:[EMAIL PROTECTED]]
Enviado el: Wednesday, August 29, 2001 13:43
Para: '[EMAIL PROTECTED]'
Asunto: Newbie question


I have put a new web server and would like to put a board on it. But when I
try to I get an error. I know it is a sql error. On the install I did the
configure with apache but I got a few errors. Not sure if I did it right.
Well at this point I need it configured for PHP4 and MySql. PHP4 is working
fine but the MySQL is not. I get this error.

Fatal error: Call to undefined function: mysql_connect() in
/home/httpd/zorum_1_0/forum.php on line 1910

I know this is because apache is not connected or configured to call mysql.
At this point and am wondering if I might be better off to reinstall the 3
rpm's and config them correctly. 

I am running Red Hat 7.1 with Apache/1.3.19 

Any help would be great. I am kind of new to this.. 


Thanks,
Thomas Hicks
IS Inc.
[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

Alter table Query

[abhishek sahay]

STEP 1:  status ->SUCCESS
---
mysql> CREATE TABLE pod_rating select h.he_headend_id 'Cable 
Plant',sk.tf_air_date,d.em_dma DMA,d.em_tv_households 'Households 
TVs',d.em_us_percent Population,p.tf_title 'Program Name',sk.tf_air_time 
Time,st.tf_station_call_sign Network from prog_rec p,stat_rec st,sked_rec 
sk,lineup l,headend h,dma d where sk.tf_database_key=p.tf_database_key and 
sk.tf_station_num=st.tf_station_num /* and sk.tf_air_date='2001-04-16'*/ and 
st.tf_station_num=l.cl_station_num  and l.cl_headend_id=h.he_headend_id  and 
h.he_headend_id='NY31656' and d.em_rank=1 GROUP BY 6,8 ORDER BY 2,8,7;
Query OK, 3918 rows affected (2 min 16.73 sec)
Records: 3918  Duplicates: 0  Warnings: 0


STEP 2: status ->SUCCESS

mysql> desc pod_rating;
++--+--+-+-+---+
| Field  | Type | Null | Key | Default | Extra |
++--+--+-+-+---+
| Cable Plant| char(7)  |  | | |   |
| tf_air_date| date | YES  | | NULL|   |
| DMA| char(75) |  | | |   |
| Households TVs | int(11)  |  | | 0   |   |
| Population | decimal(5,3) | YES  | | NULL|   |
| Program Name   | char(120)|  | | |   |
| Time   | smallint(5) unsigned | YES  | | NULL|   |
| Network| char(10) | YES  | | NULL|   |
++--+--+-+-+---+
8 rows in set (0.00 sec)


STEP 3: status ->SUCCESS

mysql> alter table pod_rating change Network Network varchar(15);
Query OK, 3918 rows affected (0.03 sec)
Records: 3918  Duplicates: 0  Warnings: 0


STEP 4: status ->Fail (why???)


mysql> alter table pod_rating change 'Cable Planet' cable_plant varchar(15);
ERROR 1064: You have an error in your SQL syntax near ''Cable Planet' 
cable_plant varchar(15)' at line 1
mysql> alter table pod_rating change "Cable Planet" cable_plant varchar(15);
ERROR 1064: You have an error in your SQL syntax near '"Cable Planet" 
cable_plant varchar(15)' at line 1
mysql> alter table pod_rating change Cable Planet cable_plant varchar(15);
ERROR 1064: You have an error in your SQL syntax near 'cable_plant 
varchar(15)' at line 1
mysql> alter table pod_rating change Cable Planet cable_plant;
ERROR 1064: You have an error in your SQL syntax near 'cable_plant' at line 
1
mysql> alter table pod_rating MODIFY 'Cable Planet' char(10);
ERROR 1064: You have an error in your SQL syntax near ''Cable Planet' 
char(10)' at line 1


Question:
1.I have executed these query in MySQL prompt.I got the correct result in 
step1,2 and step 3 BUT I am not getting correct result in step 4.Could you 
please tell me how to change OR modify "caple planet" ,"Households 
TVs","Households TVs" fields.
2.Is this the problem with MySQL or with my query?
3.I know that while creating table I should not use blank space in a field 
but by mistake i had used space in a field and I was surprised that table 
has created successfully instade of giving logical error.

Waiting for reply...
Regards,
Abhi


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


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

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

Changing auto_increment field in mysql to start at 1000

[Armando Cerna]

I tried this:

update customers set row_id='1000' where row_id='1';

but that only changed the one field in the table and the other ones stayed 
the same =(.  
Could someone please tell me the correct way to do this

Armando


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

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: MERGE TABLES

[Sergei Golubchik]

Hi!

On Aug 29, Johnny Withers wrote:
> I'm not sure if this is a bug or if this is the way MERGE TABLES works
> in MySQL.
> 
> It seems that if I have an INDEX in a field (id for instance), and I try
> to
> SELECT using a WHERE id=NUMBER, it will fail, even though that NUMBER is
> a
> valid id. ID is an int unsigned field with a key on it. However, when I
> drop
> the key, everything works as expected..
> 
> Is this a bug?
> 
> (also if I tried to ORDER BY id, while indexed, that didn't work either)
> 

Both look like a bug.
Could you create a repeatable test case ?

Regards,
Sergei

-- 
MySQL Development Team
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /   Sergei Golubchik <[EMAIL PROTECTED]>
 / /|_/ / // /\ \/ /_/ / /__  MySQL AB, http://www.mysql.com/
/_/  /_/\_, /___/\___\_\___/  Osnabrueck, Germany
   <___/

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

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

Entering data through access

[Scott Inglis]

I attempted to enter data into a msyql database using Access 2000.

I type in data into a field, hit enter and the data is replaced with
"#Deleted".

If I close out the table and open it back up again in Access, the data that
I typed is there.

So the data gets entered correctly.

Anyone know how to get rid of the "#Deleted"?

I did download the latest MDAC from microsofts site and it didnt work..

Thanks,
Scott



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

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