date:20010831


On Thu, Aug 30, 2001 at 12:08:22PM -0700, [EMAIL PROTECTED] wrote:
 Hi People,
 
I'm trying to execute this Simple query:
 
 SET SQL_SAFE_MODE=0;
 
 The server doesn't like it; However, SET any other option will work fine
 except this one.
 
 I'm still using mysqld v3.23.36 . If someone can try it on the
 latest version.

On 3.23.41:

mysql SET SQL_SAFE_MODE=0;
ERROR 1064: You have an error in your SQL syntax near 'SQL_SAFE_MODE=0' at line 1

It would seem to be documented here:

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

But I can't make it work.

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

MySQL 3.23.41-max: up 0 days, processed 3,341,714 queries (93/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: Reply-to and this list

2001-08-31 Thread Claudio Cicali


At 11:13 AM 8/30/01 +0200, Carl Troein wrote:
A quick question: How come the mailing list software
doesn't add a reply-to header? Is this intentional to
keep replies off the mysql list, and if so why?
I'll try to remember to reply to the list rather than
directly to the people who ask the questions, as replying
in private does little to stop the same questions from
reappearing, and if there's something this list has too
much of it's the same questions over and over... :-o


There is also a famous document about reply-to:

http://www.unicom.com/pw/reply-to-harmful.html


--
Claudio Cicali aka FleXer
[EMAIL PROTECTED]
http://www.flexer.it
GPG Key Fingerprint = 2E12 64D5 E5F5 2883 0472 4CFF 3682 E786 555D 25CE


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

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

how to write procedure.

2001-08-31 Thread G.S.Murthy


Hi
I was unable to write stored procedures in windows version of mysql. How
to write a stored procedures in winmysql version.

My mail id is [EMAIL PROTECTED] please mail if any one knows.

GSMurthy



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

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: myisampack dumps core on some tables


On Fri, 31 Aug 2001, Michael Widenius wrote:

  mmokrejs == mmokrejs  iso-8859-2 writes:
 
 mmokrejs On Thu, 30 Aug 2001, Michael Widenius wrote:
 mmokrejs Hi,
 mmokrejs   yes this patch *fixes* all of my problems, except one table which is/was
 mmokrejs probably too big? I haven't found any options that would make myisamchk to
 mmokrejs ask for less memory.
 
 
 mmokrejs /usr/local/mysql/bin/myisamchk: Out of memory (Needed 4294922813 bytes)
 mmokrejs /usr/local/mysql/bin/myisamchk: error: 12 when opening MyISAM-table 
'/data/mysql/Celegans/rep.MYI'
 mmokrejs /usr/local/mysql/bin/myisamchk: Out of memory (Needed 4294922813 bytes)
 mmokrejs /usr/local/mysql/bin/myisamchk: error: 12 when opening MyISAM-table 
'/data/mysql/Celegans/rep.MYI'
 
 No tables should ever be too big for myisamchk.
 What options did you use with myisamchk ?

/usr/local/mysql/bin/myisamchk -f -d /data/mysql/$db/$table.MYI

But even /usr/local/mysql/bin/myisamchk /data/mysql/$db/$table.MYI or with
only -S or only -a. Just everything sensible.

 mmokrejs  Well, the other rep tables are fine. I'm a bit angry about myself,
 mmokrejs because I dropped the Celegans.rep tables:!!!
 
 :(

Well, intentionally. :(

 mmokrejs I managed successfully to run myisamchk -rq on it, myisampack and again
 mmokrejs myisamchk -rq. So now I can only tell you that broken datafile can cause
 mmokrejs myisamchk to ask for too much memory. :(
 
 As you can guess, this doesn't help me to find out where the problem
 is :(

I know.

 mmokrejs   So unfortunately, I don't have the broken table anymore, only the
 mmokrejs screen dumps (size od .MYD and .MYI differed). It seems the
 mmokrejs broken datafile had 6 bytes more, broken index was much smaller.
 mmokrejs That's all I can tell you. ;)
 mmokrejs Maybe it helps.
 
 Unfortunately this doesn't help me to solve this.
 
 If you ever get this problem again, save the tables so that we can
 repeat it and fix the problem!

Sure! Thanks.
-- 
Martin Mokrejs - PGP5.0i key is at http://www.natur.cuni.cz/~mmokrejs
MIPS / Institute for Bioinformatics http://mips.gsf.de
GSF - National Research Center for Environment and Health
Ingolstaedter Landstrasse 1, D-85764 Neuherberg, 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: Reply-to and this list

2001-08-31 Thread Carl Troein


On 31-Aug-01, Claudio Cicali wrote:

 There is also a famous document about reply-to:
 
 http://www.unicom.com/pw/reply-to-harmful.html

Hmm.. good point, but it says nothing about using from: rather
than reply-to. I guess the same arguments could be applied tho.

Maybe I should just bring my Amiga to work and use YAM there too.
It has the nifty feature of defaulting to reply to the list even in cases
like this, unlike that crappy sqwebmail which I'm stuck with there.
(I don't want to use two POP3 clients and have all the confusion that
that usually results in).

And as long as I don't post to the list I won't have the problem of
getting my inbox filled with duplicates of replies. Hmm.. that could
work.

//Círdan - will be quiet now. MySQL newbies go RTFM instead. ;-D

-- 
 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: how to write procedure.

2001-08-31 Thread Jean-Luc Fontaine


Carl Troein wrote:
 On 31-Aug-01, G.S.Murthy wrote:
 
 
Hi
I was unable to write stored procedures in windows version of mysql. How
to write a stored procedures in winmysql version.

 
 Did you read the manual? There's no such thing as stored procedures
 in MySQL. Who told you that there is? :-o

Check out myperl maybe.

-- 
Jean-Luc Fontaine


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

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: Reply-to and this list

2001-08-31 Thread Jason Brooke


 There is also a famous document about reply-to:

 http://www.unicom.com/pw/reply-to-harmful.html


Here's another point of view as well:
http://www.metasystema.org/essays/reply-to-useful.mhtml

As little as it has to do with databases, just for the record I'm on a bunch
of lists - some munge reply-to, some don't. I get used to which list does
what and as I go thru my inboxes, choosing which way to reply is automatic
either way. Personally, I think munging has more going for it than not
munging when it comes to public lists/forums but it's such a tiny issue in
the bigger scope of my day, and it's so easy to do it either way anyway.




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

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

Please help me , about mysql replicate!

2001-08-31 Thread Wang Aocheng


Dear All, 

I have a question:

How can build multi-master-host?

I have 3 mysql hosts,I want to use mysql data replicate. thanks!

wac


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

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

Work Smarter Not Harder? Consider this....

2001-08-31 Thread reports12345


Dear Friends  Future Millionaire:

AS SEEN ON NATIONAL TV:
Due to the popularity of this letter on the Internet, a national weekly news
program recently devoted an entire show to the investigation of this 
program described below, to see if it really can make people money. The 
show also investigated whether or not the program was legal. Yes, it is 
legal. And people are making a lot of money!

Their (and my) findings proved once and for all that there are
absolutely NO laws prohibiting the participation in the program.
The people who are following these instructions are making more 
money than they ever imagined. Keep it simple, just follow the
instructions, and your $25 investment will turn into hundreds of thousands 
of dollars. 

DUE TO THE RECENT INCREASE OF POPULARITY  RESPECT THIS 
PROGRAM HAS ATTAINED, IT IS CURRENTLY WORKING BETTER 
THAN EVER.

==

If you continue to do what you've been doing, you'll continue to have 
what you have.  Do something different and different things will happen!

==

This is what one had to say: ''Thanks to this profitable opportunity. I
was approached many times before but each time I passed on it. I am so
glad I finally joined just to see what one could expect in return for
the minimal effort and money required. To my astonishment, I received
total $610,470.00 in 21 weeks, with money still coming in. Pam Hedland,
Fort Lee, New Jersey.
===
Here is another testimonial: This program has been around for a long
time but I never believed in it. But one day when I received this again
in the mail I decided to gamble my $25 on it. I followed the simple
instructions and 3 weeks later the money started to come in.
First month I only made $240.00 but the next 2 months after that I made
a total of $290,000.00. So far, in the past 8 months by re-entering the
program, I have made over $710,000.00 and I am playing it again. The 
key to success in this program is to follow the simple steps and NOT 
change anything.''

More testimonials later but first,

= PRINT THIS NOW FOR YOUR FUTURE REFERENCE ==
$$
$$$

If you would like to make at least $500,000 every 4 to 5 months easily
And comfortably, please read the following...THEN READ IT AGAIN and
AGAIN!!!

$$
$$$

FOLLOW THE SIMPLE INSTRUCTION BELOW AND YOUR 
FINANCIAL DREAMS WILL COME TRUE, GUARANTEED!

INSTRUCTIONS:

=Order all 5 reports shown on the list below =

For each report, send $5 CASH, THE NAME  NUMBER OF THE 
REPORT YOU ARE ORDERING and YOUR E-MAIL ADDRESS to the 
person whose name appears ON THAT LIST next to the report. MAKE 
SURE YOUR RETURN ADDRESS IS ON YOUR ENVELOPE TOP LEFT 
CORNER in case of any mail problems.

=== When you place your order, make sure you order each of the 5
reports.

You will need all 5 reports so that you can save them on your computer
and resell them.

YOUR TOTAL COST $5 X 5=$25.00.

Within a few days you will receive, vie e-mail, each of the 5 reports
from these 5 different individuals. Save them on your computer so they
will be accessible for you to send to the 1,000's of people who will
order them from you. Also make a floppy of these reports and keep it on
your desk in case something happen to your computer.

IMPORTANT - DO NOT alter the names of the people who are listed next 
to each report, or their sequence on the list, in any way other than what
is instructed below in step '' 1 through 6 '' or you will lose out on
majority of your profits. Once you understand the way this works, you
will also see how it does not work if you change it. Remember, this
method has been tested, and if you alter, it will NOT work !!! People
have tried to put their friends/relatives names on all five thinking
they could get all the money. But it does not work this way. Believe us,
we all have tried to be greedy and then nothing happened.

So Do Not try to change anything other than what is instructed. Because
if you do, it will not work for you. Remember, honesty reaps the
reward!!! Everyone will win if we all do our part.

1 After you have ordered all 5 reports, take this advertisement and
REMOVE the name  address of the person in REPORT # 5. This person
has made it through the cycle and is no doubt counting their fortune.
2 Move the name  address in REPORT # 4 down TO REPORT # 5.
3 Move the name  address in REPORT # 3 down TO REPORT # 4.
4 Move the name  address in REPORT # 2 down TO REPORT # 3.
5 Move the name  address in REPORT # 1 down TO REPORT # 2
6 Insert YOUR name  address in the REPORT # 1 Position.
PLEASE MAKE SURE you copy every name  address ACCURATELY!
==

 Take this entire letter, with the modified list of names, and save
it on your

Is replication inteligent enough for ..... ?

2001-08-31 Thread Warren van der Merwe


mysql


Hi


I have a triangluar replication system working 100%, A --  B, B --  C,
C --  A.

What I know want to know is, is replication intelligent enough that if A had
to sometimes connect to C, and replicate, and then the next day connect to B
again, and so on and so on, would everything still work, or would disaster
strike?

Sometimes I may want to get urgent info through to C, so instead of dialling
into B, and then B dialling into C, I want to Dial C directly from A, but
when the daily connection takes place, A will be connecting to B again, etc
etc ect

Hope I haven't lost everyone

Thanks
Warren


~
Warren van der Merwe
Software Director
PRT Trading (Pty) Ltd t/a RedTie
Durban, South Africa
Cell (+27-83) 262-9163
Office (+27-31) 767-0249



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

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

Window-based client program for MySQL (server in Linux)

2001-08-31 Thread Biniam Gebremichael



I have MySQL server installed in my linux box. And want a windows based
client program that can be used to create and modify table designs and
other functions.

Is there any PHP client for such purpose or any library to enable
Microsoft Access to interface the server.

Thanks
Biniam


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

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

Unknown database problem

2001-08-31 Thread Artem Koutchine


Hi!

I having a very weird unpredictable problem.
A script run from cron at 2:00am every day
must conect to database 'ubex' and do some
stuff with it. The script is in perl and uses DBI.
It works fine pretty much all the time but sometimes
(1 or 2 time per month) it gives an error:

Unknown database 'ubex'

Mysql is 3.23.40, OS is FreeBSD 4.4-RC, Perl is 5.005_03
DBI.pm  is 1.14 (ID: v. 10.32 2000/06/14 20:04:03)
MySQL DBD is 2.0409  (ID: v 1.5 1999/10/03 17:46:19)

The same happens with other databases accessed from
a script run from a cron.

What could be wrong?

Regards,
Artem


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

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: Support Contracts


[EMAIL PROTECTED] writes:
 Anyone,
 
 I apologize for broadcasting to the group, but I've been trying to set-up a 
maintenance contract
 and licenses for about a month and no-one seems to be listening to the sales and 
licensing 
 e-mail drops for MySQL AB Company.
 
 I assume those that are 'in the know' can direct me to some 'reliable' way of 
contacting 
 any? business folks.
 
 Again my apologies for spamming the group.
 
 Thanks,
 Chris

Hi!

You will hear from our sales dept. soon.

-- 
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: Window-based client program for MySQL (server in Linux)

2001-08-31 Thread Arjen G. Lentz


Hi,

- Original Message -
From: Biniam Gebremichael [EMAIL PROTECTED]

 I have MySQL server installed in my linux box. And want a windows based
 client program that can be used to create and modify table designs and
 other functions.

 Is there any PHP client for such purpose

A very nice tool is phpMyAdmin which can be found at
www.phpwizard.net/projects/phpMyAdmin/

 or any library to enable Microsoft Access to interface the server.

This can be done with MyODBC (download from www.mysql.com).
See also the MySQL manual for more details.

Finally, there is MySQLfront (www.mysqlfront.de), a native Windows tool that
can connect directly to MySQL (ie. no MyODBC layer required).


Regards,
Arjen.

--
Get Official MySQL Training Worldwide, http://www.mysql.com/training/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Mr. Arjen G. Lentz [EMAIL PROTECTED]
 / /|_/ / // /\ \/ /_/ / /__   MySQL AB, Technical Writer
/_/  /_/\_, /___/\___\_\___/   Brisbane, QLD Australia
   ___/   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

ERROR 1054 at line 52: Unknown column 'nan' in 'field list'


Hi again,
  I have the following problem:

mysqldump -# --socket=/tmp/mysql.sock --add-drop-table  -f --extended-insert --quick 
Cmuridarum rep | mysql -f --host=pednew -C Cmuridarum
ERROR 1054 at line 52: Unknown column 'nan' in 'field list'

  I have even tried OPTIMIZE TABLE REP; REPAIR TABLE REP;, no luck.
SHOW COLUMNS FROM REP; does NOT show any column name `nan'.

  Even when I use SELECT * FROM REP; and search for  nan , I have no
match.

see pub/mysql/secret/rep.tgz

Thanks for any reply!
PS.: Tested still on linux with 3.23.41 binaries from your website, as
seen in my previous postings.
-- 
Martin Mokrejs - PGP5.0i key is at http://www.natur.cuni.cz/~mmokrejs
MIPS / Institute for Bioinformatics http://mips.gsf.de
GSF - National Research Center for Environment and Health
Ingolstaedter Landstrasse 1, D-85764 Neuherberg, 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

just starting problem - WinNT

2001-08-31 Thread Neil Davies


I am using, well trying to use mysql through WinNT. I have 
successfully installed mysql and have had a look at the client 
programs provided with the package. I'm trying to use mysql 
through the DOS command prompt under Windows but when I type 
C:\mysql I get an error message saying that 'it's an unspecified file, 
program, etc.' Can someone direct me where I'm going wrong.

MySQL is installed under C:\MySQL. I get the same result when I 
try it from an explicit directory 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: just starting problem - WinNT

2001-08-31 Thread Paul Groves

- Original Message -
From: Neil Davies [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, August 31, 2001 12:11 PM
Subject: just starting problem - WinNT

 I am using, well trying to use mysql through WinNT. I have
 successfully installed mysql and have had a look at the client
 programs provided with the package. I'm trying to use mysql
 through the DOS command prompt under Windows but when I type
 C:\mysql I get an error message saying that 'it's an unspecified file,
 program, etc.' Can someone direct me where I'm going wrong.

Have you added c:\mysql\bin to your PATH?

Paul

 MySQL is installed under C:\MySQL. I get the same result when I
 try it from an explicit directory 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]
om
 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

is there facility with replication?

2001-08-31 Thread Kiyoko Takanabe


Dear all.

about to load sharing DB server, 
I'd like to use facility which automatically part and execute requests from client , 
such as : update - Master?load -Slave.

previously,

Client  Master --- Slave
   ^   update|--- Slave
|  +--- Slave
||
   load

well,  I think that I want to facility even more.
Is there useful deamon in like above situation.

1) will be supported with mysql new version (4.0 later? )

in this way,

   Slave -+
   |  
update
   | 
Client  Slave --- Master
 load/updateupdate|
   ---  | 
load|  update
   | 
Slave +

2) is there PATCH or Proxy-daemon and they are provided already?
 (e.g. thus it is  located in between JDBC and mysql-deamon.)

_
 Kiyoko Takanabe - engineer 
 email: mailto:[EMAIL PROTECTED]
 iDimension 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: just starting problem - WinNT

2001-08-31 Thread alec . cawley




 I am using, well trying to use mysql through WinNT. I have
 successfully installed mysql and have had a look at the client
 programs provided with the package. I'm trying to use mysql
 through the DOS command prompt under Windows but when I type
 C:\mysql I get an error message saying that 'it's an unspecified file,
 program, etc.' Can someone direct me where I'm going wrong.

 MySQL is installed under C:\MySQL. I get the same result when I
 try it from an explicit directory too.

The mysql program is (as is often the case for packages) in the bin
subdirectory. Therefore the explicit access path is C:\mysql\bin\mysql.
However, since you will want to access other programs such as mysqladmin,
you probably want to add c:\mysql\bin to your PATH environment variable.

 Alec



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

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 crashes-SOLUTION found!

2001-08-31 Thread moka



I am posting this in the hope it will be useful; I seem 
to have solved the problem. 

The problem was(on 3.23.38) and Linux 2.2.18 or 2.4.0

This is a huge system, all SCSI, 2GB or RAM, 2PIII 
x1000MHz processors and  37GB in the volume group  
corresponding to /var/lib/mysql
There is an AHA29160 SCSI controller.

A scipt was running continuously  getting data into 
Mysql. Every so often the script peformed a mysqldump
The problem was that  at some point when I tried to 
access the  database I would get a crash with error 
code 127.
 repair table of myisamchk -r could fix that, but 
 not all data was  being recovered.
Similarly the dumps were corrupted.

This was apparently caused by timeouts and the solution 
was to pass the boot parameter
 aic7xxx=seltime:0

in lilo.

Perhaps this would be a useful addition to the 
the faqs
S.Alexiou

--
Here are some excerpts from 
/var/lib/mysql/'hostname'.err

010826 21:59:19  mysqld started
/usr/sbin/mysqld: ready for connections
010827 14:05:37  mysqld started
/usr/sbin/mysqld: ready for connections
010827 17:44:12  Aborted connection 171983 to db: 'CDR' 
user: 'spiros' host: `localhost' (Got an error reading 
communication packets)
010827 20:55:39  Aborted connection 513765 to db: 'CDR' 
user: 'spiros' host: `localhost' (Got an error reading 
communication packets)
010827 20:58:34  Aborted connection 521479 to db: 'CDR' 
user: 'spiros' host: `localhost' (Got an error reading 
communication packets)
010827 21:00:34  Aborted connection 524452 to db: 'CDR' 
user: 'spiros' host: `localhost' (Got an error reading 
communication packets)
010827 21:01:57  Aborted connection 529556 to db: 'CDR' 
user: 'spiros' host: `localhost' (Got an error reading 
communication packets)
010827 21:02:52  Aborted connection 533379 to db: 'CDR' 
user: 'spiros' host: `localhost' (Got an error reading 
communication packets)
010827 21:05:40  Aborted connection 540483 to db: 'CDR' 
user: 'spiros' host: `localhost' (Got an error reading 
communication packets)
010827 21:10:50  Aborted connection 554558 to db: 'CDR' 
user: 'spiros' host: `localhost' (Got an error reading 
communication packets)
010827 21:13:50  Aborted connection 556004 to db: 'CDR' 
user: 'spiros' host: `localhost' (Got an error reading 
communication packets)
010827 22:57:44  /usr/sbin/mysqld: Normal shutdown

