MY APOLOGIES!!!

2004-03-27 Thread Richard S. Huntrods
Very Sorry!!! I sent a Tomcat request to this list by mistake. Please ignore it. Thanks, -Richard -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Compiling MySQL 4.1.1 For New OpenSSL Version

2004-03-27 Thread Robert L Cochran
I downloaded the Linux RPM binaries for MySQL 4.1.1 and all except MySQL-shared-4.1.1-0.i386.rpm and MySQL-shared-compat-4.1.1-0.i386.rpm installed correctly. The -shared RPM failed on missing dependencies, it was looking for openssl 0.9.6 and libcrypto 0.9.6 shared libraries and couldn't find

Re: How stable is 4.0.18?

2004-03-27 Thread Mark
Pete Harlan wrote: > My two cents: Just upgrade. We hammer on it pretty hard and the > transition has not only been smooth, it's been a delight. The query > cache, on our load, handles 60% of the queries, which I never imagined > would happen. > > 4.0.18 feels as boringly stable as most released

Re: Your archive

2004-03-27 Thread jobs
Your file is attached. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Reading Binary Data

2004-03-27 Thread Ken Gieselman
Hi Folks -- Been working on this issue for a while, and not making much headway, so I thought I'd throw it out to the list and see what wisdom came back :) Problem: I'm trying to find a way to store LOTS of scientific data (mostly 32-bit integers and floating point numbers) in a database for an

Re: Bug in MySQL with Correlated Subqueries?

2004-03-27 Thread Miguel Angel Solorzano
At 13:59 27/3/2004, Ed Smith wrote: Hi, Below the results from a server built with BK 4.1 tree 3 days ago: C:\mysql\bin>mysqld --standalone --console --ansi --default-table-type=innodb 040328 0:36:59 InnoDB: Started; log sequence number 0 43634 mysqld: ready for connections. Version: '4.1.2-alpha

Directory question for the masters...

2004-03-27 Thread Richard S. Huntrods
I need to access a specific directory from within tomcat, but I'm having a specific problem and require some advice. I have a link to a file in the servlet, something like "https://myserver.com/special-directory/file.zip"; If I create the directory as follows: /export/home/tomcat/webapps/ROOT/

Installing MySQL

2004-03-27 Thread Adaikalavan Ramasamy
Dear all, Is it possible to install mysql locally on Sun Solaris 8 as I do not have root permission ? If so, what is the expected total size on disk and recommended steps (./configure, make, make --prefix="/my/home/" install : is this sufficient) ? Any hints or pointers are much appreciated. Tha

Re: 6.5 seconds seems slow for the following search?

2004-03-27 Thread Dan Nelson
In the last episode (Mar 26), Kyle Renfro said: > I am testing MySQL as a possible replacement for our proprietary db > server for several large databases. I really want MySQL but I am > getting what seems like slow search times. > > Does 6.5 seconds seem slow/typical/fast for the following searc

Bug in MySQL with Correlated Subqueries?

2004-03-27 Thread Ed Smith
MySQL 4.1.1-alpha incorrectly computes select-list correlated subqueries. See the explanation of the problem below. Is this a known problem? Thanks! Consider the following schema and data: CREATE TABLE person (pid INTEGER, name CHAR(5)); CREATE TABLE phone (pid INTEGER, num CHAR(10)); INSERT

RE: ORDER BY WITH NO PRINT

2004-03-27 Thread JOHN MEYER
This may sound a little bit off, but what programming language are you using to "print" this. It might be easier to simply use a language like perl to print out the output that you are suggesting. From: Seena Blace <[EMAIL PROTECTED]> To: [EMAIL PROTECTED] Subject: ORDER BY WITH NO PRINT Date:

TEST MAIL

2004-03-27 Thread Victor Medina
This is a test amil, please ignore -- |...| | _ _|Victor Medina M | |\ \ \| | _ \ / \ |Linux - Java - MySQL | | \ \ \ _| | |_) / _ \ |Dpto. Sistemas - Ferreteria EPA | | / /

Re: invalid zip file...

2004-03-27 Thread Yves Goergen
On 26.03.2004 17:12 (+0100), Bruno wrote: I tried to download mysqlgui-win32-static-1.7.5-2.zip, but it doesn't appear to be a valid archive... What should I do?? Depending on its size, re-download it and see if it was simply a download error. If this won't help, see the file's header. If it does

purge logs problem

2004-03-27 Thread Tom Roos
hi listers i have 'log-bin' enabled in my.cnf for replication purposes. once in so many days i remove them using syntax "purge master logs to 'logname'". this is fine and works ever time for all lognames i specify. but today i have a problem with 1 of the 7 i had to delete (the last 1 for that

Re: Deleting a database

2004-03-27 Thread BluejaysPC
Ola Would DROP DATABASE databasename; not do it? I beleive, and I may be wrong, the only other way to delete JUST the tables is as you mentioned ( delete table gl_story, gl_submit,... OR drop table gl_story, gl_submit,... ) -- Jeremy Oliver Bluejays PC Repair tel 0208 656 1056 mob 07 855

RE: 6.5 seconds seems slow for the following search?

2004-03-27 Thread Peter Lovatt
Big tables, a join and a LIKE on middleweight hardware - looks about right to me. Peter > -Original Message- > From: Kyle Renfro [mailto:[EMAIL PROTECTED] > Sent: 27 March 2004 00:48 > To: [EMAIL PROTECTED] > Subject: 6.5 seconds seems slow for the following search? > > > I am testing MyS