Re: fieltypes

2001-09-10 Thread Steve Edberg
Did you see http://www.mysql.com/doc/C/o/Column_types.html and http://www.mysql.com/doc/C/h/Choosing_types.html ? If there's something there that is confusing, let us know - - steve At 11:22 PM +0200 9/10/01, Mike Schwarz wrote: >hi > >i'm a newbie with mysql, just kn

RE: Should We purchase mysql license Under Windows 2000??----Please Help!!!

2001-09-10 Thread michael johnson
If you are using MySQL for commercial gain then you need a developer's license. Michael Johnson Director BPEnet Humphrey Consulting Limited 13 Austin Friars London EC2N 2JX Tel +44(0)1323 438975 Fax +44(0)1323 738355 email [EMAIL PROTECTED] URL www.bpenet.net Also in Dublin & Luxembourg -Ori

AW: Should We purchase mysql license Under Windows 2000??----Please Help!!!

2001-09-10 Thread Walter Bertin
what does it mean commercially in the case of MySQL. do I need a license (pay mony) to make my own page/site or if i make it for a firend To my understanding - as long as i do not make profit or think i will make profit while using software product under GNU license, like MySQL, or

Re: MySQL Sock error

2001-09-10 Thread Lance Rochelle
Actually it came sometimes be worse in *nix depending on how anal retentive your administrator is. - Original Message - From: "adam" <[EMAIL PROTECTED]> To: "MySQL Mail List" <[EMAIL PROTECTED]> Sent: Tuesday, September 11, 2001 12:20 AM Subject: RE: MySQL Sock error > Thank you everyone

RE: MySQL Sock error

2001-09-10 Thread adam
Thank you everyone who helped :o) I got MySQL up and running... as it turned out it was a permissions problem... go figure.. i hoped i left that all behind with NT :o) -Adam - Before posting, please check: http://www.mysql.c

Re: MySQL processor overload

2001-09-10 Thread Ryan Shrout
This problem is almost exactly like the "load level on linux" one seen earlier, and like about 5 others I've seen on this list including my own. Why is we can not get a straight answer from anyone on this??? Ryan Shrout Owner - Amdmb.com http://www.amdmb.com/ [EMAIL PROTECTED] - Original Me

Re: MySQL processor overload

2001-09-10 Thread Michael Bacarella
On Tue, Sep 11, 2001 at 11:13:48AM +0800, Andrew I. Baznikin wrote: I'm not so sure that this is MySQL's fault as it is the FreeBSD thread library. IIRC, under the FreeBSD thread implementation, the process will spin away doing essentially sched_yield() if it's simply waiting for blocked I/O to

MySQL processor overload

2001-09-10 Thread Andrew I. Baznikin
>Description: Sometimes MySQL capture 80-90% of processor time. # top PID USERNAMEPRI NICE SIZERES STATETIME WCPUCPU COMMAND 45215 mysql53 0 31960K 5480K RUN941:42 94.68% 94.68% mysqld #truss -p `cat /var/db/mysql/poster.pid ` g

Linux 2.4.x VM and MySQL (Re: A question about load / queries pr second)

2001-09-10 Thread Jeremy Zawodny
On Fri, Sep 07, 2001 at 07:19:01AM -0700, Mike Wexler wrote: > > Jeremy Zawodny wrote: > > > > On Fri, Sep 07, 2001 at 12:07:07PM +0100, Basil Hussain wrote: > > > > > > I'm quite surprised that this level of performance is available from > > > such standard (well, not standard as in 'common', b

Re: help with mysql.sock error

2001-09-10 Thread Trond Eivind Glomsrød
adam <[EMAIL PROTECTED]> writes: > I am having trouble with mysql... i keep getting > "ERROR 2002: Can't connect to local MySQL server through socket > '/var/lib/mysql/mysql.sock' (2)" You probably didn't start it the correct way, by using the included initscript ("/etc/init.d/mysqld", also us

Re: help with mysql.sock error

2001-09-10 Thread Mike Rogers
su nobody ls -l /var/lib/mysql/mysql.sock Whatever user is trying to get it [such as nobody for a web server usually or the user]- make sure the user can access the file. Make sure you don't have maybe /var/lib/mysql to be 750 or something like that. Permissions is a big one. -- Mike - Or

Looking for a Data entry program for mysql...