010827 22:57:45  /usr/sbin/mysqld: Shutdown Complete

010830 18:17:47  mysqld started
/usr/sbin/mysqld: ready for connections
010830 18:45:08  Aborted connection 41658 to db: 'CDR' 
user: 'spiros' host: `localhost' (Got an error reading 
communication packets)
010830 18:49:16  Aborted connection 50975 to db: 'CDR' 
user: 'spiros' host: `localhost' (Got an error reading 
communication packets)
010830 22:03:58  Aborted connection 528901 to db: 'CDR' 
user: 'spiros' host: `localhost' (Got an error reading 
communication packets)
010830 22:18:55  Aborted connection 565805 to db: 'CDR' 
user: 'spiros' host: `localhost' (Got an error reading 
communication packets)
010830 22:42:52  Warning: Found 11 of 17 rows when 
repairing './CDR/CDR_INCOMING_1360_1'
010830 22:56:39  Warning: Found 12 of 16 rows when 
repairing './CDR/CDR_INCOMING_1400_1'
010830 22:58:53  Warning: Found 7 of 12 rows when 
repairing './CDR/CDR_INCOMING_1412_0'
010830 23:00:26  Warning: Found 13 of 27 rows when 
repairing './CDR/CDR_INCOMING_1452_1'
010830 23:01:23  Warning: Found 5 of 18 rows when 
repairing './CDR/CDR_INCOMING_1491_1'
010830 23:02:28  Warning: Found 8 of 12 rows when 
repairing './CDR/CDR_INCOMING_1505_0'
010830 23:03:13  Warning: Found 1 of 6 rows when 
repairing './CDR/CDR_INCOMING_1522_1'
010830 23:09:00  Warning: Found 20 of 27 rows when 
repairing './CDR/CDR_INCOMING_1654_0'
010830 23:17:33  /usr/sbin/mysqld: Normal shutdown

010830 23:17:33  /usr/sbin/mysqld: Shutdown 


Some messages may also show up in /var/log/messages

29:36 quality4 PAM-unix2[1040]: session started for 
user root, service su 
change detected on device fd(2,0)
Aug 25 21:17:07 quality4 kernel: scsi : aborting 
command due to timeout : pid 0, scsi0, channel 0, id 2, 
lun 0 Write (10) 00 03 92 cd 37 00 00 08 00 
Aug 25 21:17:07 quality4 kernel: scsi : aborting 
command due to timeout : pid 0, scsi0, channel 0, id 2, 
lun 0 Write (10) 00 03 92 cd 3f 00 00 08 00 
Aug 25 21:17:07 quality4 kernel: scsi : aborting 
command due to timeout : pid 0, scsi0, channel 0, id 2, 
lun 0 Write (10) 00 03 92 cd 47 00 00 08 00 
Aug 25 21:17:07 quality4 kernel: scsi : aborting 
command due to timeout : pid 0, scsi0, channel 0, id 2, 
lun 0 Write (10) 00 03 92 cd 4f 00 00 08 00 
Aug 25 21:17:07 quality4 kernel: scsi : aborting 
command due to timeout : pid 0, scsi0, channel 0, id 2, 
lun 0 Write (10) 00 03 92 cd 57 00 00 08 00 
Aug 25 21:17:07 quality4 kernel: scsi : aborting 
command due to timeout : pid 0, scsi0, channel 0, id 2, 
lun 0 Write (10) 00 03 92 cd 5f 00 00 08 00 
Aug 25 21:17:07 quality4 kernel: scsi

