build problems

2002-03-06 Thread Paul Warren
I have Redhat 7.2 - clean install When I try to compile my own mysql 49a version, I get a hostname error and it said it can't use the resolveIP function. It also says it might be that mysql isn't 100% compatible with the libc (or glibc) version I have. I also saw on the www.mysql.com homepage

Re: Why v3.23.49 does not build on RedHat 6.2 ?????

2002-03-06 Thread Ireneusz Piasecki
Hi. I have following rpm packages from redhat.com: glibc-2.2.2-10.i386.rpm glibc-2.2.2-10.i686.rpm compat-glibc-6.2-2.1.3.2.i386.rpm glibc-common-2.2.2-10.i386.rpm glibc-devel-2.2.2-10.i386.rpm I get this packet to upgrade my glibc 2.1 running on my RH 6.2 system, but it fails. Do i have missed

Re: Default record order...

2002-03-06 Thread DL Neil
Richard, Thanks. Interestingly enough, pulling records without a sort was rather random (rather, influence by the last sort) - but once I placed a primary key on the table, the order of unsorted records is always constant, even after a sort (based on numerous tests yesterday and today with

Re: how can I use 'C' programs accessing a MySql

2002-03-06 Thread Thomas Spahni
On Tue, 5 Mar 2002 [EMAIL PROTECTED] wrote: I'm trying to understand how can I use 'C' programs accessing a MySql DataBase, please, could you send me a small program or so that creates a Table or two and make some changes on them. I read so many examples but all of them only contain parts

in libmysql bad coding causes crash of program

2002-03-06 Thread kovis
Description: in file libmysql.c, function mysql_read_default_options, which is executed at every start of any mySQL client is a string conversion subroutine, which causes stack overflow Line 715 for (end = *option ; (end = strcend(end,'_')); ) *end= '-'; BUT! strcend

RE: Cannot import mysql dump

2002-03-06 Thread Martin MOKREJ
On Mon, 28 Jan 2002, Sinisa Milivojevic wrote: =?iso-8859-2?Q?Martin MOKREJ=A9?= writes: On Mon, 28 Jan 2002, Sinisa Milivojevic wrote: Hi, I am retrying to an answer to my question from January. Could please someone from the developers have a look into this?

Re: Question

2002-03-06 Thread xperiment studios - Paul Erickson
on 6/3/02 9:41 PM, [EMAIL PROTECTED] at [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: sql,query If you just reply to this

Re: mysql on Linux

2002-03-06 Thread Intrex
I know in at least 2 e-mails I did indeed mention that I executed safe_mysqld -u root, So I did it using your syntax, safe_mysqld --user=root, I had the same text returned which again said the following. Starting mysqld daemon with databases from /var/lib/mysql 020305 17:46:10 mysqld ended I

index not hit?

2002-03-06 Thread Stephan Bulheller
Hello, We are running a mysql database version 3.22.32. I have an simple table: id, int(10) unsigned, PRI, default 0, auto_increment usernummer, int(10) unsigned, default 0 productcode, char(10), default '' monat, tinyint(3) unsigned, default 0 jahr, mediumint(8) unsigned, MUL, 0 and two

Feature idea inspired by bug report

2002-03-06 Thread Michael Widenius
Hi! Sasha == Sasha Pachev [EMAIL PROTECTED] writes: Sasha On Monday 04 March 2002 02:41 pm, Vladimir V. Kolpakov wrote: -- P.S. so far, it's helpful bug: I use it as catch for poor queries!:) Sasha This actually gives me an idea for a feature. --disable-disk-temp-tables - Sasha fail

multiple servers

2002-03-06 Thread Marek Wysmulek
Dear group. (Debian 2.4.19, MySQL 3.23.49) I have problem with starting multiple servers on one machine. According documentation it is enough to start each another then first server using ex.: safe_mysqld --socket=/..path../mysql.socket.x --port=numberx and so on. And this is enough when the

Question concerning UPDATE command

2002-03-06 Thread Stuart Chalk
I'm relatively new to MySQL but think I am getting a grip on it. However, I am seeing some strange behavior when I perform an update command (through PHP). This following query not only results in the sessionLastTime column updated but also another column sessionStartTime (key, auto_increment).

Re: Why v3.23.49 does not build on RedHat 6.2 ?????

2002-03-06 Thread Ireneusz Piasecki
Do you mean: You can forget upgrading on RH6.2 the glibc 2.1 to 2.2. Maybe one did it succesful, so now he has RH.6.2 with glibc 2.2. I still waiting for these persons. P.S: I don't understand word: cos. Is it: Computer Operating System ? regards. - Original Message - From: Ben Edwards

TIMESTAMP not acting as I'd like

2002-03-06 Thread [EMAIL PROTECTED]
Hi, small problem. I have a table set up like so. It has a number of entries that were added on a certain date, I use TIMESTAMP to keep track of the date. +-+---+--+-+-+-- --+ | Field | Type | Null | Key |

Re: TIMESTAMP not acting as I'd like

2002-03-06 Thread James Housley
[EMAIL PROTECTED] wrote: Hi, small problem. I have a table set up like so. It has a number of entries that were added on a certain date, I use TIMESTAMP to keep track of the date. +-+---+--+-+-+-- --+ | Field |

Trouble with BOOLEAN fulltext search

2002-03-06 Thread Thomas Spahni
Dear listmembers My problems are: jokers appear not to work as expected in boolean fulltext search and I can't figure out how to order results according to any relevance. I need someone to point me into the right direction. I run MySQL 4.0.1: mysqladmin version mysqladmin Ver 8.23 Distrib

Deleting a Record

2002-03-06 Thread Chuck \PUP\ Payne
Hi, I a seting up a php page that will let me delete a record from my mysql database, but I want it be able to match to fields before it will let a user delete that record. I know the basic sql command is DELETE FROM $table WHERE field 1 = $value But I don't know how to write the state for

ANN: EMS MySQL Manager 1.65 released

2002-03-06 Thread Igor Brynskich
Dear Sirs and Madams, EMS HiTech company is announcing the next version (1.65) of MySQL Manager -- A Powerful MySQL Administration and Development Tool for Windows95/98/ME/NT/2000/XP. You can download the latest version from http://www.mysqlmanager.com/download.phtml What's new in version

source install problem - solaris2.6

2002-03-06 Thread Salada, Duncan
Hello all, I am having some problems with installing 3.23.49 from source. Below is the output from mysqlbug with my additions to help explain the problem. Any help would be great - my experience with this kind of stuff is not that great. Description: I am trying to upgrade from

Re: TIMESTAMP not acting as I'd like

2002-03-06 Thread Douglas Forrest
Maybe not. MySQL won't auto-maintain a date field. I can't count the number of times that some unanticipated issue was solved through having separate modifydate and createdate fields, with the modifydate being maintained by MySQL (which means that I don't have to worry about it going out of

Re: Trouble with BOOLEAN fulltext search

2002-03-06 Thread Sergei Golubchik
Hi! On Mar 06, Thomas Spahni wrote: Dear listmembers My problems are: jokers appear not to work as expected in boolean fulltext search and I can't figure out how to order results according to any relevance. I need someone to point me into the right direction. According to the Very Fine

RE: source install problem - solaris2.6

2002-03-06 Thread Salada, Duncan
Please ignore my original message. I was finally able to get it to work using: CC=gcc CFLAGS=-O3 CXX=gcc CXXFLAGS=-O3 -felide-constructors -fno-exceptions -fno-rtti ./configure --prefix=/usr/local/mysql-3.23.49 --with-low-memory --enable-assembler Duncan -- Duncan Salada | Titan |

RE: MySQL Database Replication

2002-03-06 Thread Thi Cao
Yes, I did flush the privileges when nothing else worked but that didn't do the trick either. Thanks for trying. -Original Message- From: James Housley [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 05, 2002 6:00 PM To: Thi Cao Cc: MySQL Subject: Re: MySQL Database Replication Thi

RE: mysql on Linux

2002-03-06 Thread Luc Foisy
try running safe_mysqld without any options I wouldn't know why you would need to specify a user name to start the daemon -Original Message- From: Intrex [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 06, 2002 5:55 AM To: [EMAIL PROTECTED]; 'Mysql' Subject: Re: mysql on Linux I know

multiple servers (2)

2002-03-06 Thread Marek Wysmulek
Dear group. (Debian 2.4.19, MySQL 3.23.49) I have problem with starting multiple servers on one machine. According documentation it is enough to start each another then first server using ex.: safe_mysqld --socket=/..path../mysql.socket.x --port=numberx and so on. And this is enough when

CPU Usage

2002-03-06 Thread Isak Badenhorst
Hi I am running Mysql-3.23.38 on Slackware 8 with Kernel-2.4.17. This morning I suddenly had a problem where when I start Mysql server at startup it uses all cpu available and the machine freezes. To fix the problem I had to remove the complete installation and install mysql from scratch.

RE: MySQL Database Replication

2002-03-06 Thread Thi Cao
When I grant privileges as follows, the slave gets updated: GRANT FILE ON *.* to repl@'%' identified by 'some_password'; Could someone please tell me why I must grant the FILE privilege on all databases for the repl (slave) to be able to update one particular database? Thanks everyone. Thi

MySQL 3.23 Lost Connection

2002-03-06 Thread Egor Egorov
Adam, Tuesday, March 05, 2002, 10:14:28 PM, you wrote: A I have compiled/rebuilt the MySQL 3.23.49 Source RPM under kernel A 2.4.17, and glibc 2.1. A Using gcc version 2.95.4 20010319 (prerelease). I had 2.96 on there and A headed the warnings and downgraded to 2.95. A Randomly I get the Lost

Dual Languages??

2002-03-06 Thread Victoria Reznichenko
bipin, Wednesday, March 06, 2002, 9:56:53 AM, you wrote: bvc I have a requirement of storing and retrieving data in 2 languages - namely English and Arabic. bvc From what I have been able to understand, that would require me to have 2 MySQL servers running simultaneously. bvc Can somebody

Which Linux version to download (all?)

2002-03-06 Thread Egor Egorov
Elissa, Wednesday, March 06, 2002, 6:44:26 AM, you wrote: E I'm a newie to SQL, and to Linux, so please forgive my blaring blunders... E I know I have an x86 Linux machine, running Redhat 7.2, and I know that I E like RPMs better than binary installations E When I get to the Stable

Loops in Mysql

2002-03-06 Thread Victoria Reznichenko
Amit, Wednesday, March 06, 2002, 6:38:30 AM, you wrote: AL What I want to do is import data from some other AL database to Mysql. For this the requirement is that, AL each record before being added to Mysql database, AL should pass through a loop say 5 times. This I want to AL do using only SQL.

index not hit?

2002-03-06 Thread Egor Egorov
Stephan, Wednesday, March 06, 2002, 1:24:37 PM, you wrote: SB We are running a mysql database version 3.22.32. SB I have an simple table: SB id, int(10) unsigned, PRI, default 0, auto_increment SB usernummer, int(10) unsigned, default 0 SB productcode, char(10), default '' SB monat, tinyint(3)

TIMESTAMP not acting as I'd like

2002-03-06 Thread Victoria Reznichenko
rob, Wednesday, March 06, 2002, 2:19:01 PM, you wrote: recu small problem. I have a table set up like so. It has a number of entries recu that were added on a certain date, I use TIMESTAMP to keep track of the date. recu

Re: Why v3.23.49 does not build on RedHat 6.2 ?????

2002-03-06 Thread Trond Eivind Glomsrød
*mysql, to please stupid filter* On Wed, 6 Mar 2002, Trond Eivind Glomsrød wrote: On Wed, 6 Mar 2002, Ireneusz Piasecki wrote: Hi. I have following rpm packages from redhat.com: glibc-2.2.2-10.i386.rpm glibc-2.2.2-10.i686.rpm compat-glibc-6.2-2.1.3.2.i386.rpm

RE: MySQL 3.23 Lost Connection

2002-03-06 Thread Adam
Yes thank you for these links. I have already read the documentation as the first thing I did. The second thing I did was recompile. The third thing I did was subscribe to the list. I can write a php script like this: ? $o=mysql_connect(localhost,root,xxx);

SQL coding: Finding singular when search with plural.

2002-03-06 Thread BadgerBay
Hello, This is a good question for when you are sipping coffee or tea and are inspired to write some code. I require additional functionality for my SQL search: MY CURRENT SEARCH SELECT ID, Authors, Year, Title FROM libraryTable WHERE (Authors LIKE '% + varAuthor + %') OR (Keywords LIKE '% +

Re: Which Linux version to download (all?)

2002-03-06 Thread Ireneusz Piasecki
Hi. Yopu wrote. You can find info about MySQL installation on Linux if you check the following links: http://www.mysql.com/doc/L/i/Linux-RPM.html http://www.mysql.com/doc/L/i/Linux.html The section: linux-rpm.html it seems to bee out of date: The MySQL RPMs are

Patch for compiling mysql++-1.7.9 with gcc-3.0.3

2002-03-06 Thread Erminio Efisio Riezzo
Hello folks, I do not succeed to install the patch in order to compile the mysql++-1.7.9 with the GCC-3.0.3. I use the command /usr/local/src/mysql++-1.7.9-patched# /usr/local/bin/patch -p0 -i mysql++-gcc-3.0.patch but the output is: can't find file to patch at input line 17 Perhaps you used

RE: Deleting a Record

2002-03-06 Thread Roger Baklund
* Chuck PUP Payne I know the basic sql command is DELETE FROM $table WHERE field 1 = $value But I don't know how to write the state for a second field. Can some one tell, but one field seem to give too much choose and would make it to easy to delete the wrong record. I think this is

Re: Which Linux version to download (all?)

2002-03-06 Thread Ireneusz Piasecki
sorry. I made mistake. Cite should be like this: The MySQL RPMs are currently being built on a RedHat Version 6.2 system but should work on other versions of Linux that support rpm and use glibc. - from http://www.mysql.com/doc/L/i/Linux-RPM.html I. Piasecki. - Original Message -

RE: SQL coding: Finding singular when search with plural.

2002-03-06 Thread Adam
I'm assuming your users arnt using a MySQL client directly to perform the queries... And your using middleware like PHP or something. So your PHP code can parse the users responses and then design your SQL queries around your parsed data. -Original Message- From: BadgerBay

Re: Why v3.23.49 does not build on RedHat 6.2 ?????

2002-03-06 Thread Trond Eivind Glomsrød
Ireneusz Piasecki [EMAIL PROTECTED] writes: Do you mean: You can forget upgrading on RH6.2 the glibc 2.1 to 2.2. Maybe one did it succesful, so now he has RH.6.2 with glibc 2.2. I still waiting for these persons. Don't do it. You will do bad things to your system. If you want to upgrade to a

libncurses.so.5 problem

2002-03-06 Thread Atif Faruqui
Hello, I feel i am dead in the water with this problem, it appears that libncurses.so.5 is a linux library, i downloaded mysql-3.23.45 from sunfreeware and did pkgadd on it on Soalris 8 Sparc box, i was able to start mysqld daemon and i can run mysqladmin commands but when i try to

Table Qualified Column Names

2002-03-06 Thread Dave Ford
Does mysql jdbc driver support table quailified column names? For example, this seems to work: select id from people But this doesn't: select people.id from people. Thanks. Dave Ford Smart Soft - The Developer Training Company http://www.smart-soft.com

Urgent can't create table

2002-03-06 Thread gaouzief
hi i get a strange can't create table 'databasename\bigdata1.frm' error 140 when i try to run the following create query: DROP TABLE /*!32200 IF EXISTS*/ bigdata1; CREATE TABLE /*!32300 IF NOT EXISTS*/ bigdata1 ( IDData bigint(20) unsigned NOT NULL auto_increment, REFLang char(2) NOT NULL

Re: Transact Sql

2002-03-06 Thread Christopher Thompson
On Tuesday 05 March 2002 10:15 pm, Amit Lonkar wrote: hi Does Mysql support Transat SQL??? Assuming you mean Transact SQL, no. 'Transact SQL' is Microsoft's name for their proprietary extensions to SQL. Only Microsoft SQL Server supports it. But then again, MS SQL doesn't support MySQL's

System Suggestions

2002-03-06 Thread Anthony W. Marino
Could someone, please, provide me with a link and/or facilitate some suggestons for configuration of the following components for a new DB server hosting MySQL 4.01MAX? I'm only looking to get a start and don't expect THE answer since all things are relative and I will have to further test

Configuration Problem

2002-03-06 Thread Prentice Autry
shell groupadd mysql shell useradd -g mysql mysql shell gunzip mysql-VERSION.tar.gz | tar -xvf - shell cd mysql-VERSION shell ./configure --prefix=/usr/local/mysql Receiving message: ./configure: not found Should this script be included in the unzipped directory. Or is it native to the

Re: libncurses.so.5 problem

2002-03-06 Thread Christopher Thompson
This is not a MySQL question, it's a Solaris question. :) But anyway, you need to get and install ncurses (version 5). You can find more information at: http://www.gnu.org/software/ncurses/ncurses.html On Wednesday 06 March 2002 8:57 am, Atif Faruqui wrote: Hello, I feel i am dead

synopsis of the problem (one line)

2002-03-06 Thread root
Description: How-To-Repeat: Fix: Submitter-Id: submitter ID Originator:root Organization: MySQL support: [none | licence | email support | extended email support ] Synopsis: Severity: Priority: Category: mysql Class: Release:

Urgent can't create table

2002-03-06 Thread Victoria Reznichenko
gaouzief, Wednesday, March 06, 2002, 6:28:01 PM, you wrote: g i get a strange can't create table 'databasename\bigdata1.frm' g error 140 when i try to run the following create query: g DROP TABLE /*!32200 IF EXISTS*/ bigdata1; g CREATE TABLE /*!32300 IF NOT EXISTS*/ bigdata1 ( g IDData

MySQL Availability

2002-03-06 Thread Anthony W. Marino
Where can I find most recent (ie; 4.0.2 builds ;Nightly/CVS) at? Thank You, Anthony sql - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/

Re: libncurses.so.5 problem

2002-03-06 Thread Dr. Michael Wittmann
hi, the ncurses library is available as a solaris binary package at sunfreeware, too. look for ncurses-5.2. Christopher Thompson wrote: This is not a MySQL question, it's a Solaris question. :) But anyway, you need to get and install ncurses (version 5). You can find more information

Re: Trouble with BOOLEAN fulltext search

2002-03-06 Thread Thomas Spahni
On Wed, 6 Mar 2002, Sergei Golubchik wrote: Hi! On Mar 06, Thomas Spahni wrote: My problems are: jokers appear not to work as expected in boolean fulltext search ... mysql SELECT doc FROM plaintext WHERE MATCH(bgetxt) AGAINST('placi*' IN BOOLEAN MODE); Empty set (0.00 sec)

Read previous record with C API

2002-03-06 Thread JOUANNET, Rodolphe
Can someone tell me how to find the previous record in C (with mySQL API function). I do a SELECT statement, read it with mysql_store_result(), read the first record with mysql_fetch_row(), the next record with mysql_fetch_row(), etc.. . But what about reading the previous record ? (sorry for my

ALTER TABLE Foreign key problems

2002-03-06 Thread IvanLatysh
Hi. I am using MySQL 3.23.44-max and InnoDB tables. I also using foreign key in my tables. I have problem, I couldn't alter my table and add any foreign keys. SQL like this: alter table data_entry add FOREIGN KEY (data_task_id) REFERENCES data_task(identity); give me any error but key doesn't

Re: Read previous record with C API

2002-03-06 Thread Christopher Thompson
mysql_row_seek(). On Wednesday 06 March 2002 10:26 am, JOUANNET, Rodolphe wrote: Can someone tell me how to find the previous record in C (with mySQL API function). I do a SELECT statement, read it with mysql_store_result(), read the first record with mysql_fetch_row(), the next record with

RE: mytop

2002-03-06 Thread Steven Roussey
deletes, and other) as is possible with the Com_ status variable in the later versions of MySQL (no documentation though..)? I've got a bunch of improvements planned now that I'm regularly using MySQL 4.x. Having all those counters is handy. :-) The counters are in 3.23.47 as well.

Re: OS X

2002-03-06 Thread David Steinbrunner
Ray wrote: I have been going out of 'my' mind. I am trying to install mysql on a Macintosh OS X server. Can anyone give me instructions on how to do this? I have been to numerous sites with no luck. We run OS 10.1.2 server, I have mySQL 3.23.49 running (from entropy). During the

RE: mysql on Linux

2002-03-06 Thread Steven Roussey
Starting mysqld daemon with databases from /var/lib/mysql 020305 17:46:10 mysqld ended This is written by safe_mysqld. It seems that mysqld was never started successfully. I've had this issue before. Every time it was a permissions issue. When I execute mysqld -u root -p password I am

multiple servers (2)

2002-03-06 Thread Egor Egorov
Marek, Wednesday, March 06, 2002, 4:19:28 PM, you wrote: MW (Debian 2.4.19, MySQL 3.23.49) MW I have problem with starting multiple servers on one machine. MW According documentation it is enough to start each another then first MW server using ex.: MW safe_mysqld

Re: Patch for compiling mysql++-1.7.9 with gcc-3.0.3

2002-03-06 Thread Sinisa Milivojevic
Erminio Efisio Riezzo writes: Hello folks, I do not succeed to install the patch in order to compile the mysql++-1.7.9 with the GCC-3.0.3. I use the command /usr/local/src/mysql++-1.7.9-patched# /usr/local/bin/patch -p0 -i mysql++-gcc-3.0.patch You can help me? Thanks in advance

Re: mysql on Linux

2002-03-06 Thread Intrex
The /var/lib/mysql contains the following files: linux-bin.001 linux-bin.002 linux-bin.003 linux-bin.004 linux-bin.005 linux-bin.006 linux-bin.007 linux-bin.008 linux-bin.009 linux-bin.index linux-bin.err the directory mysql the directory test directory mysql contains columns_priv.MYD

Re: MySQL Availability

2002-03-06 Thread Ken Menzel
http://www.mysql.com/doc/I/n/Installing_source_tree.html Ken - Original Message - From: Anthony W. Marino [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, March 06, 2002 12:12 PM Subject: MySQL Availability Where can I find most recent (ie; 4.0.2 builds ;Nightly/CVS) at?

Re: multiple servers (2)

2002-03-06 Thread Marek Wysmulek
MW safe_mysqld --socket=/..path../mysql.socket.x --port=numberx You may also add --datadir= ... to separate data directories. Don't need to. Servers can work on the same datas. ( Obviously it is comon solution to separate) MW and so on. so on - please, specify. Ups. My english is not

Re: MySQL Availability

2002-03-06 Thread Anthony W. Marino
On Wednesday 06 March 2002 01:37 pm, Ken Menzel wrote: http://www.mysql.com/doc/I/n/Installing_source_tree.html Someone, replying earlier, mentioned that MySQL AB folks don't grant permission to nightly stuff. I'll test it out, regardless. Thank You, Anthony - Original Message -

Re: Deleting a Record

2002-03-06 Thread Paul DuBois
At 7:46 -0500 3/6/02, Chuck \PUP\ Payne wrote: Hi, I a seting up a php page that will let me delete a record from my mysql database, but I want it be able to match to fields before it will let a user delete that record. I know the basic sql command is DELETE FROM $table WHERE field 1 =

RE: Deleting a Record

2002-03-06 Thread Chuck \PUP\ Payne
Thanks I have now five ways to try. | Chuck Payne | | Magi Design and Support | | [EMAIL PROTECTED] | -Original Message- From: Paul DuBois [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 06, 2002 10:43 AM

trace tools for MySql

2002-03-06 Thread Edward Peloke
Does anyone have any good tools for putting a trace on an MySql server. I want to be able to see what is happening on the server. Thanks, Eddie - Before posting, please check: http://www.mysql.com/manual.php (the manual)

Re: TIMESTAMP not acting as I'd like

2002-03-06 Thread Shankar Unni
Victoria Reznichenko wrote: recu small problem. I have a table set up like so. It has a number of entries recu that were added on a certain date, I use TIMESTAMP to keep track of the date. recu mysql UPDATE deerfield SET version = '2.1' WHERE product = 'WinGate LITE'; recu and all of the

RH 7.2 connections problems w 16 web servers to 2 MySQL servers

2002-03-06 Thread Sam Iam
We have a very high volume site (3 million page views a day) that's run on 16 Apache / PHP web servers 2 MySQL servers. We are using PHP with persistent connections. Each MySQL serves 8 web servers is supposed to act as a failover machine for the other group of 8 web servers. The failover

Re: [linux-lvm] System Suggestions

2002-03-06 Thread Petro
On Wed, Mar 06, 2002 at 11:52:30AM -0500, Anthony W. Marino wrote: Could someone, please, provide me with a link and/or facilitate some suggestons for configuration of the following components for a new DB server hosting MySQL 4.01MAX? I'm only looking to get a start and don't expect THE

Structure as a field

2002-03-06 Thread Hresko, Christian A.
this is an obvious 'newbie' question, so please bare with me. i'm parsing a lot of data from file, and a good deal of this data is in the form of nested C structs. within any given struct, you might have an array of 256 floats, or an array of 256 structs, with 256 floats, etc, etc. i'd like to

Re: Bug with heap table ??

2002-03-06 Thread Sinisa Milivojevic
Fournier Jocelyn [Presence-PC] writes: I believe the problem occurs only when I execute the DELETE when someone is inserting a records at the same time. Perhaps the hash index is not updated properly whereas the data are deleted properly, which entails a mismatch between data and index ? (I

Re: RH 7.2 connections problems w 16 web servers to 2 MySQL servers

2002-03-06 Thread Steven Roussey
We pay for MySQL support but haven't had much help from them. You could pay me, I need work... :) Seriously... We have a very high volume site (3 million page views a day) that's run on 16 Apache / PHP web servers 2 MySQL servers. We are using PHP with persistent connections. Each MySQL

UPATE Using Max?

2002-03-06 Thread Rutledge, Aaron
Hello, In my application I would like to update a MySQL record where one column is the largest value. Do I have to create a separate SELECT sql query statement to get that value and then update it? Or, is there a function that allows me to specify it as part of my WHERE clause. I scanned

foreign key doesn't work

2002-03-06 Thread bin cai
Hello, I am encountering one problem. I am using mysql as the dabase for my application. I create a table like takeexam as following:create table takelabexam( sid varchar(10) not null, cid varchar(20) not null, marks integer foreign

Re: core dump in clients in MYSQL 3.23.49 using groups

2002-03-06 Thread Sinisa Milivojevic
Hi! We have a fix for the problem that you have hit. It is a temporary one. Final one will come in the nexe MySQL release: *** tmp/libmysql.c Wed Mar 6 22:00:00 2002 --- tmp/fixed.c Wed Mar 6 21:59:34 2002 *** *** 737,743 *end=0;

Re: RH 7.2 connections problems w 16 web servers to 2 MySQL servers

2002-03-06 Thread James Housley
Sam Iam wrote: We have a very high volume site (3 million page views a day) that's run on 16 Apache / PHP web servers 2 MySQL servers. We are using PHP with persistent connections. Each MySQL serves 8 web servers is supposed to act as a failover machine for the other group of 8 web

RE: mysql on Linux

2002-03-06 Thread Steven Roussey
When I execute mysqld -u root -p password I am presented with the default variables. Which are? How about showing what mysqld --user=root displays? Also, you see linux-bin.* files? That indicates that mysqld was running at some point (maybe nine times). Can you get the directory listings

MySQL license problem on Windows

2002-03-06 Thread Zengfa Gao
Hi,: I heard that when we use MySQL on windows, we need to pay fees. But I can't find anything on MySQL document to talk about this. Do you know this problem? Thanks a lot! Zengfa __ Do You Yahoo!? Try FREE Yahoo! Mail - the world's greatest

Re: [linux-lvm] System Suggestions

2002-03-06 Thread Anthony W. Marino
On Wednesday 06 March 2002 02:40 pm, Petro wrote: On Wed, Mar 06, 2002 at 11:52:30AM -0500, Anthony W. Marino wrote: Could someone, please, provide me with a link and/or facilitate some suggestons for configuration of the following components for a new DB server hosting MySQL 4.01MAX? I'm

Re: MySQL license problem on Windows

2002-03-06 Thread Christopher Thompson
http://www.mysql.com/documentation/mysql/bychapter/manual_Introduction.html#MySQL_server_licenses On Wednesday 06 March 2002 1:17 pm, Zengfa Gao wrote: Hi,: I heard that when we use MySQL on windows, we need to pay fees. But I can't find anything on MySQL document to talk about this. Do

Re: SQL coding: Finding singular when search with plural.

2002-03-06 Thread Marjolein Katsma
At 16:10 2002-03-06, BadgerBay wrote: Hello, This is a good question for when you are sipping coffee or tea and are inspired to write some code. I require additional functionality for my SQL search: MY CURRENT SEARCH SELECT ID, Authors, Year, Title FROM libraryTable WHERE (Authors LIKE '% +

RE: mysql on Linux

2002-03-06 Thread Luc Foisy
when you run mysqld -u root -p password and it gives you the list of default variables. You can get this same message by typing mydqld --help, which might indicate some error in the command line arguments. This file also shows you configurations supplied on the command line as well as

Re: MySQL license problem on Windows

2002-03-06 Thread John Cichy
All releases of MySQL were GPL'd, see article: http://www.mysql.com/news/article-23.html John On Wednesday 06 March 2002 15:17, Zengfa Gao wrote: Hi,: I heard that when we use MySQL on windows, we need to pay fees. But I can't find anything on MySQL document to talk about this. Do you

Re: MySQL license problem on Windows

2002-03-06 Thread Scalper
Hi Zengfa: No. The operating system has nothing to do with it BUT there are requirements for buying a license. Visit http://www.mysql.com/support/arrangements.html for more details. Thx, Craig At 12:17 3/6/02 -0800, you wrote: Hi,: I heard that when we use MySQL on windows, we need to pay

re[2]: [linux-lvm] System Suggestions

2002-03-06 Thread Greg Freemyer
Anthony, I'd be careful with the IDE Raid controller. We just built a lab machine with a Promise IDE Raid controller and the assumption that we could get it and XFS to co-exist. I'm not doing the work, but the engineer that is tells me that the Promise Patch Kit only works with a very

RE: RH 7.2 connections problems w 16 web servers to 2 MySQL servers

2002-03-06 Thread Dan Vande More
If you can turn on the query log the amount of disk space it takes would be well worth troubleshooting the problem. Try and discern the last queries run on them, in order to help. Perhaps do this twice and you could check for consitency. How much disk space is in use on the drives related to it?

Re: RH 7.2 connections problems w 16 web servers to 2 MySQL servers

2002-03-06 Thread Steven Roussey
Also, I forgot these questions: - What is Apache's http.conf value of MinSpareServers? - What is Apache's http.conf value of MaxSpareServers? Steven Roussey Network54.com sql,query - Before posting, please check:

foreign key doesn't work with mysql

2002-03-06 Thread bin cai
Hello, I am encountering one problem. I am using mysql as the dabase for my application. I create a table like takeexam as following:create table takelabexam( sid varchar(10) not null, cid varchar(20) not null, marks integer foreign

Converting Access2000 to Mysql: Illegal character issue

2002-03-06 Thread joseph . chillari
Im convertinga couple of fully functioning access databases to mysql, however I had problems converting the data over using a number of tools because of illegal characters especially a colon : in the table column names. Now I can change these names to import the data ok but all of the queries

foreign key doesn't work with mysql

2002-03-06 Thread bin cai
Hello, I am encountering one problem. I am using mysql as the dabase for my application. I create a table like takeexam as following:create table takelabexam( sid varchar(10) not null, cid varchar(20) not null, marks integer

Syntax question.

2002-03-06 Thread Erik Schwartz
Hi, Trying to figure out how to convert Sybase ASA syntax to MySQL. Need to select alpha ranges as in: SELECT * FROM table WHERE name LIKE '[A-Z]%' but this doesn't work. Appreciate your help, Erik Schwartz Systems Engineer InfoUSA 818-428-1040 [EMAIL PROTECTED] --- Outgoing mail was

Re: Structure as a field

2002-03-06 Thread DL Neil
Christian, this is an obvious 'newbie' question, so please bare with me. If you had ever seen me without my clothes on, you would not be asking me to do this! Pardon me for joking at the expense of your English, but I've seen this wording/spelling so often on the lists... Bare = unclothed.

Re: MyODBC for Core Business, followup...

2002-03-06 Thread Joshua J . Kugler
To all: This is in response to a request for more information. I thought others may find it useful. Thanks so much for your reply. It's good news to hear that someone is relying on MyODBC for an important purpose, much of the usage I've seen seemed rather small. Like I said, we

RE: Dual Languages??

2002-03-06 Thread David Ayliffe
Doesn't version 4 support Unicode? - isn't this a solution or am I missing something? DA -Original Message- From: Victoria Reznichenko [mailto:[EMAIL PROTECTED]] Sent: 06 March 2002 14:48 To: [EMAIL PROTECTED] Subject: Dual Languages?? bipin, Wednesday, March 06, 2002, 9:56:53 AM,

Re: foreign keys in mysql

2002-03-06 Thread Arjen Lentz
Hi, On Thu, 2002-03-07 at 08:20, bin cai wrote: I am encountering one problem. I am using mysql as the dabase for my application. I create a table like takeexam as following:create table takelabexam( sid varchar(10) not null, cid varchar(20) not null,

Timestamp function formatting bug?

2002-03-06 Thread Shankar Unni
With MySQL 3.23.38: If you have a TIMESTAMP column with zero values, then SELECT ts from table; returns 00 But SELECT min(ts) from table; returns 0 This causes the JDBC driver to fall over when getting the timestamp value from this query. Isn't this a formatting

OFF-TOPIC Create 4 componets to make the 4 bisics operation in a DB

2002-03-06 Thread jhsena
Hi everyone, I know some softwarehouses develop some components in orde to make esier their project. So, folliwng the same steps I would lihe to do develop 4 component to make the 4 basisc operations in a DB:a INSERTER, UPDATER, SELECTER and DROPPER. Imagine the aplication has a class or an

  1   2   >