2001-09-10 Thread Francois Meehan
Hi all, I am looking for a freeware-shareware pgm for data entry, on win32 for a mysql database on Linux(not that it matters I guess), that would allow me to feed data with "drop down" or "list box" field. Any suggestions??? Thanks in advance... #

Strange insert behavior with larger tables

2001-09-10 Thread Brett Error
This weekend I wanted to better characterize how different key configurations affect the way rows are inserted. I ran into some behavior I can't understand: I created a prototype table to allow me to track the number of events that occur on a particular day. Events are described with three inte

Re: load level on linux mysql server out of control

2001-09-10 Thread Henning Schroeder
At 01:46 11.09.01, you wrote: >I'm having a lot of trouble tracing the origin of the problem -- >sometimes it seems that accessing a particular large table is causing >it, sometimes it seems that a combination of factors is causing it. >Regardless, what I observe is that within 1 minute my load

when i try connect since a client windows9x to mysql ...

2001-09-10 Thread Miguel Enriquez Alvarado
hi all this is my first question: when i try connect since a client windows9x to mysql (in a server linux rh 7.0), say me the next error: General Sql Error: [TCX][MyODBC]Access deneied for user [EMAIL PROTECTED] (using password YES) alias Test i make the user and system dsn, anyone have a

Re: my.cnf optimization question ..

2001-09-10 Thread Jeremy Zawodny
On Mon, Sep 10, 2001 at 04:54:57PM -0500, Weslee Bilodeau wrote: > > Basic (maybe?) question on some optimal variables for MySQLd's my.cnf > configuration .. > > Right now, I have three MySQL servers, each with 2 GB ram, dual-CPU > P3 1ghz. Nice. :-) > They average around 500 connections/second

RE: mysql Digest 10 Sep 2001 21:47:08 -0000 Issue 1490

2001-09-10 Thread Frank Cizmich
- Original Message - From: <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, September 10, 2001 6:47 PM Subject: mysql Digest 10 Sep 2001 21:47:08 - Issue 1490 - Before posting, please check: http://ww

RE: @HOSTNAME@error

2001-09-10 Thread Narvaez, Teresa
Those are the startup scripts to startup MySQL when the server is rebooted. view the file /etc/init.d/rc.d/S61mysql and search for "@HOSTNAME@" and "my_print_defaults" and see how these commands are invoked and if they exists on your system. Hope this helps, -Teresa -Original Message-

Re: FW: URGENTE - Replication...... - mySql

