installation problem with db-3.2.9a - makefile is not correct!

2001-03-06 Thread Craig Ian Dewick
Hi, I'm progressing through the install of mysql-3.23.33 with the db-3.2.9a package extracted and built within the mysql source tree, but it looks like the creation of ./db-3.2.9a/build_unix/Makefile hasn't worked correctly... This is what I get when I run 'make install' from the top-level of

problem under FreeBSD4.2-STABLE

2001-03-06 Thread Andrey Kotrekhov
Hi! Sometimes I look a problem with mysqld which load CPU. It work fine one week, two ... But ones something was happend and mysqld catch all CPU time. I don't know why. Mysqld continue work, but CPU load increase :( It catch 99% CPU I look in process list, kill all id, flush all tables and try

[ANN] MySQL Studio v0.7 Released.

2001-03-06 Thread support
** After months of development We are proud to announce the first public version of MySQL Studio. http://dba-tools.com/ MySQL Studio provides an extremely easy to use interface to MySQL servers. A

Re: MySQL License

2001-03-06 Thread Brooklyn Linux Solutions CEO
You can charge for any GPL'ed product you wish too. Ruben On 2001.03.05 22:31:41 -0500 Jeff Platzer wrote: Maybe someone can help me out with MySQL's commercial license. If MySQL server has a GPL license and MySQL client libraries have LGPL licenses, how can a paid commercial license be

Memory footprint

2001-03-06 Thread Simon Windsor
Hi On two separate but identical servers I am runing MySql, 3.22, on Debian (2.2.16) kernel. Using top, one mysqld server uses 10MB whilst the other uses just 3MB. Both servers have identical configuaration files, the only difference is that server 1 is much busier. Can anyone explain why

Re: Default values

2001-03-06 Thread Fred van Engen
On Mon, Mar 05, 2001 at 10:26:58PM -0600, MikemickaloBlezien wrote: Hello All, I've created a table(using MySQL 3.23.33), using default values: DROP TABLE IF EXISTS referral; CREATE TABLE referral ( refer_id int(10) UNSIGNED DEFAULT '100' NOT NULL, refer_fname varchar(20) DEFAULT ''

Question regarding query optimising with between

2001-03-06 Thread Christian Hammers
Hello I have a table with a normal multiple key on a datetime field called "end". I want to search for the number of records in some months. I know that there are none. Now "explain" tells me that a querey with a WHERE clause of end between '2001-01-01' and '2001-04-01' affects just one

Use of certain keywords in SQL statements problematic

2001-03-06 Thread eric
Description: We have just upgraded from 3.22.26a to 3.23.33. One table has a column name "FullText". However, any SQL statements (either using PHP or the command line interface) that directly reference the column will cause an SQL error, like:

Re: trying to install on RedHat 7.0 and need help

2001-03-06 Thread Irmund Thum
Charles L Hagen schrieb: mysqld dead but subsys locked it's successfully installed and running, but not really killed killall mysqld and start again you shouldn't post those long nonsense listings -- http://it97.dyn.dhs.org -- IrmundThum

Searching for misses

2001-03-06 Thread alec . cawley
I have a couple of SQL queries, both of which involve searching for misses rather than searching for hits. Would anybody be kind enough take a little time to assist me? Suppose I have a table of products, a table of components, and a table which says which components are used in which

troubles with joining list

2001-03-06 Thread Network
I don't see an address for the list owner so I'm mailing this here in hope of getting help. Why is the connection constantly resetting and not allowing me to join the list? This mail also serves as a test to see if I can post to the list without joining via [EMAIL PROTECTED] Mar 6 04:34:49

Re: Default values

2001-03-06 Thread MikemickaloBlezien
On Tue, 06 Mar 2001 09:18:34 -0600, "Gerald L. Clark" [EMAIL PROTECTED] wrote: Gerald, Try giving a number instead of a string as a default for an int. Not sure I follow, it is a number?? "MikeBlezien" wrote: Hello All, I've created a table(using MySQL 3.23.33), using default

Re: Match Records

2001-03-06 Thread Neelesh
Hello , Can you please tell me how to use transaction in mysql. I am using mysql version 3.23.32. I want to use EJB over it , it is giving problem of transaction as it is not supporting ENTITY with CMP. Thanks , Neelesh - Original Message - From: "Bob Hall" [EMAIL PROTECTED] To:

3.22.25 and RAND()

2001-03-06 Thread christopher sagayam
SELECT * from tablename ORDER BY RAND() does not work in 3.22.25 what is the equivalent ?? It works great in later versions chris _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com

RE: BDB tables on Linux

2001-03-06 Thread Mehalick, Richard RE SSI-GRAX
You must compile from source to get BDB support into mysql. Make sure you download the appropriate BDB source and place it in the mysql directory. - / Rick Mehalick Senior Consultant / Shell Services International SSI-GPAX / Phone:

load_file

2001-03-06 Thread Hesham Anan
Hi I have been trying to use load_file to store a file as a BLOB object in a database table but it always returns NULL although I have made sure that the path is correct and I have the appropriate priviliges. Any hints how to use load_file correctly ?

Off Topic Perl Mysql modules install problem

2001-03-06 Thread Curtis Maurand
Hello, I'm now lost. I cannot figure out what the make file is looking for. Anyone have any ideas? LD_RUN_PATH="/usr/lib/mysql:/lib:/usr/lib:/usr/lib/gcc-lib/i386-redhat-linux/2.9 6" cc -o ../blib/arch/auto/DBD/mysql/mysql.so -shared -L/usr/local/lib dbdimp.o mysql.o -L/usr/lib/mysql

Re: configure can't find LinuxThreads

2001-03-06 Thread Gerald L. Clark
That is an ancient version of Linux. [EMAIL PROTECTED] wrote: Description: When running ./configure it can't find LinuxThreads. Environment: Linux 2.0.35 downloaded and expanded LinuxThreads-2.1.3.tar.gz. It seems the tarball do not include pthread.h

Re: Perl/mysql.

2001-03-06 Thread Gerald L. Clark
N Sikkandar Dulkarnai wrote: Hello there, I just installed "mysql Ver 11.12 Distrib 3.23.33, for sun-solaris2.6 (sparc)". How do I insert rows into mysql database.tablevia PERL ?. It would be appreciated if some one can send some basic structure of connecting into sql using perl and some

One shot bug report

2001-03-06 Thread szii
The Makefile generated by v3.23.33 for BDB 3.2.9a has a line which is incorrect. ./configure --with-raid In db-3.2.9a/build_unix/Makefile --snip install: all install_include install_lib install_utility install_docs --end snip (it tries to execute install_include as a command since it's on