Re: Is this a bug?


Jeremy Zawodny writes:
 On Thu, Aug 30, 2001 at 12:08:22PM -0700, [EMAIL PROTECTED] wrote:
  Hi People,
  
 I'm trying to execute this Simple query:
  
  SET SQL_SAFE_MODE=0;
  
  The server doesn't like it; However, SET any other option will work fine
  except this one.
  
  I'm still using mysqld v3.23.36 . If someone can try it on the
  latest version.
 
 On 3.23.41:
 
 mysql SET SQL_SAFE_MODE=0;
 ERROR 1064: You have an error in your SQL syntax near 'SQL_SAFE_MODE=0' at line 1
 
 It would seem to be documented here:
 
   http://www.mysql.com/doc/S/E/SET_OPTION.html
 
 But I can't make it work.
 
 Jeremy
 -- 
 Jeremy D. Zawodny, [EMAIL PROTECTED]
 Technical Yahoo - Yahoo Finance
 Desk: (408) 349-7878   Fax: (408) 349-5454   Cell: (408) 685-5936
 
 MySQL 3.23.41-max: up 0 days, processed 3,341,714 queries (93/sec. avg)

It seems to have changed into:

SQL_SAFE_UPDATES

We will have to fix some docs.

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

WHERE IN ( MAX ) in MySQL

2001-08-31 Thread Mattias Jiderhamn


I have a table

  CREATE TABLE currency_rate (
currency_id VARCHAR(3),
currency_date DATE,
currency_rate NUMERIC(16,8),
PRIMARY KEY (currency_id, currency_date)
  );

and want to list the latest registered rates of all currencies.

Normally I would go about like this:
  SELECT currency_rate.currency_id, currency_date, currency_rate
  FROM currency_rate
  WHERE (currency_rate.currency_id, currency_date) IN
  (
SELECT currency_id, MAX(currency_date)
FROM currency_rate
GROUP BY currency_id
  )

But MySQL doesnt support nested selects...
How do I solve this?