2001-09-10 Thread Sasha Pachev
On Monday 10 September 2001 09:43, Rodrigo Zerlotti wrote: > here it is... > > - > Regards, Rodgrigo: Thanks for a bug report. We will try to get this fixed in 3.23.43. Next time, please write to [EMAIL PROTECTED] when you find a bug and have a test case for it. This address ([EMAIL P

help with mysql.sock error

2001-09-10 Thread adam
I am having trouble with mysql... i keep getting "ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)" I uninstalled and reinstalled MySQL rpm (RH 7.1). I originally I was able to connect to MySQL server via command line client, but could not connect v

load level on linux mysql server out of control

2001-09-10 Thread djinn
I'm running mysql 3.23.41 on a PIII 800 Mhz machine with 512MB RAM, linux kernel 2.4.7, dedicated machine (ie, not running anything other than MySQL). I've been running mysql in a production environment for nearly 2 years, moderately hit (500,000 - 800,000 database connects per day) with no probl

Re: Copying data from one table to another.

2001-09-10 Thread Eric Spletzer
Will this actually work? Because I can't select from the table into which I'm inserting. Also I don't want to insert. I want to update a bunch of records that already exist. Here is exactly what I want to do. I have two tables set up that I'm dealing with right now.  One is the main informati

Re: Seemingly Strange Variable Behavior

2001-09-10 Thread Paul DuBois
At 4:35 PM -0500 9/10/01, Sheridan Saint-Michel wrote: >I ran into this and was hoping someone on this list can explain this >behavior to me. > >Lets say I have the table "table" which has id and name, and five rows of >data. > >I am using the query >select table.*,if(@count,@count:=@count+1,@coun

my.cnf optimization question ..

2001-09-10 Thread Weslee Bilodeau
Basic (maybe?) question on some optimal variables for MySQLd's my.cnf configuration .. Right now, I have three MySQL servers, each with 2 GB ram, dual-CPU P3 1ghz. They average around 500 connections/second at any given time, two have a master/slave setup. MySQL is prettty much the only thing r

Re: Copying data from one table to another.

2001-09-10 Thread Sheridan Saint-Michel
I think what you are looking for is the Insert...Select statement http://www.mysql.com/doc/I/N/INSERT_SELECT.html Sheridan Saint-Michel Website Administrator FoxJet, an ITW Company www.foxjet.com - Original Message - From: "Eric Spletzer" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent

Copying data from one table to another.

2001-09-10 Thread Eric Spletzer
Hello, I'm a newbie, so pardon my lack of wherewithal with MySQL, and thanks for the help in advance. I have two table and I want to copy info from one table to another. I can pull the correct information out with a select statement that looks something like this Select x1 from tbl1, tbl2 where

how do I export/import the whole database

2001-09-10 Thread Gene Gurevich
HI all. Can I export/import the whole database in MySQL. I have exported the database into a text file. Now when I try mysql 'database' < filename; it errors out because column_privs table exists. I thought mysqlimport would help, but judging by what the manual says it only imports the single tab

Seemingly Strange Variable Behavior

2001-09-10 Thread Sheridan Saint-Michel
I ran into this and was hoping someone on this list can explain this behavior to me. Lets say I have the table "table" which has id and name, and five rows of data. I am using the query select table.*,if(@count,@count:=@count+1,@count:=1) as count, from table; What I get is id, name, and five r

fieltypes

2001-09-10 Thread Mike Schwarz
hi i'm a newbie with mysql, just knowing well access mysql seems to have a lot more of fieldtypes and i'm wondering, which field type i should chooce in which case ?? is there a list and description with examples? i root the manual and was not very satisfied. thank you for any help mike

Re: @HOSTNAME@error

2001-09-10 Thread harry amarantidis
I checked my boot log and found the follwing errors /etc/init.d/rc.d/S61mysql: @HOSTNAME@: command not found /etc/init.d/rc.d/S61mysql: my_print_defaults: command not found I have checked the manual but could not figure out if this is a problem or not mysql seems t run fine for now. What are thes

Re: 'localhost' problem

2001-09-10 Thread harry amarantidis
I had the same problem with suse 7.2. I see that the path to mysql.sock is /var/lib/mysql/mysql.sock. this location of mysql.sock was a leftover from the mysql that i installed from the distribution. the downloaded version though stores the mysql.sock in /tmp/mysql.sock - i had to tell a few of my

Re: Still Searching for Accent solution - MySQL 3.23

2001-09-10 Thread Brian Litke
Joshua, I'm not really asking for a new feature. I'm just trying to get the accent insensitive search to work. If you look at the 3.23 Change Log http://www.mysql.com/doc/N/e/News-3.23.0.html the ninth bullet says: "Changed LIKE character comparison to behave as =; This means that 'e' LIKE '

Re: print

2001-09-10 Thread Paul DuBois
At 3:18 PM -0400 9/10/01, Jeremy Morano wrote: >Hi, > >very simple question. > >I would like to save and print the contents of myDESCRIBE table_1; > >How would I do this? Use the --tee option to mysql to create a tee file that serves as a log of your session, and issue the statement interacti

RE: ASP & MySQL

2001-09-10 Thread Dipl.-Inf. Guus Leeuw jr.
> -Original Message- > From: L_U_I_Z [mailto:[EMAIL PROTECTED]] > Sent: Monday, September 10, 2001 9:08 PM > To: [EMAIL PROTECTED] > > I'm developing an application and I have to choose a good database > server. I guess that's not the only choice... > I'm considering MS SQL

Re: mysqldump question (very basic)

2001-09-10 Thread Paul DuBois
At 12:11 PM -0700 9/10/01, Gene Gurevich wrote: >Hi. > >I'm trying to run a mysqldump. I enter mysqldump >-databases in order to backup all the databases. For >some reason all I'm getting back is a help on the >mysqldump. What am I doing wrong? If you're really entering the option as -databases,

RE: ASP & MySQL

2001-09-10 Thread Dave Carter
I use ASP and mySQL. I love it! Dave Carter Chief Web Architect Accelerated Business Technologies, Inc. http://www.abti.net 717.464.2970 -Original Message- From: L_U_I_Z [mailto:[EMAIL PROTECTED]] Sent: Monday, September 10, 2001 4:08 PM To: [EMAIL PROTECTED] Subject: ASP & MySQL I'm

RE: ASP & MySQL

2001-09-10 Thread Ralof
I usually use MySQL with MyODBC, then it is just like any other database, but faster :) Stefan > -Original Message- > From: L_U_I_Z [mailto:[EMAIL PROTECTED]] > Sent: den 10 september 2001 22:08 > To: [EMAIL PROTECTED] > Subject: ASP & MySQL > > > I'm developing an application and I hav

Re: ASP & MySQL

2001-09-10 Thread Webmaster
YES!!! I use ASP and MySQL... Works Great (Win2K, IIS5.0) John (www.smalltownworld.com) - Original Message - From: "L_U_I_Z" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, September 10, 2001 2:08 PM Subject: ASP & MySQL > I'm developing an application and I have to cho

revoke privileges

2001-09-10 Thread franky
Ok let me explain my problem: I do: grant SELECT,alter,index,insert,update on SK_10.* to "admin-ab-44" identified by "ab-44"; -- So the use get all right... And : revoke all on SK_10.users_profiles from "admin-ab-44"; -- So now they have all right except in SK_10.users_profiles ... But the

ASP & MySQL

2001-09-10 Thread L_U_I_Z
I'm developing an application and I have to choose a good database server. I'm considering MS SQL Server and MySQL. I haven't heard very much about MySQL, but from I've read on the web I think MySQL is Unix/Linux orientated and works well with PHP. I'm going to use a NT platform, wi

RE: UNION workaround?

2001-09-10 Thread Solsberry, Glendon
I need to do this seemingly simple thing in mySQL: SELECT SUM(wucount), SUM(genecount) FROM genomestats WHERE curDate IN ('09-09-2001 9:30:00', '09-09-2001 12:30:00'); However, the SUM() returns the SUM of both dates. However, I could do SELECT SUM(wucount), SUM(genecount) from genomestats WHER

Re: 'localhost' problem

2001-09-10 Thread Crazy Linux
yes..the /etc/hosts file reads like the following: 127.0.0.1 localhost.localdomain localhost 138.xx.xx.xx mydomain.edu mymachine thanks --- Lance Rochelle <[EMAIL PROTECTED]> wrote: > is localhost setup correctly in /etc/hosts file? > i.e. 127.0.0.1 localhost, > if not put that

Re: print

2001-09-10 Thread Van
Jeremy Morano wrote: > > Hi, > > very simple question. > > I would like to save and print the contents of myDESCRIBE table_1; > > How would I do this? Jeremy: mysql -e 'DESCRIBE table_1;' | lp Regards, Van -- = Linux rocks

Re: REMOVE NOW THIS IS THE SECOND TIME

2001-09-10 Thread Robert Alexander
Good words, Mauricio. /Rob Toronto, Ontario, Canada Ob. MySQL: database, sql, query, table >;-) > >and can't read either ;) > >c'mon guys... lets keep the ethnic humour down... >i'm sure it does not do any good to business, >although it sure, well, tingles sometimes... > >we all

print

2001-09-10 Thread Jeremy Morano
Hi, very simple question. I would like to save and print the contents of myDESCRIBE table_1; How would I do this? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com

mysqldump question (very basic)

2001-09-10 Thread Gene Gurevich
Hi. I'm trying to run a mysqldump. I enter mysqldump -databases in order to backup all the databases. For some reason all I'm getting back is a help on the mysqldump. What am I doing wrong? thanks = __ Do You Yahoo!? Get email alerts & NEW

Still Searching for Accent solution - MySQL 3.23

2001-09-10 Thread Brian Litke
Hello, I'm still having problems with MySQL 3.23 being accent sensitive during searches. However, I'm now tested to ensure I'm getting the correct accented search term to MySQL. Here's my test page, which includes a small database of names with 2 entries per name, one including an accented vowe

'localhost' problem

2001-09-10 Thread Crazy Linux
hello all, i am running mysql on a red hat linux v7.0 box. when i am trying to connect to the mysql database to read a table that is present in the mysql database i am facing a strange problem. i am able to get into the database(named 'newone') to read the table (named 'namelist') from the comma

Re: REMOVE NOW THIS IS THE SECOND TIME

2001-09-10 Thread Van
Tonu Samuel wrote: > > On 09 Sep 2001 21:24:51 +, Mourad de Riche wrote: > > > > > Is he drunk or something? Report to a federal law? > > No, he is from United States. According to Sklyarov case they think > that world consists only from them and everyone should follow their > rules, even w

Re: Stored procedures (2)

2001-09-10 Thread Dana Powers
> - The Perl "stored procedures" (myperl project) in not a good idea >at all, but, even if called "poor man's stored procedure", I >think that this project don't add, actually, stored procedure in >the precise meamning of term. It add only a binding with Perl via UDF. >It's a nice

Re: Let's approach stored procedures

2001-09-10 Thread Dana Powers
> Depending on the way you define things, MIN and MAX are essentially > stored procedures that were programmed into MySQL. Why not let us make > our own? This is already possible with Aggregate UDF 's. Check the manual here: http://www.mysql.com/doc/A/d/Adding_functions.html dpk -

Re: MySQL Performance Problem

2001-09-10 Thread Wesley Darlington
On Thu, Sep 06, 2001 at 05:26:53PM +0200, Henning Schroeder wrote: > >Find all the queries that interact with this table. EXPLAIN them. Time them. > > *all* of them? there are lots. Well, perhaps not initially but you may want to have EXPLAINed a majority of the queries that are issued against

revoke privilege

2001-09-10 Thread franky
I do: grant SELECT,alter,index,insert,update on SK_10.* to "admin-ab-44" identified by "ab-44"; And : revoke all on SK_10.users_profiles from "admin-ab-44"; But the user cant always make a SELECT * from SK_10.users_profiles ; I want no acces to the table SK_10.users_profiles what can i do?

Re: MyODBC, DBUG and multi-threaded clients

2001-09-10 Thread Peter Duffy
Hi Monty, Michael Widenius wrote: > > Hi! > > I have a small comment to this. > > > Note that you will get crashes in the DBUG package if you call any > MySQL function inside a thread that hasn't called mysql_init() or > mysql_connect(). > > If you want to use MySQL functions in threads that

Re: Index Question

2001-09-10 Thread Paul DuBois
>Hello All, > >I've got a question that is likely an easy one, I just want confirmation from >my peers. > >I have tables with a timestamp column and perform many selects and counts from >these tables based on the date that the record was written. > >Can/should I index a timestamp column? I do my b

Re: Index Question

2001-09-10 Thread Rodney Broom
From: <[EMAIL PROTECTED]> > Can/should I index a timestamp column? Can: Yes. Should: Why not? > Should I treat it as a char and > limit it to just index on the portion of the data that distinguishes the date Hmm, I wouldn't. Offhand, I'd guess that MySQL handles time/date things as integers

3.23.42 and some errors in logfile

2001-09-10 Thread Martin MOKREJŠ
Hi, so I've tried the binary distribution for linux and I have these errors in logfile (I've seen them already under 3.23.41, under which I compressed the tables): 010910 18:12:20 mysqld started /usr/local/mysql/bin/mysqld: ready for connections 010910 18:13:52 read_const: Got error 127 when

