Annoying Too Many Connection error...

2001-08-10 Thread Fournier Jocelyn [Presence-PC]
Hi, I've just seen when the maximum connection number is reached and you try to shutdown MySQL with mysqladmin shutdown, it couldn't be executed because of "too many connections" error. It would be smarter if mysqladmin could shutdown MySQL whatever the number of connections, even if the maxi

hello

2001-08-10 Thread Camel
Hi,everybody! I want to write a Client GUI DBMS for Mysql,but I don't know how to start. Anyone can tell me about the API,how to get it,how to begin? (I should use create,drop,insert,delete,update...) thank you very much _

Relication

2001-08-10 Thread Neil Tompkins
Hello All I'm new to MySQL although I have experience with SQL Server and MS Access. My current ISP offers MySQL and I would like to make it possible for one of my customers to transfer there data from MS Access to MySQL. This is fine and I know how to do this using ODBC(). But then I would

Re: mysqlgui 1.7.5 source

2001-08-10 Thread Bo Green
I have fltk, flvw, fleditor and the mssql++ libraries linked in, I'm pretty sure this is not the answer, but I could be wrong... Bo Grigory Bakunov wrote: > Date |Thu, 09 Aug 2001 23:54:16 -0400 > >From |Bo Green <[EMAIL PROTECTED]> > > Hello! > > BG> The source package for mysqlgui Makefile r

MySQL Query problem, possible bug?

2001-08-10 Thread Leon Mergen
Hello, Today, I tried to move a part of one of my websites, a forum (vBulletin, www.vbulletin.com) to a new server: a FreeBSD server. I installed the package mysql-3.23.40-unknown-freebsdelf4.3-i386.tar.gz on that server, and everything seemed to work perfectly: installation complete, and phpM

Re: BSD/OS 4.1 binary for MySql

2001-08-10 Thread Sinisa Milivojevic
David Ross writes: > Is the freebsd-elf mysql binary available at mysql.com compatible with > BSD/OS (bsdi) 4.1? If not, is there a place to download this > binary...or am I stuck with building it myself? > > Thanks, > David You should build it yourself. Just follow instructions from the manua

Re: HOWTO enable InnoDB

2001-08-10 Thread Miguel Angel Solórzano
At 19:27 10/08/2001 +0900, =?euc-kr?B?vcnD5rq4?= wrote: Hi! Are you set the my.cnf file for the InnoDB variables and created the data and log directories before the start of the server ?. Take a look in the server_name.err file if you find the message of InnoDB mentioning that wasn't be able to i

Re: Fatal warning in MySQL build Sun Solaris x86

2001-08-10 Thread Sinisa Milivojevic
Jeff Tanner writes: > > mysql.cc, line 1187: [__1cVbuild_completion_hash6Fbb_v_]: OPT: Unknown > linkage type in dependency graph > 1 fatal error > > Ideas? > > Thanks > > Jeff Tanner > Seattle, WA Your C++ compiler is broken. Please re-install entire GNU 2.95.2 suite. -- Regards, __

Re: HOWTO enable InnoDB

2001-08-10 Thread Peter Zaitsev
Hello ½ÉÃæº¸, Friday, August 10, 2001, 2:27:56 PM, you wrote: DISABLED means you're running with --skip-innodb AFAIK :) ½> Hi everyone. ½> I uninstalled mysql and reinstalled using --with-innodb configuration. ½> After install completed, I entered the command mysqladmin variables and ½> foun

Re: Binary transaction log