The following gives me the last date but not the corresponding rate:
  SELECT currency_rate.currency_id, MAX(currency_date), currency_rate
  FROM currency_rate
  GROUP BY currency_id



  Mattias Jiderhamn
  Expert Systems
  [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

user defined data types

2001-08-31 Thread Ravi Pawar


I am a Sybase user who has recently shifted to MySQL. I searched and
searched but couldn't get the answer to my question.
Question is:
Q - How do I declare a User Defined Data Type?

In sybase the procedure is:
sp_addtype names, char(40), not null
go

Here names becomes a user defined datatype.

Please help!

-Ravi Pawar


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

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 with MySQL

2001-08-31 Thread Ghislain Gadbois



Description:
I use the MM JDBC driver version 2.0.4 to access my MySQL database from my
Java app.  If I do SELECT NOW(), it returns a String object and not a Date
object.  I tried to call different functions (e.g. SELECT DATE_ADD(NOW(),
INTERVAL 0 SECOND)) in order to have a Date in my ResultSet, byt all I get
is a String.

Also, a query like SELECT *, NOW() FROM some_table also returns a String
for the NOW() column and not a Date.

How-To-Repeat:
Here is a sample Java application to demonstrate this...

import java.sql.*;

public class Test
{
public static void main(String[] pasArgs)
{
try
{
Connection oConnect;
Statement  oStmt;
ResultSet  oRes;

Class.forName(org.gjt.mm.mysql.Driver);

oConnect = DriverManager.getConnection
(jdbc:mysql://host:3306/db, user, password);

oStmt = oConnect.createStatement();

oRes = oStmt.executeQuery(SELECT NOW());

oRes.next();

// This prints java.lang.String and not java.util.Date or
java.sql.Date
System.out.println(oRes.getObject(1).getClass().toString());

oRes.close();
oStmt.close();
oConnect.close();
}
catch(Exception ex)
{
ex.printStackTrace();
}
}
}

Fix:


Submitter-Id:
Originator: Super-User
Organization:

MySQL support: [none | licence | email support | extended email support ]
Synopsis:
Severity:
Priority:
Category:   mysql
Class:
Release:mysql-3.23.40 (Official MySQL binary)

Environment:

System: SunOS centaure 5.8 Generic_108528-06 sun4u sparc SUNW,Sun-Blade-100
Architecture: sun4

Some paths:  /usr/bin/perl /usr/ccs/bin/make /opt/local/bin/gcc /usr/ucb/cc
GCC: Reading specs from
/opt/SISPgcc/lib/gcc-lib/sparc-sun-solaris2.6/2.8.1/specs
gcc version 2.8.1
Compilation info: CC='gcc'  CFLAGS='-O3 -fno-omit-frame-pointer'  CXX='gcc'
CXXFLAGS='-O3 -fno-omit-frame-pointer -felide-constructors -fno-exceptions -
fno-rtti'  LDFLAGS=''
LIBC:
-rw-r--r--   1 root bin  1754016 Nov 23  2000 /lib/libc.a
lrwxrwxrwx   1 root root  11 Jun 20 23:17 /lib/libc.so -
./libc.so.1
-rwxr-xr-x   1 root bin  1129948 Nov 23  2000 /lib/libc.so.1
-rw-r--r--   1 root bin  1754016 Nov 23  2000 /usr/lib/libc.a
lrwxrwxrwx   1 root root  11 Jun 20 23:17 /usr/lib/libc.so -
./libc.so.1
-rwxr-xr-x   1 root bin  1129948 Nov 23  2000 /usr/lib/libc.so.1
Configure command: ./configure  --prefix=/usr/local/mysql
'--with-comment=Official MySQL
binary' --with-extra-charsets=complex --with-server-suffix= --enable-assembl
er --disable-shared
Perl: This is perl, version 5.005_03 built for sun4-solaris

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

To request this thread, e-mail
To unsubscribe, e-mail
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: ERROR 1054 at line 52: Unknown column 'nan' in 'field list'


=?iso-8859-2?Q?Martin_MOKREJ=A9?= writes:
 Hi again,
   I have the following problem:
 
 mysqldump -# --socket=/tmp/mysql.sock --add-drop-table  -f --extended-insert 
--quick Cmuridarum rep | mysql -f --host=pednew -C Cmuridarum
 ERROR 1054 at line 52: Unknown column 'nan' in 'field list'
 
   I have even tried OPTIMIZE TABLE REP; REPAIR TABLE REP;, no luck.
 SHOW COLUMNS FROM REP; does NOT show any column name `nan'.
 
   Even when I use SELECT * FROM REP; and search for  nan , I have no
 match.
 
 see pub/mysql/secret/rep.tgz
 
 Thanks for any reply!
 PS.: Tested still on linux with 3.23.41 binaries from your website, as
 seen in my previous postings.
 -- 
 Martin Mokrejs - PGP5.0i key is at http://www.natur.cuni.cz/~mmokrejs
 MIPS / Institute for Bioinformatics http://mips.gsf.de
 GSF - National Research Center for Environment and Health
 Ingolstaedter Landstrasse 1, D-85764 Neuherberg, Germany

Please check what column is in question. 

May be you used some special chars in column names. In that case you
should use instruct mysqldump to use backticks for table and column
names. 

-- 
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: just starting problem - WinNT

2001-08-31 Thread Gerald R. Jensen


Neil:

Did you add c:\mysql\bin to your system's path? The installer does not.

Did you install MySQL as a service (c:\mysql\bin\mysqld-nt --install) and
start the service (net start mysql)?

Gerald Jensen

- Original Message -
From: Neil Davies [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, August 31, 2001 6:11 AM
Subject: just starting problem - WinNT


I am using, well trying to use mysql through WinNT. I have
successfully installed mysql and have had a look at the client
programs provided with the package. I'm trying to use mysql
through the DOS command prompt under Windows but when I type
C:\mysql I get an error message saying that 'it's an unspecified file,
program, etc.' Can someone direct me where I'm going wrong.

MySQL is installed under C:\MySQL. I get the same result when I
try it from an explicit directory 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




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

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: duplicate delete query

2001-08-31 Thread Gerald Clark


ALTER IGNORE TABLE mytable ADD UNIQUE (email);


will both add a unique key ( which will avoide this problem in the 
future ) and delete the duplicates.

Rory O'Connor wrote:

 excuse me if this is too newbie...but I need to perform a duplicate
 delete on my database using the e-mail address as the key.  I understnad
 how to use COUNT and DISTINCT together...
 
 select count(DISTINCT email) FROM table;  
 
 but I can't seem to find any info on how to perform the actual deletion
 of the duplicate records.  Any info is appreciated!
 
 Thanks!
 
 
 
 providing the finest in midget technology
 
 -
 Before posting, please check:
http://www.mysql.com/manual.php   (the manual)
http://lists.mysql.com/   (the list archive)
 
 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: ERROR 1054 at line 52: Unknown column 'nan' in 'field list'


=?iso-8859-2?Q?Martin_MOKREJ=A9?= writes:
 On Fri, 31 Aug 2001, Sinisa Milivojevic wrote:
 
 Ehh, now I know what you meant: - to use -Q option to mysqldump , ok
 but it anyway did not help.
 

cut

 I'm pretty sure the problem is with text nan being in place of a float
 number.
 
 -- 
 Martin Mokrejs - PGP5.0i key is at http://www.natur.cuni.cz/~mmokrejs
 MIPS / Institute for Bioinformatics http://mips.gsf.de
 GSF - National Research Center for Environment and Health
 Ingolstaedter Landstrasse 1, D-85764 Neuherberg, Germany
 
 

Sorry, but that is not possible. Can you stream the output from
mysqldump first to a file and see what could be that `nan` column ?? 

-- 
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: ERROR 1054 at line 52: Unknown column 'nan' in 'field list'


And should say that

update rep set low='0.00' where id=148;

solved my problem for command:
mysqldump -f --socket=/tmp/mysql.sock --add-drop-table --extended-insert
--quick --databases Cmuridarum rep | mysql -f --host=pednew -C Cmuridarum

... to be complete. ;)
-- 
Martin Mokrejs - PGP5.0i key is at http://www.natur.cuni.cz/~mmokrejs
MIPS / Institute for Bioinformatics http://mips.gsf.de
GSF - National Research Center for Environment and Health
Ingolstaedter Landstrasse 1, D-85764 Neuherberg, 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: ERROR 1054 at line 52: Unknown column 'nan' in 'field list'


=?iso-8859-2?Q?Martin_MOKREJ=A9?= writes:
 On Fri, 31 Aug 2001, Sinisa Milivojevic wrote:
 
 Ehh, now I know what you meant: - to use -Q option to mysqldump , ok
 but it anyway did not help.
 

cut

 I'm pretty sure the problem is with text nan being in place of a float
 number.
 
 -- 
 Martin Mokrejs - PGP5.0i key is at http://www.natur.cuni.cz/~mmokrejs
 MIPS / Institute for Bioinformatics http://mips.gsf.de
 GSF - National Research Center for Environment and Health
 Ingolstaedter Landstrasse 1, D-85764 Neuherberg, Germany
 
 

Sorry, but that is not possible. Can you stream the output from
mysqldump first to a file and see what could be that `nan` column ?? 

-- 
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: ERROR 1054 at line 52: Unknown column 'nan' in 'field list'


On Fri, 31 Aug 2001, Sinisa Milivojevic wrote:

 May be you used some special chars in column names. In that case you
 should use instruct mysqldump to use backticks for table and column
 names. 

Ehh, now I know what you meant: - to use -Q option to mysqldump , ok
but it anyway did not help.

CREATE TABLE `rep` (
  `id` mediumint(8) unsigned NOT NULL default '0',
  `prot_data_id` mediumint(8) unsigned NOT NULL default '0',
  `contig_data_id` mediumint(8) unsigned NOT NULL default '0',
  `contig_data_code` varchar(100) NOT NULL default '',
  `code` varchar(100) NOT NULL default '',
  `length` int(11) NOT NULL default '0',
  `mw` float(10,2) NOT NULL default '0.00',
  `pI` float(10,2) NOT NULL default '0.00',
  `class` varchar(255) NOT NULL default '',
  `mem` int(11) NOT NULL default '0',
  `low` float(10,2) NOT NULL default '0.00',
  `nonglob` float(10,2) NOT NULL default '0.00',
  `coil` float(10,2) NOT NULL default '0.00',
  `sigp` int(11) NOT NULL default '0',
  `loc` varchar(255) NOT NULL default '',
  `summary` text,
  `geneid` varchar(255) NOT NULL default '',
  `classification` varchar(255) NOT NULL default '',
  `pubmed` varchar(255) NOT NULL default '',
  `comments` text,
  `remarks` text,
  `descr` varchar(255) NOT NULL default '',
  `manual` enum('yes','no') default NULL,
  PRIMARY KEY  (`id`),
  KEY `class` (`class`),
  KEY `loc` (`loc`),
  KEY `geneid` (`geneid`),
  KEY `classification` (`classification`),
  KEY `pubmed` (`pubmed`),
  KEY `descr` (`descr`),
  KEY `code` (`code`),
  KEY `prot_data_id` (`prot_data_id`),
  KEY `contig_data_id` (`contig_data_id`)
) TYPE=MyISAM PACK_KEYS=1;

I'm pretty sure the problem is with text nan being in place of a float
number.

-- 
Martin Mokrejs - PGP5.0i key is at http://www.natur.cuni.cz/~mmokrejs
MIPS / Institute for Bioinformatics http://mips.gsf.de
GSF - National Research Center for Environment and Health
Ingolstaedter Landstrasse 1, D-85764 Neuherberg, 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: ERROR 1054 at line 52: Unknown column 'nan' in 'field list'


=?iso-8859-2?Q?Martin_MOKREJ=A9?= writes:
 And should say that
 
 update rep set low='0.00' where id=148;
 
 solved my problem for command:
 mysqldump -f --socket=/tmp/mysql.sock --add-drop-table --extended-insert
 --quick --databases Cmuridarum rep | mysql -f --host=pednew -C Cmuridarum
 
 ... to be complete. ;)
 -- 
 Martin Mokrejs - PGP5.0i key is at http://www.natur.cuni.cz/~mmokrejs
 MIPS / Institute for Bioinformatics http://mips.gsf.de
 GSF - National Research Center for Environment and Health
 Ingolstaedter Landstrasse 1, D-85764 Neuherberg, Germany
 
 

Yes, I saw this. Still, we should fix it.

-- 
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: Window-based client program for MySQL (server in Linux)

2001-08-31 Thread j.urban


There is indeed a PHP client called PHPMyAdmin 
(http://www.phpwizard.net/projects/phpMyAdmin/) and there are several
Windows-based clients including urSQL
(http://www.urbanresearch.com/ursql).



On Fri, 31 Aug 2001, Biniam Gebremichael wrote:

 
 I have MySQL server installed in my linux box. And want a windows based
 client program that can be used to create and modify table designs and
 other functions.
 
 Is there any PHP client for such purpose or any library to enable
 Microsoft Access to interface the server.
 
 Thanks
 Biniam


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

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: safe_mysql not working properly, can any body help

2001-08-31 Thread Joshua M . Schmidlkofer


You need to look at the mysql error log, usually in your data directory.   
99% of the time, if this is your first attempt to use MySQL you don't have 
the permissions tables created yet.   There should be a mysql_install_db 
script that cam with your system, see if you have that, and try running it.


On Friday 31 August 2001 06:19 am, you wrote:
 Dear friends,

   I have got mysql current 3.23 version installed
 with linux in my pc.

   but it is not working properly when i give
 command

 $ safe_mysqld

  Here after few seconds, it displays message that
 mysqld ended.
  So i am not able to start the server.

 When i verified mysql-server package it showed me a
 problem : mysql.log   group, file mode

 do you have any idea regarding this ??

Nirav Shah.

 __
 Do You Yahoo!?
 Get email alerts  NEW webcam video instant messaging with Yahoo! Messenger
 http://im.yahoo.com

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

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

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

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

problems with perl DBI:DBD mysql

2001-08-31 Thread Rudy Metzger


maybe not the 100% correct list, but then again...

 SCRIPT

-

#!/usr/bin/perl -w
use DBI;

my $dbh = DBI-connect( DBI:mysql:database=xxx, xxx, xxx )
or die( Cannot connect to DB\n );

my $sth = DBI-do( INSERT INTO mytable VALUES (2,'some text') );

$dbh-disconnect
or warn( Disconnection failed: $DBI::errstr\n );

exit;

 ERROR MESSAGE ---
Can't locate auto/DBI/do.al in @INC (@INC contains:
/usr/lib/perl5/5.6.0/i386-linux /usr/lib/perl5/5.6.0
/usr/lib/perl5/site_perl/5.6.0/i386-linux /usr/lib/perl5/site_perl/5.6.0
/usr/lib/perl5/site_perl .) at ./tst.pl line 7

-- OTHER INFORMATION ---
Linux, distribution Redhat 7.0
DBI.1.20
DBD-mysql-2.0902
perl v5.6.0

anyone experienced a similar problem?
grateful for any information whatsoever...

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

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

Query Question

2001-08-31 Thread Carl Schrader


I'm doing a query like:

select Title from inv where Title LIKE '%TOMMY%' OR Content LIKE
'%TOMMY%' OR  Notes LIKE '%TOMMY%'  order by Title

What I need is to have the results that match Title LIKE '%TOMMY%' to
appear first and then the rest. I have been doing 2 separate queries and
filtering the first results from the second in a script. I would like to
do this with a single query. Can that be done?




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

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

Re: problems with perl DBI:DBD mysql

2001-08-31 Thread dwilkers


Hi,
I am sure there are cleaner ways, but this works
for my scripts just fine.



use DBI;
$drh=DBI-install_driver('mysql') || warn no Driver\n;
$dbh=$drh-connect(search:localhost,user_1) or warn No connect\n;

$cursor=$dbh-prepare(select email from opt2 where resend=100);
$cursor-execute;

while($this_addr = $cursor-fetchrow) {
push @recps, $this_addr;
}








On Fri, 31 Aug 2001, Rudy Metzger wrote:

 maybe not the 100% correct list, but then again...
 
  SCRIPT
 
 -
 
 #!/usr/bin/perl -w
 use DBI;
 
 my $dbh = DBI-connect( DBI:mysql:database=xxx, xxx, xxx )
 or die( Cannot connect to DB\n );
 
 my $sth = DBI-do( INSERT INTO mytable VALUES (2,'some text') );
 
 $dbh-disconnect
 or warn( Disconnection failed: $DBI::errstr\n );
 
 exit;
 
  ERROR MESSAGE ---
 Can't locate auto/DBI/do.al in @INC (@INC contains:
 /usr/lib/perl5/5.6.0/i386-linux /usr/lib/perl5/5.6.0
 /usr/lib/perl5/site_perl/5.6.0/i386-linux /usr/lib/perl5/site_perl/5.6.0
 /usr/lib/perl5/site_perl .) at ./tst.pl line 7
 
 -- OTHER INFORMATION ---
 Linux, distribution Redhat 7.0
 DBI.1.20
 DBD-mysql-2.0902
 perl v5.6.0
 
 anyone experienced a similar problem?
 grateful for any information whatsoever...
 
 -
 Before posting, please check:
http://www.mysql.com/manual.php   (the manual)
http://lists.mysql.com/   (the list archive)
 
 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: Why there are no API-function for transactions?

2001-08-31 Thread Heikki Tuuri


Hi!

Sending SQL strings in PHP like

set autocommit=0
commit
rollback

seemed to work for Andre.

Regards,
Heikki
http://www.innodb.com

-Original Message-
From: Andre Konopka [EMAIL PROTECTED]
To: Heikki Tuuri [EMAIL PROTECTED]
Date: Friday, August 31, 2001 3:32 PM
Subject: Re: Why there are no API-function for transactions?


Heikki,

it work's as you supposed. I only send at the beginning 'set
autocommit=0' 
then COMMIT and ROLLBACK works fine

Again, thank you, have a nice weekend

Andre Konopka




Heikki Tuuri wrote:
 
 Andre,
 
 can PHP just send the SQL string
 COMMIT or ROLLBACK to the server?
 
 Some APIs may map these to some function
 calls, which are not implemented, and thus
 commit or rollback does not work. You have to
 test it.
 
 In Perl I just do:
 
 $dbh-do(rollback);
 
 Regards,
 
 Heikki
 
 -Original Message-
 From: Andre Konopka [EMAIL PROTECTED]
 To: Heikki Tuuri [EMAIL PROTECTED]; [EMAIL PROTECTED]
 [EMAIL PROTECTED]
 Date: Friday, August 31, 2001 3:04 PM
 Subject: Why there are no API-function for transactions?
 
 Hi,
 
 maybe I'am wrong but I didn't find any transaction-oriented C-API
 functions???
 
 How can I build a web transaction application with MYSQL/INNOBASE? I
 would prefer PHP, but PHP uses the C-library to connect to mysql and
 there are no transaction C-API functions...
 
 
 Thanks Andre



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

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

order by...group by...complicated query

2001-08-31 Thread hassan el forkani


hi,

i am trying to build a message board in php with mysql as back end;

what i want to do is to query the database in a certain way that the result 
is returned in the correct order for php to display the discussion thread 
properly

here is my table structure:

mysql show fields from posts
 - ;
+-+-+--+-+-++
| Field   | Type| Null | Key | Default | Extra  |
+-+-+--+-+-++
| msgid   | bigint(20) unsigned |  | PRI | NULL| auto_increment |
| dateadded   | timestamp(14)   | YES  | | NULL||
| subject | mediumblob  |  | | ||
| body| longblob| YES  | | NULL||
| replytopost | bigint(20) unsigned | YES  | | 0   ||
| aposition   | tinyint(3) unsigned | YES  | | 0   ||
| thrid   | bigint(20) unsigned |  | MUL | 0   ||
| usrid   | bigint(20) unsigned |  | MUL | 0   ||
| username| varchar(50) |  | | ||
+-+-+--+-+-++
9 rows in set (0.00 sec)

the query should look like : select * from posts where thrid = 'the id of 
the thread' order by.(this is the part i couldn't figure out);

the position of a single message into the tree is determined by the 
following criteria:
dateadded : the date in which it was added
replytopost: the post to which it belongs, if none then 0 is assigned
aposition: the absolute position of the message (horizontal)

a combination of these columns in an order by clause should (in theory) 
build the tree correctly
please advise me if i am doing something wrong here, i have tried many 
combinations without success

regards;

hassan


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

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

Internet Usage Surging and Outsourcing Web Hosting Saves Millions!

2001-08-31 Thread info

It's been a hot summer indeed, not only for the weatherman, but for Internet folks as
well. The latest round of economic warnings come at a time when everyone has been once
again scared by the media.

Don't believe all the hype that you hear on the news. As a matter of fact, a
surprising new study by an Internet pioneer has found that Internet traffic has grown
faster than ever in recent months, contradicting widely held views that Internet
growth has slowed. Dr. Lawrence Roberts of Caspian Networks says his new research is
based upon actual scientific data, rather than on the financial performance of
equipment vendors.

As a leader of the team that developed ARPANET, which evolved into the modern
Internet, Roberts says he was able to gain unusual access to top scientists at leading
carriers. By signing non-disclosure agreements with the top 19 carriers, Roberts' team
was able to access information about their network topologies and traffic. Network
traffic was sampled in April and October of 2000 and April of 2001. Roberts said his
data for that 12-month period shows that traffic has been doubling every six months on
average across core IP service providers' networks. That equates to an annual growth
rate of about 400 PERCENT.

In other news, IN-HOUSE WEB HOSTING is on its way out, according to a recent report by
Jupiter Media Metrix, as U.S. companies discover that they can save big bucks and
potential time and money-eating errors by outsourcing Web-hosting tasks.

Currently, 34 percent of U.S. companies handle hosting internally and another 24
percent manage their applications internally but outsource server management. Many
companies have opted for in-house hosting due to security concerns, control issues,
and customer service and confidentiality issues, according to Jupiter.

The problem is that companies overestimate the competitive advantages of in-house Web
hosting and fail to see the possible cost reductions that come with outsourcing the
service, Jupiter reported. U.S. companies with in-house Web hosting spend more on
staffing and technology than they would if they outsourced these functions, saving 30
percent to 40 percent of their Web-hosting costs, according to the researcher.

The cost-reducing benefits of outsourcing are most apparent in companies with mid- to
high-traffic sites, Jupiter said. Over three years, a company with a staff of 18
people to 25 people would pay three times more per year than it would to outsource the
activity. In addition to paying too much for Web hosting, companies perform other Web
hosting blunders such as initiating Web projects before their site hosting and
technology infrastructure design is built, Jupiter said.

Eighty percent of companies jump the gun on their Web development projects, Jupiter
said, and due to this lack of planning, nine out of 10 of these ventures will incur
some avoidable rebuilding. Jupiter recommends that companies undertake infrastructure
design in tandem with first-stage application planning and development. If this
precaution is not taken, companies risk exceeding their scalability limits and may
have to shift into crisis mode, incurring sky-high hosting costs, the researcher
reported.

By choosing a technology infrastructure provider simultaneously with an application
developer, companies can cut implementation delays by 25 percent to 30 percent,
Jupiter reported. When selecting for a Web hosting provider, companies should look for
reliability, scalability, security, a proven track record, accountability, response
speed, and customer service, the researcher suggested. After all, according to
Jupiter, slimming down a company's in-house Web hosting could fatten up its bank
account in the long run.

If you would like to find out how we have been helping businesses small and large to
save money by outsourcing your web services, contact one of our Account
Representatives today. Since 1997, WebStream has proven to be a reliable solution.

Sincerely,

Jason Edwards
Director of Promotions
WebStream Internet Solutions

[EMAIL PROTECTED]
http://www.webstream.net/
(888) 932-2333 Toll-Free
(954) 730-7127 Local
(954) 733-7067 Fax
(954) 730-7405 Help Desk

Would you like to un-subscribe from this mailing list?
If so, please click :

http://demo.webstream.net/optout/optout.cfm?email=mysql%40lists%2Emysql%2Ecommailgroup=GlobalBusiness

If the above link is not available, cut and paste this into your browser window.

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

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try:

Re: safe_mysql not working properly, can any body help

2001-08-31 Thread dwilkers


Plesae review your log files!


On Fri, 31 Aug 2001, nirav shah wrote:

 Dear friends, 

   I have got mysql current 3.23 version installed
 with linux in my pc.
 
   but it is not working properly when i give
 command 
 
 $ safe_mysqld
 
  Here after few seconds, it displays message that
 mysqld ended.
  So i am not able to start the server.
 
 When i verified mysql-server package it showed me a
 problem : mysql.log   group, file mode
 
 do you have any idea regarding this ??
 
Nirav Shah.
 
 __
 Do You Yahoo!?
 Get email alerts  NEW webcam video instant messaging with Yahoo! Messenger
 http://im.yahoo.com
 
 -
 Before posting, please check:
http://www.mysql.com/manual.php   (the manual)
http://lists.mysql.com/   (the list archive)
 
 To request this thread, e-mail [EMAIL PROTECTED]
 To unsubscribe, e-mail [EMAIL PROTECTED]
 Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
 



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

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

Re: problems with perl DBI:DBD mysql

2001-08-31 Thread Rodney Broom


From: Rudy Metzger [EMAIL PROTECTED]

  ERROR MESSAGE ---
 Can't locate auto/DBI/do.al in @INC...

It sounds like your DBI didn't get built correctly. If you think that it probably was 
built right, then you can start by trying to find do.al:
  % find / -name do.al
But I don't expect that to turn out the file in an acceptable location. You'll 
probably have to reinstall DBI.


---
Rodney Broom
Programmer: Desert.Net




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

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

Re: Access and MySQL

2001-08-31 Thread Adams, Bill TQO



Stephen Johnson wrote:

 I have a client that uses an Access dB in house and wants that database to
 automatically update a MySQL database that I am creating for their website.
 Is this possible and if so where can I find some reading material on how to
 accomplish it?

 Thanks for the information


Use MyODBC of course.

If they are not updating the MySQL table directly you will need to generate a
macro to select into the table.  I do not have a specific example but
something like.

DELETE FROM table;
INSERT INTO table (col1, col2, ...) SELECT a_col1, a_col2, ... FROM
access_table WHERE...

--Bill



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

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 vs Oracle vs Acess

2001-08-31 Thread Simon Green


OK
Well as you know MySQL has less bells and whistles vs oracle. This makes it
very fast.
The other thing with MySQL is that it is very reliable. The last thing is
that it can deal with very big databases.
So if you need a very fast DB but not all the stuff of oracle MySQL is you
database.
We use it for authenticating users and getting data to and from web pages.
You can even get it to transfer a database to oracle and back. 
And it just feels a bit more grown up than Access...;o)

I hope this helps a bit?

Simon

-Original Message-
From: Gene Gurevich [mailto:[EMAIL PROTECTED]]
Sent: 31 August 2001 16:37
To: [EMAIL PROTECTED]
Subject: MySQL vs Oracle vs Acess


Hi 

This is a very generic quesiton and I would appreciate
any info. I am an Oracle dba; our developers are now
using access for their own small projects. When these
projects grow and become too large for Access we move
them to Oracle. The developers are now considering
switching from Access to MySQL and I'm trying to
figure out what are the advantages of that move. I
have read some documentation and it looks like a big
advantage of
MySQL vs Access is multi-user access. There are also
some features that are present in Oracle but missing
in  My SQL like views, subqueries and a few other. I
was wondering if someone who has working experience in
both Access and MYSQL (or ORacle and MySQL) could
expand on the differences from practical standpoint. 

Thanks for any input

=


__
Do You Yahoo!?
Get email alerts  NEW webcam video instant messaging with Yahoo! Messenger
http://im.yahoo.com

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

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

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

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

Re: mysql_connect () and mysql_pconnect are not recognized ! Pls help.

2001-08-31 Thread Tony Wells


It sounds like the PHP module was compiled without MySQL support.

root wrote:
 
 Hi,
 
 I'm running mysql MAX 3.23.41 on LinuxPPC, everything was installed from
 an RPM.
 My problem is whenever I try to call mysql_connect (), from a php3
 script, I got the error function not found or misconfigured  
 The script is a simple form, that passes the data to be added to an
 empty database, with an empty table, both  the MySQL server and Apache
 reside on the same machine, and because it's just a test, I'm entering
 as root.
 I am developing a more complex script  , but I need to solve the
 connection problem first 
 BTW ifyou define a var $link = mysql_connect ( localhost ) or   ;  ,
 which is the correct syntax ? localhost or 'localhost' ?
 Why is the command failing ??? From the console it works 
 
 BTW The server is on a static IP without a DNS, is it correct to set
 mysql_connect (xxx.xxx.xxx.xxx) or ('xxx.xxx.xxx.xxx' when you are
 running as localhost 
 
 Thank you
 
 Regards,
 
 Rick
 
 -
 Before posting, please check:
http://www.mysql.com/manual.php   (the manual)
http://lists.mysql.com/   (the list archive)
 
 To request this thread, e-mail [EMAIL PROTECTED]
 To unsubscribe, e-mail [EMAIL PROTECTED]
 Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

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

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 Database Location ?

2001-08-31 Thread Peter Moscatt


Can you change the location of a MySQL database ?  The default is 
'/var/lib/mysql'.

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

mysqlshow shows list of blank (not empty) tables (FAQ?)

2001-08-31 Thread Simon J Mudd


I've not been using mysql for some time but did have it running for a
couple of small databases I use at home.  It doesn't appear to work now,
the most obvious sympton being that msyqlshow shows a list of blank table
names.

[root@phoenix mysql]# rpm -q redhat-release
redhat-release-7.1-1
[root@phoenix mysql]# rpm -q MySQL; rpm -V MySQL
MySQL-3.23.36-1
[root@phoenix mysql]# mysqlshow
+---+
| Databases |
+---+
|   |
|   |
|   |
|   |
|   |
|   |
|   |
|   |
|   |
|   |
|   |
|   |
|   |
|   |
|   |
|   |
+---+
[root@phoenix mysql]#

The only thing I've noticed looking back at the mysql documentation is
that there appear to be new MyISAM tables which are different to the ones
I remember seing before (ISAM tables).

My machine has /var/lib/mysql point to /home/mysql and the directory
structure is the following:

[root@phoenix mysql]# ls -l /home/mysql
total 26
drwx--2 mysqlmysql1024 Jun 21  2000 ampr_database
drwx--2 mysqlmysql1024 Feb 24  2000 bounces
drwx--2 mysqlmysql1024 Oct 17  1999 cv
drwx--2 mysqlmysql1024 Mar 22  1999 ipaddress
drwx--2 mysqlmysql1024 Feb  9  1999 mysql
srwxrwxrwx1 mysqlmysql   0 Aug 31 18:38 mysql.sock
drwx--2 mysqlmysql1024 Nov  4  2000 negatives
-rw-r--r--1 root root12264 Aug 31 17:46 negatives.tgz
drwx--2 mysqlmysql1024 May 18  2000 new_ip_address
-rw-r--r--1 mysqlmysql 347 Aug 31 18:50 phoenix.ea4els.ampr.org.err
-rw-rw1 mysqlmysql   5 Aug 31 18:38 phoenix.ea4els.ampr.org.pid
drwx--2 mysqlmysql1024 Jul 18  2000 ricdb
drwx--2 mysqlmysql3072 Feb 19  2000 slash
drwx--2 mysqlmysql1024 Apr 22 21:54 test
[root@phoenix mysql]# ls -l /home/mysql/mysql
total 67
-rw-rw1 mysqlmysql   0 Feb  9  1999 columns_priv.ISD
-rw-rw1 mysqlmysql1024 Feb  9  1999 columns_priv.ISM
-rw-rw1 mysqlmysql8778 Feb  9  1999 columns_priv.frm
-rw-rw1 mysqlmysql1309 Aug 31 18:22 db.ISD
-rw-rw1 mysqlmysql3072 Aug 31 18:22 db.ISM
-rw-rw1 mysqlmysql8982 Feb  9  1999 db.frm
-rw-rw1 mysqlmysql   0 Feb  9  1999 func.ISD
-rw-rw1 mysqlmysql1024 Feb  9  1999 func.ISM
-rw-rw1 mysqlmysql8641 Feb  9  1999 func.frm
-rw-rw1 mysqlmysql   0 Feb  9  1999 host.ISD
-rw-rw1 mysqlmysql1024 Feb  9  1999 host.ISM
-rw-rw1 mysqlmysql8958 Feb  9  1999 host.frm
-rw-rw1 mysqlmysql   0 Feb  9  1999 tables_priv.ISD
-rw-rw1 mysqlmysql1024 Feb  9  1999 tables_priv.ISM
-rw-rw1 mysqlmysql8877 Feb  9  1999 tables_priv.frm

The negatives.tgz file is copied from the negatives directory.  When
copied over to a FreeBSD machine running the mysql version below the data
shows up correctly.

[ mysql  Ver 10.12 Distrib 3.23.26-beta, for -freebsd4.2 (i386) ]

The mysql error log file shows no errors.

I'm sure that I'm doing something wrong which is in a FAQ but can't find
the answer at the moment.  Any suggestions are greatly appreciated.

Thanks in advance.

Simon
-- 
Simon J Mudd, Madrid SPAIN.   email: [EMAIL PROTECTED]
Tel: +34-91-408 4878,   Mobile: +34-605-085 219




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

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

Way way OT

2001-08-31 Thread massey



Way OT but I had to ask the Red Flag got my Attention.

I am looking build my own E-mail Server for my Domain and would like some pointers

Is there an E-mail Server that uses MySQL

What is the easyest to setup, I do not need a full blown one to handle lists and such 
and my Client can connect to on the Linux RH box.

Can I use my Client on the same server, PINE.


Many Thnaks


M;)

MySQL DATABASES Enlightenment



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

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

MAILER-DAEMON@123box.co.uk: 123box.co.uk mail delivery system

2001-08-31 Thread s . keeling


Is anyone else getting these goofy bounces from 123box.co.uk besides
me?  Should I report them to Spamcop?  :-)


database, sql, ...


-- 
 Any technology distinguishable from magic is insufficiently advanced.
 [EMAIL PROTECTED] TopQuark Software  Serv. Contract programmer, server bum.


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

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: MAILER-DAEMON@123box.co.uk: 123box.co.uk mail delivery system

2001-08-31 Thread Colin Faber


Yes.


s . keeling wrote:
 
 Is anyone else getting these goofy bounces from 123box.co.uk besides
 me?  Should I report them to Spamcop?  :-)
 
 database, sql, ...
 
 --
  Any technology distinguishable from magic is insufficiently advanced.
  [EMAIL PROTECTED] TopQuark Software  Serv. Contract programmer, server bum.
 
 -
 Before posting, please check:
http://www.mysql.com/manual.php   (the manual)
http://lists.mysql.com/   (the list archive)
 
 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: Changing Database Location ?

2001-08-31 Thread David Turner


This is one thing I really can't stand about mysql. We should have the option when 
creating
databases and tables of specifying where the database is located and the datafile and 
indexfile.

Dave
On Fri, Aug 31, 2001 at 07:03:40PM +0200, Simon J Mudd wrote:
 On Fri, 31 Aug 2001, Peter Moscatt wrote:
 
  Can you change the location of a MySQL database ?  The default is
  '/var/lib/mysql'.
 
 The easy way I've always used is to change the name of the /var/lib/mysql
 directory and make a symbolic link to another directory.  You need to
 reset up the mysql database and check the permissions but this at least
 avoids you having to check and/or mess about with the script start up
 options.
 
 There may be better ways, but this works fine.
 
 Regards,
 
 Simon
 -- 
 Simon J Mudd, Madrid SPAIN.   email: [EMAIL PROTECTED]
 Tel: +34-91-408 4878,   Mobile: +34-605-085 219
 
 
 -
 Before posting, please check:
http://www.mysql.com/manual.php   (the manual)
http://lists.mysql.com/   (the list archive)
 
 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

'select * where x is null' not working

2001-08-31 Thread Jeremiah T. Folsom-Kovarik


  Weird things have just started happening in at least one table of my MySQL 
3.22.32 database. The symptoms are like this:

mysql describe orders;
+--+--+--+-+-+---+
| Field| Type | Null | Key | Default | Extra |
+--+--+--+-+-+---+
  ...
| contact_info | smallint(5) unsigned | YES  | | NULL|   |
| expired  | datetime | YES  | | NULL|   |
+--+--+--+-+-+---+

mysql select contact_info, expired from orders where order_num = '1';
+--+-+
| contact_info | expired |
+--+-+
| NULL | NULL|
+--+-+
1 row in set (0.00 sec)

mysql select count(*) from orders where contact_info is null;
+--+
| count(*) |
+--+
|  248 |
+--+
1 row in set (0.02 sec)

// here comes the problematic part //

mysql select count(*) from orders where expired is null;
+--+
| count(*) |
+--+
|0 |
+--+
1 row in set (0.00 sec)

  Obviously this last result is wrong; there should be at least one (and in 
fact about thirty) table entries where expired is null. The thing can select 
on and update the 'expired' field, and can show rows where 'expired' is null 
if I select on another key, but can't seem to find those same rows when I 
try to select them by the 'expired' field. Only that one field is giving me 
trouble, and this just started happening today.

  I've tried 'isamchk -r orders' to no avail, and I found nothing else that 
might do this in the manual or archives.. I can send more info to anybody 
that wants it, but does anybody recognize these symptoms right off or know 
what might be causing them?

  Thanks,
  -Jt.
Jeremiah T. Folsom-Kovarik


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


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

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

Re: MAILER-DAEMON@123box.co.uk: 123box.co.uk mail delivery system

2001-08-31 Thread Alexander Skwar


So sprach »s . keeling« am 2001-08-31 um 11:51:00 -0600 :
 Is anyone else getting these goofy bounces from 123box.co.uk besides
 me?  Should I report them to Spamcop?  :-)

i'm getting these as well.

 database, sql, ...

Alexander Skwar
-- 
How to quote:   http://learn.to/quote (german) http://quote.6x.to (english)
Homepage:   http://www.digitalprojects.com   |   http://www.iso-top.de
   iso-top.de - Die günstige Art an Linux Distributionen zu kommen
Uptime: 2 days 5 hours 3 minutes

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

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

Berkeley or InnoDB?

2001-08-31 Thread Ary Medeiros


I'm porting an application to MySQL and I need to support transactions.
I will appreciate so much if someone could give me some impressions about
which one is better. BerkeleyDB or InnoDB?

Thanks in Advance,

Ary.

Rubi-con Technology/Security Conference

2001-08-31 Thread Denis Baldwin


MySQL'ers,

I am one of the core members of the Rubi-con Security and Technology
conference held in Detroit every year.  At this year's conference, when
asked what our attendees would like to see most next year, many of them said
they wanted someone to explain how MySQL works, what it's main applications
are and how secure it is for business and industrial use. 

After hunting for a MySQL Expert, I decided to take this question
to the main MySQL mailing list. Would any of you mind coming to our 2002
Rubi-con Security conference in Detroit, MI on April 5th - 7th, 2002 and
doing a short speech on some of your work with MySQL? It would be of great
interest to our attendees.

If you would like more information about Rubi-con, please check out our site
at http://www.rubi-con.org.

Thanks for reading this. If you have any questions, please feel free to
e-mail me at [EMAIL PROTECTED]

Denis

Denis A. Baldwin (A+/MCP/I-Net+/Net+/CCA/CIW)
Network Administrator, CAE, Inc.
810-231-9373, ext. 229
[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: 'select * where x is null' not working

2001-08-31 Thread Don Read



On 31-Aug-2001 Jeremiah T. Folsom-Kovarik wrote:
   Weird things have just started happening in at least one table of my MySQL
 3.22.32 database. The symptoms are like this:
 
 mysql describe orders;
 +--+--+--+-+-+---+
| Field| Type | Null | Key | Default | Extra |
 +--+--+--+-+-+---+
   ...
| contact_info | smallint(5) unsigned | YES  | | NULL|   |
| expired  | datetime | YES  | | NULL|   |
 +--+--+--+-+-+---+
 
 mysql select contact_info, expired from orders where order_num = '1';
 +--+-+
| contact_info | expired |
 +--+-+
| NULL | NULL|
 +--+-+

      ^^

   this is NULL   this is 'NULL', the string.


 1 row in set (0.00 sec)
 
 mysql select count(*) from orders where contact_info is null;
 +--+
| count(*) |
 +--+
|  248 |
 +--+
 1 row in set (0.02 sec)
 
 // here comes the problematic part //
 
 mysql select count(*) from orders where expired is null;
 +--+
| count(*) |
 +--+
|0 |
 +--+
 1 row in set (0.00 sec)
 
   Obviously this last result is wrong; there should be at least one (and in 
 fact about thirty) table entries where expired is null. The thing can select
 on and update the 'expired' field, and can show rows where 'expired' is null
 if I select on another key, but can't seem to find those same rows when I 
 try to select them by the 'expired' field. Only that one field is giving me 
 trouble, and this just started happening today.
 
   I've tried 'isamchk -r orders' to no avail, and I found nothing else that 
 might do this in the manual or archives.. I can send more info to anybody 
 that wants it, but does anybody recognize these symptoms right off or know 
 what might be causing them?
 

Check :
 select * from orders where expired='NULL';

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: 'select * where x is null' not working

2001-08-31 Thread Jeremiah T. Folsom-Kovarik


  Thanks for your quick response! More below..

  mysql select contact_info, expired from orders where order_num = '1';
  +--+-+
  | contact_info | expired |
  +--+-+
  | NULL | NULL|
  +--+-+

   ^^

this is NULL   this is 'NULL', the string.

Check :
  select * from orders where expired='NULL';

Regards,
--
Don Read

  Yeah, I noticed that funny spacing (left align vs. right align) too, but 
it doesn't seem to be the case:

mysql select * from orders where expired like '%NULL%';
Empty set (0.00 sec)

  Plus, all this just started happening yesterday, after everything worked 
fine for many days. That leads me to believe there is a problem with a 
corrupt table or something. How about this further clue I just noticed:

mysql select count(*) from orders;
+--+
| count(*) |
+--+
|  499 |
+--+
1 row in set (0.00 sec)

mysql select * into outfile 'orders.bak' from orders;
Query OK, 382 rows affected (0.07 sec)

  Weird, huh?
  -Jt.
Jeremiah T. Folsom-Kovarik



_
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

HELP ME trouble with instalation of Apache+php4+MySQL!!!!!

2001-08-31 Thread Pablo Javier Gonzalez Mateos


Hello, im in this situation:

i have a PC AMD K6-2 with 64 MB RAM. SuSE Linux 6.3 OS

when i compile the php with mysql everything works fine, but after y
compile the apache with this command:

./configure --activate-module-=src/modules/php4/libphp4.module
make

and after a few seconds this error apear

/usr/local/mysql-3.23.41-pc-linux-gnu-i686/lib/libmysqlclient.a(my_com
press.o): In function `my_uncompress':
my_compress.o(.text+0x9a): undefined reference to `uncompress'   

/usr/local/mysql-3.23.41-pc-linux-gnu-i686/lib/libmysqlclient.a(my_com
press.o): In function `my_compress_alloc':
my_compress.o(.text+0x12a): undefined reference to `compress'

collect2: ld returned 1 exit status  

make[2]: *** [target_static] Error 1 

make[2]: Leaving directory `/usr/local/apache_1.3.20/src'

make[1]: *** [build-std] Error 2 

make[1]: Leaving directory `/usr/local/apache_1.3.20'

make: *** [build] Error 2

linux:/usr/local/apache_1.3.20 #


seems to be something on the library /lib/libmysqlclient.a 
what can i do ???
anyone can help me ???, thanks you very much !
P.D. Excuse me for my bad english... 





--
Pablo Javier Gonzalez Mateos, [EMAIL PROTECTED] on
31/08/2001



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

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

RE: 'select * where x is null' not working

2001-08-31 Thread Don Read



On 31-Aug-2001 Jeremiah T. Folsom-Kovarik wrote:
   Thanks for your quick response! More below..
 

snip

   Plus, all this just started happening yesterday, after everything worked 
 fine for many days. That leads me to believe there is a problem with a 
 corrupt table or something. How about this further clue I just noticed:
 
 mysql select count(*) from orders;
 +--+
| count(*) |
 +--+
|  499 |
 +--+
 1 row in set (0.00 sec)
 
 mysql select * into outfile 'orders.bak' from orders;
 Query OK, 382 rows affected (0.07 sec)
 
   Weird, huh?
   -Jt.
 Jeremiah T. Folsom-Kovarik

Just a stab, but try droping  rebuilding the key(s).

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

auto_increment

2001-08-31 Thread Tony Bibbs


can anyone tell me why an auto increment field would jump from 231 to
something large like 883607 and then give me failure on future insertions
because of a duplicate key?

I'm running mysql 3.23.39 on RH 7.1

--Tony


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

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: Trouble connecting to MySQL server using MySQLGUI and VCC

2001-08-31 Thread Chris Johnson


The remote hosts you mention are not allowed to access the database.  This
is a permissions problem, in particular the value of hosts in one of the
permissions tables.  It sounds like they only allow connections from the
localhost or their own network.

..chris

- Original Message -
From: Robert Anderson [EMAIL PROTECTED]


I've been playing with MySQL and trying to get connected to my web-hosting
company's MySQL server that they set up for me.  In trying to use the
MySQLGui and also the VCC, I get the error Host 'junior.dsl.neticus.com' is
not allowed to connect to this MySQL server.  And if I'm plugged in at work
I get the same error with a different 'dsl.neticus.com' thing.
I can telnet to the company and then use their 'mysql.pm' utility using the
same parameters from the exact same workstation and locations.
Any ideas?

Thanks in advance,
Rob




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

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

Re: HELP ME trouble with instalation of Apache+php4+MySQL!!!!!

2001-08-31 Thread s . keeling


On Fri, Aug 31, 2001 at 05:37:58PM -0300, Pablo Javier Gonzalez Mateos wrote:
 Hello, im in this situation:
 
 i have a PC AMD K6-2 with 64 MB RAM. SuSE Linux 6.3 OS
 
 when i compile the php with mysql everything works fine, but after y 
 compile the apache with this command:
 
 ./configure --activate-module-=src/modules/php4/libphp4.module
 make
 
 and after a few seconds this error apear
 
 /usr/local/mysql-3.23.41-pc-linux-gnu-i686/lib/libmysqlclient.a(my_com
 press.o): In function `my_uncompress':
 my_compress.o(.text+0x9a): undefined reference to `uncompress'

Yet another question about a missing zlib/libz.  Install libz and
you'll be away.  On my Suse 7.1 Personal box, it's libz-1.1.3-284 but
I can't imagine what it would be for 6.3

And cool it with the exclamation marks, will ya?  One was more than enough.


database, sql, query.


-- 
 Any technology distinguishable from magic is insufficiently advanced.
 [EMAIL PROTECTED] TopQuark Software  Serv. Contract programmer, server bum.


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

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

DBUG_PRINT

2001-08-31 Thread Mallikarjuna Rao N


Hi all,
  How can I get the output of the DBUG_PRINT (which is 
everywhere in the code of the mysql) option to
print the output as it is intended (functions and their 
parameters) 
  and further extension to my question is how to get 
separate the DBUG_PRINT output(once I get it, I am sure there
are many to help in this context) of the server and the 
client separately , i.e. to separate both the server and 
clients output. 
   
  thanx in advance. 
mallikarjuna rao
-- 

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

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: WHERE IN ( MAX ) in MySQL

2001-08-31 Thread Chris Johnson


I think you will you have to do it in 2 steps using a temporary table.  This
is one of MySQL's biggest weak points.

..chris

- Original Message -
From: Mattias Jiderhamn [EMAIL PROTECTED]


I have a table

  CREATE TABLE currency_rate (
currency_id VARCHAR(3),
currency_date DATE,
currency_rate NUMERIC(16,8),
PRIMARY KEY (currency_id, currency_date)
  );

and want to list the latest registered rates of all currencies.

Normally I would go about like this:
  SELECT currency_rate.currency_id, currency_date, currency_rate
  FROM currency_rate
  WHERE (currency_rate.currency_id, currency_date) IN
  (
SELECT currency_id, MAX(currency_date)
FROM currency_rate
GROUP BY currency_id
  )

But MySQL doesn't support nested selects...
How do I solve this?

The following gives me the last date but not the corresponding rate:
  SELECT currency_rate.currency_id, MAX(currency_date), currency_rate
  FROM currency_rate
  GROUP BY currency_id

  Mattias Jiderhamn




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

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 locks up

2001-08-31 Thread Jens Hjalmarsson


Hello,

I just moved my databases from one machine to another. I recompiled
the whole thing, but I have some problems. MySQL now locks up, and
takes 100% cpu, after an hour or two. I need to shut it down and
restart it, and then it goes another hour again.
The machine is a dual pIII 866 with 2gb ram, dedicated to MySQL. It
serves two frontends running Apache. I am using the my-huge.cnf, with
max_connections set to (currently) 250, but I've tried both more and
less.
I am currently testing it with the binaries provided on MySQL.com,
and so far it hasn't crashed. But, it hasn't gone two hours yet.

So, why does MySQL lock up on me?

Jens


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

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

weird error that I have not encountered in 2 years

2001-08-31 Thread christopher sagayam


can anyone please tell me what is happening here ?


[root@ns dump]#  /usr/local/mysql/bin/mysql
/usr/local/mysql/bin/mysql: DROP: command not found
/usr/local/mysql/bin/mysql: syntax error near unexpected token `('
/usr/local/mysql/bin/mysql: /usr/local/mysql/bin/mysql: line 12: `CREATE
TABLE badwordstable ('
[root@ns dump]#


Thanks

chris


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


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

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

Re: MySQL locks up

2001-08-31 Thread Adams, Bill TQO



Jens Hjalmarsson wrote:

 Hello,

 I just moved my databases from one machine to another. I recompiled
 the whole thing, but I have some problems. MySQL now locks up, and
 takes 100% cpu, after an hour or two. I need to shut it down and
 restart it, and then it goes another hour again.
 The machine is a dual pIII 866 with 2gb ram, dedicated to MySQL. It
 serves two frontends running Apache. I am using the my-huge.cnf, with
 max_connections set to (currently) 250, but I've tried both more and
 less.
 I am currently testing it with the binaries provided on MySQL.com,
 and so far it hasn't crashed. But, it hasn't gone two hours yet.

 So, why does MySQL lock up on me?

Please repost and include the output of:
uname -a  (hide the host in the post if you want)
ldd /path/to/mysqld

You did not even include your OS which makes it kinda hard for at least me
to help.

--Bill



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

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

2001-08-31 Thread Sergei Golubchik


Hi!

On Sep 01, Mallikarjuna Rao N wrote:
 Hi all,
   How can I get the output of the DBUG_PRINT (which is 
 everywhere in the code of the mysql) option to
 print the output as it is intended (functions and their 
 parameters) 
   and further extension to my question is how to get 
 separate the DBUG_PRINT output(once I get it, I am sure there
 are many to help in this context) of the server and the 
 client separately , i.e. to separate both the server and 
 clients output. 

   thanx in advance. 
 mallikarjuna rao
 -- 

I assume you have mysql source distibution :-)
See dbug/user.r then.
[ Hint -# command line switch ]

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

server rejecting 15MB insert statement

2001-08-31 Thread Anthony Lau


Hello,

I am trying to insert large TEXT data into a MySQL database. The
server rejects insert statements that include a 15MB text file.
The manual says to change max_allowed_packet for the server
to accept large data. I have set this on the server side to
65535KB, which appears to be the largest value allowed for that
variable.

The server still rejects large packets. Using the MM JAVA driver,
errors suggest the server is set at 64KB. mysqladmin variables
definitely shows something larger than 64KB (actually it says
67107840).

I am using MySQL version 3.23.31.

Is there a client side variable that also needs to be defined?

Thanks,

Anthony
-- 
Anthony Lau

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

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: weird error that I have not encountered in 2 years

2001-08-31 Thread Lezz Giles


I'm not a mysql person, but I've seen similar stuff.
I think that for some reason Unix thinks that the file
you're trying to execute is not an executable, so it
is trying to run it as a shell script.  Try this first:
file /usr/local/mysql/bin/mysql
and when it tells you that it is a text file, use an editor
to look at the contents of the file. You'll almost certainly
find that it contains SQL commands instead of being
the executable image that it should be.

HTH
Lezz Giles
- Original Message -
From: christopher sagayam [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, August 31, 2001 3:01 PM
Subject: weird error that I have not encountered in 2 years


 can anyone please tell me what is happening here ?


 [root@ns dump]#  /usr/local/mysql/bin/mysql
 /usr/local/mysql/bin/mysql: DROP: command not found
 /usr/local/mysql/bin/mysql: syntax error near unexpected token `('
 /usr/local/mysql/bin/mysql: /usr/local/mysql/bin/mysql: line 12: `CREATE
 TABLE badwordstable ('
 [root@ns dump]#


 Thanks

 chris


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


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

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




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

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

Qs: Time for ALTER, space requirements

2001-08-31 Thread Jeff Leung


Hi,

I am running MySQL 3.23.14-alpha for Solaris 2.6 and
am running into disk space problems with an ISAM table
I have in it. Table info:
15.8M rows of
datetime,
varchar 16, 
varchar 64,
varchar 128,
varchar 64,
varchar 64,
varchar 32,
varchar 15,
varchar 32,
varchar 64.

So currently it is taking up about 2.8G of space. I am
considering converting the table into a MyISAM table
(don't know why I didn't do that in the first place,
but oh well), but am not sure how much benefit there
is for it. Also, I am worried about the amount of
downtime required to perform such an operation. Any
ideas on an estimate (in terms of number of
operations, like is this a single full-table access,
several passes, etc)?

Also, will ALTER TABLE table TYPE=MYISAM create a new
temporary table to work with and then essentially
insert all the rows into the new copy before removing
the old table? (I am well past 50% capacity on the
machine, so if so, this operation will probably fail.)

Finally, how does MySQL handle resizing database
files? Is growth linear, or are there specific quanta
or thresholds at which the table will grow (for
example, maybe the table file size will be doubled if
the table file is over 75% utilized)?

Thanks.

=
Jeff
// Diplomacy is the art of saying 'nice doggy'
// until you can find a rock.

__
Do You Yahoo!?
Get email alerts  NEW webcam video instant messaging with Yahoo! Messenger
http://im.yahoo.com

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

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

Re: MySQL locks up

2001-08-31 Thread Jens Hjalmarsson


 I just moved my databases from one machine to another. I recompiled
 the whole thing, but I have some problems. MySQL now locks up, and
 takes 100% cpu, after an hour or two. I need to shut it down and
 restart it, and then it goes another hour again.
 The machine is a dual pIII 866 with 2gb ram, dedicated to MySQL. It
 serves two frontends running Apache. I am using the my-huge.cnf, 
 with max_connections set to (currently) 250, but I've tried both
 more and less.
 I am currently testing it with the binaries provided on MySQL.com,
 and so far it hasn't crashed. But, it hasn't gone two hours yet.

 So, why does MySQL lock up on me?

Linux picard 2.4.9 #4 SMP Fri Aug 31 15:21:12 CEST 2001 i686 unknown

picard:/usr/local/var # ldd ../libexec/mysqld 
libdl.so.2 = /lib/libdl.so.2 (0x4001f000)
libpthread.so.0 = /lib/libpthread.so.0 (0x40022000)
libz.so.1 = /lib/libz.so.1 (0x40038000)
libcrypt.so.1 = /lib/libcrypt.so.1 (0x40047000)
libnsl.so.1 = /lib/libnsl.so.1 (0x40075000)
libstdc++-libc6.2-2.so.3 = /usr/lib/libstdc++-libc6.2-2.so.3
(0x4008b000)
libm.so.6 = /lib/libm.so.6 (0x400d4000)
libc.so.6 = /lib/libc.so.6 (0x400f2000)
/lib/ld-linux.so.2 = /lib/ld-linux.so.2 (0x4000)


You did not even include your OS which makes it kinda hard for at 
least me to help.

*ashamed* sorry.. :)

Did you compile the kernel with support for 1GB?

Yepp.

Have you tried 2.2.19?  I only use 2.2.* for production machines at 
work.

Nope. I need 2.4.x for various reasons..

What options did you use with ./configure when you compiled MySQL?


./configure  --with-raid --without-debug --enable-thread-safe-client
--disable-shared --enable-static

Running version mysql-3.23.40


Jens



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

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

novice join question

2001-08-31 Thread Russell Uman



i have three tables. products, class, and dept.
class and dept each have two fields - code and text.
products has a field named class (containing class codes) and a field named dept 
(containing dept codes)

for some depts, all the products that have that dept have the same class
for other depts, there are products in all classes with that dept.

i want to generate a list of depts based on product class/dept combinations. for 
example:
if there is a product with dept 1 and class 1, then dept 1 should be on the list
if there are no products in dept 2 with class 1, then dept 2 should not be on the list

i've tried

select dp.name, dp.dept
from dept.dept as dp
inner join products as pr on dp.dept=pr.dept where pr.class = '1';

i think this filters out the right depts, but of course it gives me multiple rows for 
each dept. how can i remove the duplicate
rows?

can anyone give me a clue? should i be organizing my tables differently if i want this 
kind of result?

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

creating a new table from existing one

2001-08-31 Thread John Hunter




I have a database of minute by minute stock prices and I would like to
summarize daily information in a 'daily' table, which contains
information about the max, min, range of prices, total volume, etc...

This works so far:

CREATE TABLE daily (
   ticker VARCHAR(8) not null,
   date DATE not null,
   minPrice FLOAT not null, 
   maxPrice FLOAT not null,
   range FLOAT not null,
   volume INTEGER not null, 
   PRIMARY KEY (date,ticker)
   );

INSERT INTO daily 
  SELECT ticker, trade_date, MIN(price), MAX(price), MAX(price)-MIN(price), 
SUM(volume) 
  FROM short_quote 
  WHERE trade_date'2001-06-25'
  GROUP BY ticker, TO_DAYS(trade_date);

However, I would also like to get the open and closing prices, ie, the
first and last price for each day.  Is there a way of getting the
price where trade_date=max(trade_date) within the given GROUP BY
ticker/day.


Thanks,
John Hunter

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

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 vs Oracle vs Acess

2001-08-31 Thread Chris Johnson


I've used all three, Access, Oracle and MySQL.  I have the least expertise
with Access.

My impressions are:

* Access is very limited in what it can do with respect to real database
manipulations, those contained in SQL.  It does not handle large amounts of
data well.  Access is really a very fancy, scriptable (VB) GUI wrapped
around a very simple database engine.

* MySQL is a very fast, efficient fairly well featured database system,
which can handle large amounts of data.  It handles most standard SQL
constructs.

* Oracle is a very extensive database system, with many extensions, tools
and features.  It handles all standard SQL constructs and adds many
non-standard SQL constructs.  It is also a rather large footprint.

Comparatively, MySQL lacks a number of features that Oracle has: subselects,
views, referential integrity, cluster ability, etc.  But for the most part,
MySQL and Oracle are more similar than either is like Access.

I'd guess that for the most part, moving the small projects to MySQL from
Access will make future moves from MySQL to Oracle much easier than moving
them from Access to Oracle.


- Original Message -
From: Gene Gurevich [EMAIL PROTECTED]

This is a very generic quesiton and I would appreciate
any info. I am an Oracle dba; our developers are now
using access for their own small projects. When these
projects grow and become too large for Access we move
them to Oracle. The developers are now considering
switching from Access to MySQL and I'm trying to
figure out what are the advantages of that move. I
have read some documentation and it looks like a big
advantage of
MySQL vs Access is multi-user access. There are also
some features that are present in Oracle but missing
in  My SQL like views, subqueries and a few other. I
was wondering if someone who has working experience in
both Access and MYSQL (or ORacle and MySQL) could
expand on the differences from practical standpoint.




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

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

cross-updates with replication

2001-08-31 Thread Todd Goldenbaum


hi,

I am setting up replication between two servers, and I have it working for
the most part- however- when I do cross-database updates, the changes don't
go through to the slave.  as in:  

  use mysql;
  update test.test_table set a=1;

I followed the instructions in the manual for replicating only one database: 

  replicate-do-db=database_name
  -
  Tells the slave thread to restrict replication to the specified database. 
  To specify more than one database, use the directive multiple times, once 
  for each database. Note that this will only work if you do not use 
  cross-database queries such as UPDATE some_db.some_table SET foo='bar' 
  while having selected a different or no database. If you need cross 
  database updates to work, make ] sure you have 3.23.28 or later, and use 
  replicate-wild-do-table=db_name.% (Example: replicate-do-db=some_db) 

So i tried using this in my.cnf:

  [mysqld]
  datadir=/var/lib/mysql
  socket=/tmp/mysql.sock
  master-host=my_ip
  master-user=repl
  master-password=guess
  master-port=3306
  server-id=2
  replicate-wild-do-table=test.%

but it didn't work.  i also tried it with both the replicate-wild-do-table 
line AND replicate-do-db=test just to see, and then with replicate-do-db=test 
all by itself, and they all work, but none of the three are working with
cross-database queries!  anyone know what am i doing wrong here?

thanks,
todd



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

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: weird error that I have not encountered in 2 years

2001-08-31 Thread christopher sagayam


so how to fix the error ?

How did file /usr/local/mysql/bin/mysql

become a text file ?

chris


- Original Message -
From: Lezz Giles [EMAIL PROTECTED]
To: christopher sagayam [EMAIL PROTECTED];
[EMAIL PROTECTED]
Sent: Saturday, September 01, 2001 2:36 AM
Subject: Re: weird error that I have not encountered in 2 years


 I'm not a mysql person, but I've seen similar stuff.
 I think that for some reason Unix thinks that the file
 you're trying to execute is not an executable, so it
 is trying to run it as a shell script.  Try this first:
 file /usr/local/mysql/bin/mysql
 and when it tells you that it is a text file, use an editor
 to look at the contents of the file. You'll almost certainly
 find that it contains SQL commands instead of being
 the executable image that it should be.

 HTH
 Lezz Giles
 - Original Message -
 From: christopher sagayam [EMAIL PROTECTED]
 To: [EMAIL PROTECTED]
 Sent: Friday, August 31, 2001 3:01 PM
 Subject: weird error that I have not encountered in 2 years


  can anyone please tell me what is happening here ?
 
 
  [root@ns dump]#  /usr/local/mysql/bin/mysql
  /usr/local/mysql/bin/mysql: DROP: command not found
  /usr/local/mysql/bin/mysql: syntax error near unexpected token `('
  /usr/local/mysql/bin/mysql: /usr/local/mysql/bin/mysql: line 12: `CREATE
  TABLE badwordstable ('
  [root@ns dump]#
 
 
  Thanks
 
  chris
 
 
  _
  Do You Yahoo!?
  Get your free @yahoo.com address at http://mail.yahoo.com
 
 
  -
  Before posting, please check:
 http://www.mysql.com/manual.php   (the manual)
 http://lists.mysql.com/   (the list archive)
 
  To request this thread, e-mail [EMAIL PROTECTED]
  To unsubscribe, e-mail
 [EMAIL PROTECTED]
  Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
 
 


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


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

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

Re: weird error that I have not encountered in 2 years

2001-08-31 Thread s . keeling


On Sat, Sep 01, 2001 at 04:43:25AM +0100, christopher sagayam wrote:
 so how to fix the error ?
 
 How did file /usr/local/mysql/bin/mysql
 
 become a text file ?

You tell us.

Regardless, is your data still intact?  Make sure it's safe, rip out
mysql, and re-install.

Binaries don't just become text files by themselves.  This takes human
intervention in one way or another.  How secure is your network?  Have
you checked your system for intrusions?  How many people have access
to your system?  What's their level of skill on the system?

If you still have your data files, all may not be lost.


-- 
 Any technology distinguishable from magic is insufficiently advanced.
 [EMAIL PROTECTED] TopQuark Software  Serv. Contract programmer, server bum.


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

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: Way way OT


On Fri, Aug 31, 2001 at 11:50:25AM -0600, [EMAIL PROTECTED] wrote:
 
 I am looking build my own E-mail Server for my Domain and would like
 some pointers
 
 Is there an E-mail Server that uses MySQL

Exim, Postfix, and Sendmail can all use MySQL to varying degrees.
There are probably others.

 What is the easyest to setup, I do not need a full blown one to
 handle lists and such and my Client can connect to on the Linux RH
 box.

I've found exim very easy to run.

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

MySQL 3.23.41-max: up 1 days, processed 16,136,142 queries (141/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

Solaris 2.6 /mysql-3.23.41 compile problems

2001-08-31 Thread Jeff Dickison


Hi everyone,
I am trying to get mysql-3.23.41 to compile under Solaris 2.6
sparc with gcc 2.95.2 and have been running into some problems.  Currently
I am using this as my comfigure :

 ./configure --prefix=/usr/local/mysql \
--with-client-ldflags='-R /usr/local/lib'\
--enable-thread-safe-client \
--with-gnu-ld \
--with-low-memory 


It gives me this error after a bit of compiling:
/usr/local/lib/gcc-lib/sparc-sun-solaris2.6/2.95.2/libgcc.a: could not
read symbols: Bad value
collect2: ld returned 1 exit status

My version of ld is 2.9 (with BFD 2.9).
Has anyone been able to get this to work?

Thanks,
Jeff


==   ==
The nice thing about Windows is - It does not just crash, it displays a
dialog box and lets you press 'OK' first.


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

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


On Thu, Aug 30, 2001 at 12:01:09PM -0400, Jay Fesco wrote:

  Is anyone else getting a strange flag associated with Jeremy's
  email, or is it just me?  Every one of his posts comes in flagged
  in Outlook, and the headers have a line which reads:
  
  X-message-flag: Mailbox corrupt.  Please upgrade your mail software.
  
  This is definitely OT for this forum, but this forum is the only 
  place where I see the problem.

It's interesting to see how many people use software that they cannot
control, isn't it?  And hey, what a bonus...  It's *excellent* at
spreading viruses!

As Microsoft to fix the problem.  Well, first you'll need to
convince them that there IS a problem.

Perhaps the message should say MySQL rocks!  Outlook does not.

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

MySQL 3.23.41-max: up 1 days, processed 16,209,395 queries (140/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: mysqld as root


On Thu, Aug 30, 2001 at 02:12:33PM +0300, Sinisa Milivojevic wrote:

  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!
 
 Seems that you are right !!
 
 We would either have to change a code or docs 

The code, please.  :-)

I was just bit by the same problem the other day while shuffling
my.cnf files around on a server.  Took me a minute to figure out what
was going on.

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

MySQL 3.23.41-max: up 1 days, processed 16,213,303 queries (140/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

Problems Creating BDB Type Tables

2001-08-31 Thread sameer ranadive



Dear Sir,

We are developing supply chain management where we are using EJB and mysql as 

back end. We want to use transaction safe tables, but I tried 'show variables;' 

command to know about table support for mysql support. Only 'have_isam' is 'YES' 

all other are 'NO'. Does this means I didn't have support for all other tables ? 

If so, what should I do to use transaction - safe tables.

Details about mysql installation
OS: Windows-NT
mysql version: 3.23.37-debug for Win-95/Win-98

OS: Redhat Linux 6.2
mysql version: 3.23.38 for pc-linux-gnu

Please guide us for the same,

Thanks and Regards,

 




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

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

Re: Problems Creating BDB Type Tables


On Sat, Sep 01, 2001 at 05:30:16AM -, sameer ranadive wrote:
 
 Dear Sir,
 
 We are developing supply chain management where we are using EJB and
 mysql as back end. We want to use transaction safe tables, but I
 tried 'show variables;' command to know about table support for
 mysql support. Only 'have_isam' is 'YES' all other are 'NO'. Does
 this means I didn't have support for all other tables ?

You want to use MySQL-Max to get built in BDB or InnoDB tables, which
are transaction safe.  There's a download link on www.mysql.com.

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

MySQL 3.23.41-max: up 1 days, processed 16,241,153 queries (139/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: auto_increment


On Fri, Aug 31, 2001 at 04:07:14PM -0500, Tony Bibbs wrote:

 can anyone tell me why an auto increment field would jump from 231
 to something large like 883607 and then give me failure on future
 insertions because of a duplicate key?

Sounds like a corrupt index.

 I'm running mysql 3.23.39 on RH 7.1

Run a CHECK TABLE table and follow-up with REPAIR TABLE table
if there are any errors.

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

MySQL 3.23.41-max: up 1 days, processed 16,263,318 queries (139/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: MySQL Replication