Index Question

2001-09-10 Thread t_mills
Hello All, I've got a question that is likely an easy one, I just want confirmation from my peers. I have tables with a timestamp column and perform many selects and counts from these tables based on the date that the record was written. Can/should I index a timestamp column? I do my best to i

Re: indexes and desc

2001-09-10 Thread Jeremy Zawodny
On Mon, Sep 10, 2001 at 09:13:06AM -0700, PR wrote: > > And are there future plans for indexing on desc order? This is already fixed in MySQL 4.0. -- Jeremy D. Zawodny, <[EMAIL PROTECTED]> Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3

Re: sqld core dump after power failure

2001-09-10 Thread Gerald Clark
Did you try deleting the mysql.sock before starting the server? fsck seems to have changed its file type. Katrina Maffey wrote: > Description: > > After a brief power failure, I rebooted the mysql server machine, > and got this error on startup: > > Starting mysqld daemon with databases f

Re: [Chicago.pm]: Perl MySQL OO design question

2001-09-10 Thread Andy Lester
> I have a perl->DBI->MySQL database app. that handles everything from my > order entry to my accounts payable. I am in the process of cleaning up > a lot of the code I've written to make it easier to maintain. I > probably use the following DBI staement handle about fifty different > places on

Re: Simple select problem.

2001-09-10 Thread Paul DuBois
At 5:46 PM +0300 9/9/01, Eyal Rif wrote: >Hi, > >I have a table with the format of : > >char(20),int(7),char(32) > >the "Date char(20)" contents in actually a number(seconds since 1970) - > >I want to use a "select" query that will give the max value according to >number value of that column. > >s

