Re: Why I can't run Mysql program ? Please Help !

Dear Philip and all, # pwd /usr/local/mysql-3.23.46-sun-solaris2.8-sparc # # grep 3306 /etc/services # # ps -ef | grep mysql root 292 1 0 Dec 24 ?0:00 /bin/sh ./bin/safe_mysqld --datadir=/usr/local/mysql/data --pid-file=/usr/local mysql 316 292 0 Dec 24 ?0:0

Re: Why I can't run Mysql program ? Please Help !

Dear Marek and all, I find out 3306 is listening show as below : # netstat -an *.3306 *.*0 0 24576 0 LISTEN # pwd /usr/local/mysql-3.23.46-sun-solaris2.8-sparc # ./bin/mysql -h sune250 ERROR 2005: Unknown MySQL Server Host 'sune250' (2) Do you know wha

RE: Case sensitive in selecting records

> Hi, > > I have a situation as follows: > > There is a table that stores the user name. > One user name is 'David' and another is 'david' > I want to select only the user with the name > 'david'(all small and not 'David') > > MySQL is case insensitive in selecting records... > how to make it c

Re: Why I can't run Mysql program ? Please Help !

Dear Marek, After I type the following command (./bin/mysqladmin -h 192.10.0.113) it show as below: # ./bin/mysqladmin -h 192.10.0.113 ./bin/mysqladmin Ver 8.23 Distrib 3.23.46, for sun-solaris2.8 on sparc Copyright (C) 2000 MySQL AB & MySQL Finland AB & TCX DataKonsult AB This software comes w

references failed

mysql> create table test1 ( -> a varchar(10) not null, -> b varchar(10), -> constraint pk_test1 primary key(a)); Query OK, 0 rows affected (0.02 sec) mysql> create table test2 ( -> c varchar(10) references test1(a), -> d varchar(10)); Query OK, 0 rows affected (0.02

WG: Why I will stay with Microsoft SQL Server

> Hi All, > > well, since the discussion of the benefits Mysql vs. MSSQL has i've come > across a real Problem. Even if its a little bit off-topic (but only a little > bit...) - perhaps s.b. knows a solution: > > Ok, here we are: > > I'm the webmaster of www.whiskyworld.de - an online Store that

Re: Is this possible with MySQL?

> > I would emagine that only one 'left join' takes less processing power? > > Yes, but I don't think there is very much extra processing time involved > using one more join in most cases, as long as the join is indexed and the > index blocks involved are cached, or if the amount of data is reaso

Error 2003: Can't connect to MySQL server on 'hostname' (110)

Hi, I've been trying to connect remotely to a MySQL server all night on a Linux machine, to no avail. I'm on a Linux client trying to access MySQL on both an NT Server and a Linux server. So far I've been able to connect to the NT server database without a hitch, however every time I tr

MySQL Latin2 charset on FreeBSD

Hi, everyone! I've installed FreeBSD 4.4-stable and MySQL-3.23.46, all with Latin 2 support for Slovenia (or Croatia, it's the same). The problem is not all of local character show correctly in mysql. The collation sequence works OK, I see all the characters correctly in Windows GUI. When I try t

myisamchk vs mysqlcheck

Hi everyone I am using 3.23.39 and newer on Linux and do: me> mysqladmin flush-tables me> myisamchk --keys-used=0 -rq /path/to/db/tbl_name before inserting lots of data (15 mio rows) with LOAD DATA INFILE and then re-create the indexes with me> myisamchk -r -q /path/to/db/tbl_name as suggest

Re: myisamchk vs mysqlcheck

Hi! On Dec 27, Thomas Spahni wrote: > Hi everyone > > I am using 3.23.39 and newer on Linux and do: > > me> mysqladmin flush-tables > me> myisamchk --keys-used=0 -rq /path/to/db/tbl_name > > before inserting lots of data (15 mio rows) with LOAD DATA INFILE > > and then re-create the indexes w

host not allowed to connect ? where is this config ?

I have a server called jordan, that is running mysql under linux. I have a laptop called jaguar which I am trying to launch the mysql gui on to connet to jordan. I have configured jaguar to connect to jordan, when I click connect it asks me for a password - I have not set the password yet so sho

jdbc

Hi, I am using mmmysql drivers. I placed it in tomcat lib directory and even placed the compete path in classpath. Still it says. it cannot find the drivers. Can any please help. Thank you. Hari Yellina www.yellina.com Victoria Australia --

Re: Re: host not allowed to connect ? where is this config ?