2001-08-10 Thread Sinisa Milivojevic
Michael T. Babcock writes: > I've been reapplying transactions to my aforementioned screwed up database. > It seems however, that the binary transaction log doesn't quite work > properly > with user variables (with MySQL 3.23.38). I have this entry from the log: > > insert into Projects (ParentI

HOWTO enable InnoDB

2001-08-10 Thread 심충보
Hi everyone. I uninstalled mysql and reinstalled using --with-innodb configuration. After install completed, I entered the command mysqladmin variables and found that value of "have_innodb" is DISABLED. So when I create table with type=InnoDB, this table has type=MyISAM. That is failure to creat

Re: Protection of /tmp/mysql.sock

2001-08-10 Thread Grigory Bakunov
Date |Thu, 9 Aug 2001 14:33:37 -0400 (EDT) >From |sachin shetty <[EMAIL PROTECTED]> Hello! SS> Hi SS> i think this isnt a purely mysql specific question but surely related. I SS> have a stick bit set on the /tmp directory(Solaris) where the socket file SS> resides.But there is no protection on

Re: problem!!

2001-08-10 Thread Grigory Bakunov
Date |Thu, 9 Aug 2001 20:58:14 -0300 (ART) >From |Raoni Novellino <[EMAIL PROTECTED]> Hello! RN> I installed MySQL 3.23.40 perfectly without RN> ploblems... but I installed MySQL for database to PHP RN> 4.0.6 with Apache 1.3.20... but when I compile Apache, RN> this error ocours: RN> <=== src/m

Re: mysqlgui 1.7.5 source

2001-08-10 Thread Grigory Bakunov
Date |Thu, 09 Aug 2001 23:54:16 -0400 >From |Bo Green <[EMAIL PROTECTED]> Hello! BG> The source package for mysqlgui Makefile references an BG> object 'edfile' which is not included in the source package BG> (at Aug 9, 2001). When I try to compile without that object, BG> I get a missing functi

Re: About installing MySQL on Linux 7.1

2001-08-10 Thread Grigory Bakunov
Date |Thu, 9 Aug 2001 14:45:23 +0800 >From |"Alan" <[EMAIL PROTECTED]> Hello! A> Excuse Me, A> I'm a starter to Linux. A> I've downloaded the MySQL-3.23.40-1 for my Linux OS. A> They are in .rpm form. How can I install the software properly on Linux! = A> I try to follow the instructions mentio

Re: MySQLdump failure

2001-08-10 Thread Grigory Bakunov
Date |Wed, 8 Aug 2001 23:02:26 -0400 >From |"Wendell Dingus" <[EMAIL PROTECTED]> Hello! WD> Right after that last C is my # command prompt with no line-ending character WD> in the file. It gets part way through the describe of the table layout and WD> stops. Using phpMyAdmin I can view everythin

Re: About MYSQLGUI

2001-08-10 Thread Grigory Bakunov
Date |Thu, 9 Aug 2001 10:38:09 +0800 (CST) >From |[EMAIL PROTECTED] Hello! T> Dear sir, T> I have a problem, I run the MYSQL GUI on my Server, but it always say that " Can't connect to local Mysql through socket " (111) This message tell what you try connect to local mysql and does'nt set up

Re: mySQL DSN and PHP

2001-08-10 Thread Grigory Bakunov
Date |Thu, 9 Aug 2001 10:36:59 +0800 >From |"Steve Doig" <[EMAIL PROTECTED]> Hello! SD> $link = mysql_connect("mySQL_test", "mysql_login", "mysql_password") SD> or die ("Could not connect"); SD> print ("Connected successfully"); SD> mysql_select_db ("test") SD> or die ("Could not select databas

Re: PROCEDURE ANALYSE

2001-08-10 Thread Sergei Golubchik
Hi! On Aug 10, Bernhard Doebler wrote: > Hi, > > I try to optimize my tables. To see possible "errors" I use SELECT > statements with PROCEDURE ANALYSE. I have a table that holds unique > strings and an index by whitch it's referenced to another table. > PROCEDURE ANALYSE advises as datatype

Re: About installing MySQL on Linux 7.1

2001-08-10 Thread Mario Witte
On Thu, Aug 09, 2001 at 02:45:23PM +0800, Alan wrote: > Excuse Me, > I'm a starter to Linux. > I've downloaded the MySQL-3.23.40-1 for my Linux OS. > They are in .rpm form. How can I install the software properly on Linux! = > > I try to follow the instructions mentioned in manual.txt but it didn

problem with mysql time and the system time

2001-08-10 Thread Gael FRAZIER
Hi, Since yesterday I'm reading all I can find on MySQL to solve my problem. in mysql : mysql>select now(); +-+ | now() | +-+ | 2001-08-10 07:28:56 | +-+ 1 row in set (0.00 sec) But on the system : (Linux Red Hat 7.1) /ho

Re: Replication problems

2001-08-10 Thread Rafal Jank
Luc Foisy wrote: > > We are looking for a solution to backing up a remote database, without using > mysqldump, and replication seemed to offer the solution required. > I set up the master/slave configurations on both the master and the slave > exactly the way it was shown in the MySQL documentati

PROCEDURE ANALYSE

2001-08-10 Thread Bernhard Doebler
Hi, I try to optimize my tables. To see possible "errors" I use SELECT statements with PROCEDURE ANALYSE. I have a table that holds unique strings and an index by whitch it's referenced to another table. PROCEDURE ANALYSE advises as datatype for the strings to take an enum of (String1,String2

Re: Add Character to Output

2001-08-10 Thread Ian Barwick
On Thursday 09 August 2001 17:58, Bernhard Doebler wrote: > I have a select statement and want to add a Percent sign to the output of > one expression. Do I have to use Concat-function or is there another way > (for only one character)? AFAIK concat is the only way in MySQL, viz: SELECT CON

Re: connecting by knowing someone's "scrambled" password?

2001-08-10 Thread Sergei Golubchik
Hi! On Aug 10, Carsten H. Pedersen wrote: > > http://www.mysql.com/doc/U/s/User_names.html > > says: > > >>> > > MySQL encrypts passwords using a different algorithm than the one used > > during the Unix login process. See the descriptions of the PASSWORD() and > > ENCRYPT() functions in s

Re: Installing MySQL on Linux 7.1

2001-08-10 Thread Cristian Paslaru
On Fri, 10 Aug 2001, Alan wrote: > I'm a starter to Linux. > I've downloaded the MySQL-3.23.40-1 for my Linux OS. > They are in .rpm form. How can I install the software properly on Linux? > I try to follow the instructions mentioned in manual.txt but it didn't work. > Can you help me and tell my

Re: Installing MySQL on Linux 7.1

2001-08-10 Thread louie miranda
rpm -i mysql.rpm ? louie miranda (axishift.ath.cx) --- Security is not a product - It is a Process - Original Message - From: "Alan" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, August 10, 2001 3:45 PM Subject: Installing MySQL on Linux 7.1

Re: Optimising for 4096MB RAM

2001-08-10 Thread joseph . bueno
Corin Hartland-Swann wrote: > > Hi there, > > I am trying to optimise MySQL for use on a machine with: > > Linux 2.4.7-ac9 (only kernel to work with the disk controller) > Dual Pentium III 1000 MHz > 4096 MB memory > RAID-1 Mirror over two 76GB 7200 RPM UDMA disks > Reiserfs partition

Installing MySQL on Linux 7.1

2001-08-10 Thread Alan
Excuse Me, I'm a starter to Linux. I've downloaded the MySQL-3.23.40-1 for my Linux OS. They are in .rpm form. How can I install the software properly on Linux? I try to follow the instructions mentioned in manual.txt but it didn't work. Can you help me and tell my how to install it via RPM? Than

RE: programmatically getting field list from a table

2001-08-10 Thread Don Read
On 10-Aug-2001 Bennett Haselton wrote: > Is there any way -- using either MySQL directly, or (ideally) using the DBI > perl module -- to get a list of fields from a (possibly empty) table? (If > the table is nonempty, you can just use a perl function to get the first > record, and then apply

RE: SELECT using IN on SET data

2001-08-10 Thread Don Read
On 10-Aug-2001 [EMAIL PROTECTED] wrote: > Hi, > > Whats the most efficient way of doing a SELECT ... IN on a field of > datatype 'SET' ? > > Say you have four types of 'permissions': >- superuser >- poweruser >- normal >- guest > > Each user has a field, permis

RE: Problem with UPDATE statement

2001-08-10 Thread Don Read
On 10-Aug-2001 Julian Simpson wrote: > In what way is it mangling my query? > and why won't the same query work from my php script. > I would accept this if it was just any interface but myphpadmin is supposed > to be in line with mysql standards. > >>> update cdrequest set albumfill = "hot sho