Re: Perl MySQL OO design question

2001-09-10 Thread Adams, Bill TQO
Richard Reina wrote: > I have a perl->DBI->MySQL database app. that handles everything from my > order entry to my accounts payable. I am in the process of cleaning up > a lot of the code I've written to make it easier to maintain. I > probably use the following DBI staement handle about fifty

Re: Simple select problem.

2001-09-10 Thread Gerald Clark
How about SELECT @last:=MAX(Date + 0) from stat; Eyal Rif wrote: > Hi, > > I have a table with the format of : > > char(20),int(7),char(32) > > the "Date char(20)" contents in actually a number(seconds since 1970) - > > I want to use a "select" query that will give the max value according t

indexes and desc

2001-09-10 Thread PR
When doing a select that is ordered by a column that is indexed and has a limit, does mysql not use the index if the order by is descending? Here's an example: select parent,number,lastpost from posts where topic=1 and board='abc' and approved='yes' order by lastpost desc limit 9,12 My app is a

Re: Select where A is not a member of B

2001-09-10 Thread Benjamin Pflugmann
Hi. On Mon, Sep 10, 2001 at 02:38:56PM -0700, [EMAIL PROTECTED] wrote: [...] > I need to find, for each user, whether they are a member of list n : > > ++--+ > | userid | memberoflist | > ++--+ > | 1 | true | > | 2 |false | > |