--- [EMAIL PROTECTED] wrote: > Your message cannot be posted because it appears to > be either spam or > simply off topic to our filter. To bypass the filter > you must include > one of the following words in your message: > > database,sql,query,table > > If you just reply to this message, and

Re: How to make use of mysql++ with gcc 2.96

Trond Eivind Glomsrød writes: > > > > Yes, install gcc 2.95.2 or 3.0.3 > > That is very much _NOT_ recommended. Both have serious issues, none > are compatible with the other libraries installed. > > -- > Trond Eivind Glomsrød > Red Hat, Inc. > MySQL++ works fine with any 2.95.* or 3.0.* On

Re: jdbc

place it in webapps/[context]/web-inf/lib/ At 11:01 PM 27/12/2001 +1100, Hari Yellina wrote: >Hi, > >I am using mmmysql drivers. I placed it in tomcat lib directory and even >placed the compete path in classpath. Still it says. it cannot find the >drivers. > >Can any please help. > >Thank you. >

./configure of mysql-3.23.46 fails with gcc-3.0.3

SORRY IF YOU DON'T RECEIVE THIS BUG REPORT IN THE FORMAT YOU ARE EXPECTING BUT I'VE BEEN TRYING TO USE scripts/mysqlbug 2 TIMES WITHOUT SUCCESS (every time I quit Emacs, the mysqlbug script complains something is wrong in the way I've filled the form and when I press 'e' to edit again, nothing app

Re: ./configure of mysql-3.23.46 fails with gcc-3.0.3

Hervé Pagès writes: > SORRY IF YOU DON'T RECEIVE THIS BUG REPORT IN THE FORMAT YOU ARE EXPECTING > BUT I'VE BEEN TRYING TO USE scripts/mysqlbug 2 TIMES WITHOUT SUCCESS > (every time I quit Emacs, the mysqlbug script complains something is wrong > in the way I've filled the form and when I press 'e

2 Server in different locations...

> Hi All, > > well, since the discussion of the benefits Mysql vs. MSSQL has i've come > across a real Problem. Even if its a little bit off-topic (but only a little > bit...) - perhaps s.b. knows a solution: > > Ok, here we are: > > I'm the webmaster of www.whiskyworld.de - an online Store that s

RE: Is this possible with MySQL?

* Stig Nørgaard Jepsen > > Do you need to read _all_ textkeys for each page? How many different > > textkeys do you have in the table? > > No I don't have to read all the textkeys at once. They are > usually selected via a join from another table. And sometimes I > will read a set of rows via a se

delayed inserts never inserting

I'm having a problem with delayed inserts. After heavy use, we seem to have about 20-30 lingering delayed inserts that never complete. A mysqladmin processlist shows that the only thing going are delayed inserts (Wait on cond..) and nothing is locked. However the time on the delayed inserts c

Hang up when loading a LOT of data

Hi! I'm having a strange problem. I use MySQL just to serve two hundred small tables. They are very static, I update them once a week. And small, about 40Mb of total disk space used. A few people use this tables, always with MyODC from Access from a Windows platform. Two weeks ago I needed to

Are there any openly-accessible MySQL server [I can use for testing]?

I am writing a conversion tool for MySQL and I could do with some "real data" to use to test it with. I am wondering are their any MySQL servers out their accessible via the internet which I can use to test this program? All I need is the IP address a un/pass if no generic ones exist and I onl

To Mr Bob Hall (and everybody else who wants to read it)

Thank You Mr Hall: It's clear to me now that I cannot give to MySQL an MS Access object as MySQL will not read the data in it. It is really not too bad indeed as I can leave almost all the queries in the "MS Access language" without translating them into "Pass-through Queries". In this way, I thi

RE: Why I will stay with Microsoft SQL Server

Perhaps, reconsider you're layout. Even with mssql, you are not talking about an easy or cheap situation (you would need to get the advanced version of mssql I believe, which is mucho dinero x 2). Why can't both computers be at the same location (and even run off the same machine, leaving the ot

RE: MyISAM/InnoDB/Oracle comparison, and a InnoDB table locking question

Thanks for the reply, Heikki. That the MyISAM would fit in OS file cache didn't occur to me. That would certainly help explain the big discrepancy. And yes, we had autocommit turned on for InnoDB, not for Oracle. The InnoDB buffer pool size was 350mb, not big enough to hold the whole table. The O

Best Delphi VCL to Access MySql.

Wich VCL is the best to access MySql I used Interbase for long time and I think to switch to MySql ofr My Delphi Application. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysq

maximum heap table size

Hello, Can anyone tell me if the maximum table sizes given in Section 1.2.4 of the documentation also apply to HEAP tables in v. 4.0? Or, rather, if memory and address space were unlimited, how large could a heap table possibly be in v. 4.0? TIA Tim Banach State Street Corporation Westwood, MA

permisions problem, need to understand what is going wrong to get ontop of this.

-Original Message- From: Matthew Darcy [mailto:[EMAIL PROTECTED]] Sent: 27 December 2001 14:08 To: Count Schemula Subject: RE: Re: host not allowed to connect ? more problems Hi, I have re-read and think I understand a little better (think being the correct word) I have decided to se

Optimizing mySQL for volume

We are trying to optimize mySQL. Right now, the max_connections is set to 100. We are only able to open 99 concurrent connections to the db, and even then, some requests are unable to get a connection. We'd like to be able to scale that up, but mySQL doesn't like what we've done, as it won't st

Re: How to make use of mysql++ with gcc 2.96

Hi! > "Sinisa" == Sinisa Milivojevic <[EMAIL PROTECTED]> writes: Sinisa> Fournier Jocelyn [Presence-PC] writes: >> Hi, >> >> I have a question about gcc 3.0.3 : since I have installed it, it refuses to >> compile because it detect c++ as a crosscompiler : >> >> checking whether the C++ co

Re: Are there any openly-accessible MySQL server [I can use for testing]?

Feel free to put data on my server. (almost a year, and I'm still here! :))) Regards, Gary "SuperID" Huntress === FreeSQL.org offering free database hosting to developers Visit http://www.freesql.org - Original Message - From: "David

InnoDB in MySQL-4.0.1

Hi! InnoDB is a table type which provides transactions, row level locking, and foreign key constraints to MySQL. InnoDB is included in all versions of MySQL-4.0 and in MySQL-Max-3.23. The InnoDB version in the 4.0 series is identical to the version in the stable MySQL-Max-3.23 series. Therefore

Re: Are there any openly-accessible MySQL server [I can use for testing]?

Umm, why not just install a copy locally? You can get a binary for just about any OS. And a local copy would be much faster than working over the internet. j- k- On Thursday 27 December 2001 06:31, David Ayliffe wrote: > I am writing a conversion tool for MySQL and I could do with so

Re: Optimizing mySQL for volume

On Thu, Dec 27, 2001 at 10:38:42AM -0600, Kim Albee wrote: > We are trying to optimize mySQL. Right now, the max_connections is set to > 100. We are only able to open 99 concurrent connections to the db, and even > then, some requests are unable to get a connection. We'd like to be able to > sc

Re: Optimizing mySQL for volume

You need to set the max_connections variable like this in the my.cnf file: set-variable = max_connections=250 -- Jason On Thu, 2001-12-27 at 11:38, Kim Albee wrote: > We are trying to optimize mySQL. Right now, the max_connections is set to > 100. We are only able to open 99 concurrent co

Re: Why I will stay with Microsoft SQL Server

Regarding this situation, is it possible to setup a replication on the same table between two servers, two way? as in i modify server a and server b replicates the table change i then modify server b and server a replicates the table change of course you would have to start out with two identical

Re: Best Delphi VCL to Access MySql.

I have two favourites: http://www.scibit.com http://www.microolap.com/index.htm > Wich VCL is the best to access MySql > I used Interbase for long time and I think to switch to MySql ofr My > Delphi Application. Richard Czerwonka, Partner, FYI Sy

RE: Are there any openly-accessible MySQL server [I can use for testing]?

I have done that (server on localhost) but the problem is I am using data I have made. I want to use some REAL data. -Original Message- From: Joshua J. Kugler [mailto:[EMAIL PROTECTED]] Sent: 27 December 2001 16:59 To: MySQL Subject: Re: Are there any openly-accessible MySQL server [I c

Re: Best Delphi VCL to Access MySql.

Zeos Lib is an open source TDataset descendant... http://zeoslib.org/ dfag wrote: > Wich VCL is the best to access MySql > I used Interbase for long time and I think to switch to MySql ofr My Delphi > Application. > > - > Befor

mysql bind variables in php

Does anyone know if it’s possible to use any kind of bind variables to make the queries run faster. In perl I use; $sth=$dbh->prepare(”select * from table where name = ?”); $sth->execute(”Henrik”); Can I do it in PHP? Thanks / Henrik -

A newbie question

I'm new to MySQL as they laid off the dev who setup our intranet and I need to allow access priveleges to an internal testing server to connect to the remote host that the live site is on. I've read the doc on setting up priveleges at http://www.mysql.com/doc/P/r/Privileges.html but as I am so n

RE: permisions problem, need to understand what is going wrong to get ontop of this.

> Hi, > > I have re-read and think I understand a little better (think being the > correct word) > > I have decided to set the root password - and then add some users. > > first of all I tried > > ./mysqladmin -u root password $thenewpassword > > this gave me > > ./mysqladmin: connect to server at

RE: To Mr Bob Hall (and everybody else who wants to read it)

> In the end: > > 1) "Pass-through Queries" don't give me any problem with stupid > PopUp forms >asking for confirm, but can not be used if I must refer to a MS Access >Object in the sintax of the query. > > > 2) the "Action Queries" can read MS Access objects but need to be > confi

Left join?

I guess I'm just old fashion. I learned with the terms inner and outer joins, and I conceptually in struggling with this left/right join stuff -- I thought the order it joins the tables was simply a matter of optimizer logic. Can someone give me a rule of thumb in understanding what this left/r

Re: Why I will stay with Microsoft SQL Server

Hi, > Regarding this situation, is it possible to setup a replication on > the same table between two servers, two way? > as in > i modify server a and server b replicates the table change > i then modify server b and server a replicates the table change If you're talking about 2 different table

AW: Why I will stay with Microsoft SQL Server

Hi, ok, when im right now it would work with replication if I use different tables ? -> thats already done so, we have 3 Tables where new orders are stored (and costumerdates etc...) - and 12 tavles where products are in - but how could I connect them ? IN MySQL's replication FAQ and Manual its o

Re: Why I will stay with Microsoft SQL Server

Hi, > we have 3 Tables where new orders are stored (and costumerdates > etc...) - and 12 tavles where products are in - but how could I > connect them ? IN MySQL's replication FAQ and Manual its > only talking about whole servers you can look at the MySQL documentation regarding replication,

Re: WG: Why I will stay with Microsoft SQL Server

On Thu, 27 Dec 2001 11:08:26 +0100, "whiskyworld.de" <[EMAIL PROTECTED]> wrote: | > Hi All, | > | > well, since the discussion of the benefits Mysql vs. MSSQL has i've come | > across a real Problem. Even if its a little bit off-topic (but only a | little | > bit...) - perhaps s.b. knows a solutio

mysql@lists.mysql.com

>Description: precise description of the problem (multiple lines) >How-To-Repeat: >Fix: >Submitter-Id: >Originator:root >Organization: >MySQL support: [none | licence | email support | extended email support ] >Synopsis: >Severity: >Priority: >C

Normalization advice needed

I've got a 3500 record database cataloging an art collection. The data was originally assembled (by others) in Access. I've imported it into MySQL to make it available on the artist's web site: . The data was formatted in Access as one big table. About 800 of the

MS Access to MySQL convert

I am new to MySQL and am trying to convert : SELECT SUM(DistKm) AS Distance FROM (SELECT TOP 5 DistKm FROM XCLeague WHERE LoginID='billyreed' AND HGPG='PG' ORDER BY DistKm DESC) This is a subselect which selects the top 5 cross country flight distances of hang glider pilots (for a specific pilot

Re: MS Access to MySQL convert

On Thursday 27 Dec 2001 23:31, Billy Reed wrote: > I am new to MySQL and am trying to convert : > > SELECT SUM(DistKm) AS Distance FROM (SELECT TOP 5 DistKm FROM XCLeague > WHERE LoginID='billyreed' AND HGPG='PG' ORDER BY DistKm DESC) > > Can anyone suggest how this is done in MySQL. It doesnt see

Row Statistics?

Is there a way I can track how often which rows are being returned in select queries? I'm trying to determine, on an hourly, daily, weekly interval, which rows get hit the most, the least, and how many times. For the application I'm running, I'd like to use this metric to purge old records. It

Re: FW: Replication reset

Sasha, thanks for your help! But I'm not sure we're in agreement about what is happening yet: Sasha Pachev wrote: > On Wednesday 26 December 2001 01:24 pm, Venu wrote: > >>Since replication is only one-way, there really shouldn't be any updates >>happening on the slave, but in the failover ca

Re: MS Access to MySQL convert

Instead of TOP 5 DistKm FROM SCLeague you can probably use DistKm SORTED BY DistKm DESCENDING LIMIT 5 The rest about temp files is probably best to read Goran Bobic's mail. Billy Reed wrote: > I am new to MySQL and am trying to convert : > > SELECT SUM(DistKm) AS Distance FROM (SELECT TOP 5

Re: Left join?

On Thu, Dec 27, 2001 at 01:21:08PM -0700, Ken Kinder wrote: > I guess I'm just old fashion. I learned with the terms inner and outer joins, > and I conceptually in struggling with this left/right join stuff -- I thought > the order it joins the tables was simply a matter of optimizer logic. Tha

Re: To Mr Bob Hall (and everybody else who wants to read it)

On Thu, Dec 27, 2001 at 08:43:30PM +0100, Carsten H. Pedersen wrote: > > > > In the end: > > > > 1) "Pass-through Queries" don't give me any problem with stupid > > PopUp forms > >asking for confirm, but can not be used if I must refer to a MS Access > >Object in the sintax of the quer

problem with BDB tables

Hi, Just wondering if anyone has received the following error code before on a BDB table : ERROR 1030: Got error -30991 from table handler I have a BDB table consisting of 4 varchar and 2 unsigned bigint columns with about 30K+ rows. This table is replicated to a slave. Both m

[MySQL does not run, mysql.sock is 0 byte]

>Description: I just intalled MySQL on my linux 7.2 system. However, it doesn't run. Here is what I did: 1. I did a partionless installation to upgrade RedHat 6.2 to 7.2 2. from the CD, I ran rpm for 4 packages: mysql-3.23.41-1.i386.rpm mysql-devel-3.23.41-1.i386.rpm mysql-server-3.23.41-

Re: mysql bug

Hello. On Wed, Dec 19, 2001 at 05:13:02AM -0800, [EMAIL PROTECTED] wrote: > Dear Sir/Madam > I downloaded mysql3.23max version actaually i want to > use Innodb type for my tables in the properties its > showing Innodb is disabled to enable that i ve to give > some path in 'my.cnf' file according

getting permission denied error intermittently

Hi all, Both of the DBI client and C client are getting permission denied error intermittently to a mysql database. When I see this problem, I do a 'flush privileges'. It comes back to normal for a random period of time and the problem happens again. I cannot reproduce this problem at will. Anyon

Re: InnoDB in MySQL-4.0.1

Hi Keikki, I would like to know if row level privileges can be set in mysql. Eg:- In user table, the user shall be allowed to edit only his record. In a table for task report, only assignee of the task shall be allowed to edit the specific record. -- Prabhu On Thu, 27 Dec 2001,

Re: Normalization advice needed

On Thu, Dec 27, 2001 at 04:01:57PM -0600, Gawain wrote: > I've got a 3500 record database cataloging an art collection. The > data was originally assembled (by others) in Access. I've imported it > into MySQL to make it available on the artist's web site: > . > >

Re: mysqldump --tab crashes when dumping DB with many tables

Hi. On Wed, Dec 19, 2001 at 05:03:25PM -0700, [EMAIL PROTECTED] wrote: > >Description: > This problem pertains to the Sun Solaris distributions, I have > not tried others. Description follows: > mysqldump --tab runs up against user resource limits on the > number of open f

Re: MySQL + php + Red Hat Linux 6.2

Hi. On Thu, Dec 20, 2001 at 04:01:03PM +0800, [EMAIL PROTECTED] wrote: > Hello, > > My System is Red Hat 6.2 and need to run with php4 and imp ( > www.horde.org/imp )... > I found the MySQL packages ( RPM ) at www.mysql.com > > MySQL 3.23.46 Server (i386) (6M) > MySQL 3.23.46 Benchmark/test sui

Re: 4.0.1 bug reports. Has it been released yet?

Hi. On Thu, Dec 20, 2001 at 09:19:00AM +, [EMAIL PROTECTED] wrote: > I've seen various bug reports for mysql 4.0.1 but no sign of it on the > site. Has it been released yet? I think the 'IN BOOLEAN MODE' modifier > for a fulltext search may solve all my problems. 4.0.1 is not released yet. A

Re: 4.0.1 bug reports. Has it been released yet?

In the last episode (Dec 28), Benjamin Pflugmann said: > On Thu, Dec 20, 2001 at 09:19:00AM +, [EMAIL PROTECTED] wrote: > > I've seen various bug reports for mysql 4.0.1 but no sign of it on > > the site. Has it been released yet? I think the 'IN BOOLEAN MODE' > > modifier for a fulltext searc

Re: [BUG] 'ENOTCONN' replication dies every once in a while

On Sat, Dec 22, 2001 at 02:00:00PM +0100, bert hubert wrote: > I can't easily replicate this as it happens only once every few weeks. We > are very happy with MySQL otherwise! It is wonderful as a nameserver > database backend. One additional datapoint is that we are using a self-compiled version

Recordset

Hi, I am connecting MySQL in Linux server through Visual Basic in windows. When i used the recordset to select a record, the RecordCount method returns -1 even there is record in the table. following is the connection string i used "Provider=MSDASQL.1;Persist Security Info=False;Data Source=MML