Re: Column definition: The EXTRA column

2001-09-10 Thread Paul DuBois
At 2:04 PM +0200 9/10/01, Ralof wrote: >I am trying to use the EXTRA column that exist >in mySQL ( DEFAULT > EXTRA > FIELD > KEY > NULL > PRIVILEGES > TYPE), but I do not understand how to put a >value into it,

Re: GEMINI Table Type

2001-09-10 Thread Paul DuBois
At 9:20 AM -0600 9/10/01, ROGGER ALEXIS VASQUEZ MARTINEZ wrote: >Hi : >First of all I've test for a short period MYSQL, I >think is great ,,, recently I was navigating MYSQL.COM >and I found and read about the dispute with MYSQL.ORG >I enter the site to see what it was ... >I notice they promote a

Re: GEMINI Table Type

2001-09-10 Thread Benjamin Pflugmann
Hello. On Mon, Sep 10, 2001 at 09:20:55AM -0600, [EMAIL PROTECTED] wrote: [...] > What I understand is that MYSQL.COM <> MYSQL.ORG, but > does MYSQL.COM has a table type same as GEMINI ( GEMINI does not complies > with GPL according > to what I read) > that support the ACID PROPERTIES ( TRANSACTI

Perl MySQL OO design question

2001-09-10 Thread Richard Reina
I have a perl->DBI->MySQL database app. that handles everything from my order entry to my accounts payable. I am in the process of cleaning up a lot of the code I've written to make it easier to maintain. I probably use the following DBI staement handle about fifty different places on differ

Re: Weird problem

2001-09-10 Thread Adams, Bill TQO
Silver Fox wrote: > I just got this problem... > > bin/mysql -h localhost -u root > logs me into MySQL at the command line > > However, the CGI script for Apache webserver gave me an error connecting to > the database > $source = "DBI:mysql:red:localhost"; > $username = "root"; > $password = "";

compiling MySQLGUI

2001-09-10 Thread Grau, Stephen
I am trying to compile MySQLGUI for solaris 8. I can't use the precompiled version as I do not have the same version shared library for libstdc++. Recompiling that at this point is not an option. The precompiled version is also several revisions old and not compiled for solaris 8 (this last argume

Weird problem

2001-09-10 Thread Silver Fox
I just got this problem... bin/mysql -h localhost -u root logs me into MySQL at the command line However, the CGI script for Apache webserver gave me an error connecting to the database $source = "DBI:mysql:red:localhost"; $username = "root"; $password = ""; Did any of you ever face this probl

Re: InnoDB tables : difficulties with COUNT(*), DELETE etc ...

2001-09-10 Thread Heikki Tuuri
Alex, slowness of count(*) is a well-known problem. I will fix it some time this fall. Not very easy, because of multiversioning and recovery. The other problem you have is that a delete operation ends up in a deadlock (I think it should not be called a 'crash'). I will write in October a selec

GEMINI Table Type

2001-09-10 Thread ROGGER ALEXIS VASQUEZ MARTINEZ
Hi : First of all I've test for a short period MYSQL, I think is great ,,, recently I was navigating MYSQL.COM and I found and read about the dispute with MYSQL.ORG I enter the site to see what it was ... I notice they promote a type of table name GEMINI ... that support the ACID properties ... W

Re: Mergetable locking

2001-09-10 Thread Benjamin Pflugmann
Hi. On Mon, Sep 10, 2001 at 12:46:01PM +0200, [EMAIL PROTECTED] wrote: > How does mysql manage locks on mergetables? As far as I can see, it locks all underlying tables. This may not be the best, but a reasonable approach, because it doesn't know beforehand which tables will be involved. Bye,

segmentation fault post mysql server binary install for solaris-i386

2001-09-10 Thread Jeff Tanner
I am getting a segmentation fault on a solaris i86pc when executing either with: ./bin/safe_mysqld & ./bin/mysql -h active_mysql_host On this solaris i86pc, I got the following binary install: mysql-3.23.39-pc-solaris2.8-i386.tar.gz Then untarred it with GNU tar (gtar-i

Too many open files

2001-09-10 Thread Robin Keech
My Mysqld stopped accepting connections with Error log: 010910 15:34:19 Error in accept: Too many open files 010910 15:49:02 /usr/local/mysql/libexec/mysqld: Normal shutdown when trying to connect I got: ERROR 2013: Lost connection to MySQL server during query changed max_connections and r

Re: Select where A is not a member of B

2001-09-10 Thread Carl Troein
[EMAIL PROTECTED] writes: [snipped fscking ML bullshit] > database,sql,query,table > > > David Otton writes: > > > Users that belong to some lists, but not the one I'm interested in : > > this is the one that I'm stuck on. Any thoughts? Suggestions? > > SELECT DISTINCT userid FROM userlist

InnoDB tables : difficulties with COUNT(*), DELETE etc ...

2001-09-10 Thread BAUMEISTER Alexandre
Bonjour, I have a table created with : CREATE TABLE mybuffer_NAS_D ( id int(10) unsigned NOT NULL auto_increment, service varchar(10) NOT NULL default '', date datetime NOT NULL default '-00-00 00:00:00', data text, PRIMARY KEY (id), KEY id_date (date) ) TYPE=InnoDB; Ther

Full text search algorithm

2001-09-10 Thread dsuna
Where can I find a description of the algorithm that mysql uses for weighting results from a full text search? Is there a way to provide some user specified criteria to alter the weighting? (i.e. a callback mechanism) Is there a way to get back the weights assigned to each row returned? Is t

RE: Select where A is not a member of B

2001-09-10 Thread Johnson, Gregert
SELECT DISTINCT u.userid, IF( ul.listid, "true", "false") FROM user u LEFT OUTER JOIN userlist ul ON u.userid = ul.userid AND ul.listid = ; -Original Message- From: David Otton [mailto:[EMAIL PROTECTED]]

Select where A is not a member of B

2001-09-10 Thread David Otton
Hi - I've got an annoying problem here, I've checked books, web, archives, etc, but can't find anything suitable so far. I have 2 data tables (ignoring the other columns, not important) : ++ | user | ++ | userid | ++ ++ | list | ++ | listid | +---

Stored procedures (2)

2001-09-10 Thread Claudio Cicali
I've got a tour on the web, searching for info and ideas, regarding the subject to implement some sort of stored procedure in mysql (remember "Lets approach stored procedure" thread ?) This was what I discovered - The Perl "stored procedures" (myperl project) in not a good idea at all, but, e

show columns

2001-09-10 Thread Steve Doig
Hi Folks - simple Q from a newbie, I'd like to return only the column names using something like show columns. I'm using PHP to display db tables in html, with the headers of the html table url'ed to sort the result by field. It's easy when you hard-code the column names into the page, but I'm g

Re: REMOVE NOW THIS IS THE SECOND TIME

2001-09-10 Thread portasio
;-) and can't read either ;) c'mon guys... lets keep the ethnic humour down... i'm sure it does not do any good to business, although it sure, well, tingles sometimes... we all have our natures, cultures, surroundings, and, understanding and respecting, clears boundaries and improve

Small Java Problem and msg to MySql Admin

2001-09-10 Thread ryan
Hiya everybody, I need the advise of a person who knows java servlet programming, All I need to do is call servlet a's doGet method from servlet b. Any ideas/code suggestions most welcome. Please send me your mail to [EMAIL PROTECTED] as I am having trouble getting into the list. Thanks in advan

Small Java Problem and msg to MySql Admin

2001-09-10 Thread ryan
Hiya everybody, I need the advise of a person who knows java servlet programming, All I need to do is call servlet a's doGet method from servlet b. Any ideas/code suggestions most welcome. Please send me your mail to [EMAIL PROTECTED] as I am having trouble getting into the list. Thanks in advan

Small Java Problem and msg to MySql Admin

2001-09-10 Thread ryan
Hiya everybody, I need the advise of a person who knows java servlet programming, All I need to do is call servlet a's doGet method from servlet b. Any ideas/code suggestions most welcome. Please send me your mail to [EMAIL PROTECTED] as I am having trouble getting into the list. Thanks in advan

Small Java Problem and msg to MySql Admin

2001-09-10 Thread ryan
Hiya everybody, I need the advise of a person who knows java servlet programming, All I need to do is call servlet a's doGet method from servlet b. Any ideas/code suggestions most welcome. Please send me your mail to [EMAIL PROTECTED] as I am having trouble getting into the list. Thanks in advan

Small Java Problem and msg to MySql Admin

2001-09-10 Thread ryan
Hiya everybody, I need the advise of a person who knows java servlet programming, All I need to do is call servlet a's doGet method from servlet b. Any ideas/code suggestions most welcome. Please send me your mail to [EMAIL PROTECTED] as I am having trouble getting into the list. Thanks in advan

I´m totally lost on this.......

2001-09-10 Thread Johan Way
Okej I have a site rank script. When users add the site I want the id number from mysql to bee shown in the next window. How do I call the id number? Should it be something like this?: $id PLEASE HELP ME.. iiiIIii Best regeards / Johan Way

Notice about seconds overroll - S7K bug

2001-09-10 Thread Tonu Samuel
(This is third attempt to post. always failed in some reason) I would like to make your attention on bug which was introduced tonight and can affect some people who are using (var)char field to store timestamp data. It is not worst security bug. It affects only people who already had bug in thei

Re: REMOVE NOW THIS IS THE SECOND TIME

2001-09-10 Thread Tonu Samuel
On 09 Sep 2001 21:24:51 +, Mourad de Riche wrote: > > Is he drunk or something? Report to a federal law? No, he is from United States. According to Sklyarov case they think that world consists only from them and everyone should follow their rules, even when not being U.S citizen nor loca

Column definition: The EXTRA column

2001-09-10 Thread Ralof
I am trying to use the EXTRA column that exist in mySQL ( DEFAULT EXTRA FIELD KEY NULL PRIVILEGES TYPE), but I do not understand how to put a value into it, I can get the value with SHOW COLUMNS,

Re: InnoDB problems

2001-09-10 Thread Nuno Dias
On Mon, Sep 10, 2001 at 02:28:05PM +0300, Heikki Tuuri wrote: > Nuno, > > I noticed a similar unexplained restriction > on our Linux 2.4. We have 512 MB physical memory, > no swap partition, and for some reason I cannot > malloc more than 256 MB. The Unix errno just says > 'Cannot allocate memory

Login with password fails with jdbc

2001-09-10 Thread attilio mattiocco
Hi everybody, I'm trying to connect to a mySQL database on the localhost through a jdbc (mm.mysql.jdbc-1.2b I downloaded it from mySQL home page) driver, but I cannot establish the connection for users that need a password. The java code I use is approximately the following: private String

Re: InnoDB problems

2001-09-10 Thread Heikki Tuuri
Nuno, I noticed a similar unexplained restriction on our Linux 2.4. We have 512 MB physical memory, no swap partition, and for some reason I cannot malloc more than 256 MB. The Unix errno just says 'Cannot allocate memory'. On our other machine with 900 MB RAM and 512 MB swap I can malloc 900 MB

Re: Fulltext search

2001-09-10 Thread alec . cawley
> The Fulltext search only matches those rows who match > teh exact word, so if I search for "bank", the query wont find banking. > (this would work with "like '%bank%'", but that is much slower). So is there > anything you can to make it also match those ?? MySQL V3 cannot do what you want. MS

Problem with the Installation of MySql 3.23 on Linux 7.1

2001-09-10 Thread support
hai , We are tryin to get the MySql running on a Intel based Linux box, with microkernel 2.2.16. when i try to install using the MySql using the RPM, it threw a message stating tht the installation is finished and the "mysqladmin" is not copied. when we try to uninstall the same, i get a mess

  1   2   >