Re: MySQL-Max database recovery crashed

2001-11-02 Thread Heikki Tuuri
Jeremy, At 11:37 PM 11/2/01 -0800, you wrote: >On Fri, Nov 02, 2001 at 11:17:37PM +0200, Heikki Tuuri wrote: >> >> I looked now what MySQL does when it calls lock_external at startup: >> it initializes MySQL system tables like 'host' and 'user'. I assume >> you have not converted MySQL system ta

Re: MySQL-Max database recovery crashed

2001-11-02 Thread Jeremy Zawodny
On Fri, Nov 02, 2001 at 11:17:37PM +0200, Heikki Tuuri wrote: > > I looked now what MySQL does when it calls lock_external at startup: > it initializes MySQL system tables like 'host' and 'user'. I assume > you have not converted MySQL system tables to InnoDB format? That is > not allowed. They

Re: Need help with a query ...

2001-11-02 Thread Bob Hall
On Fri, Nov 02, 2001 at 06:15:08PM -0800, John Kelly wrote: > Hi, I have a MySQL table with a column that contains some of a web site > directory's category names in the format: > > Sports:Football:Players > > I am trying to build a query that that locates all records that match the > above cate

RE: mysql question

2001-11-02 Thread Steve Meyers
> This may be very obvious but being a new mysql admin user how do I do what > you say above, to delete the user from the user table. There doesn't > appear to be any examples of this in the docs. > You have a database named "mysql". In there, there is a table named "user". It's just a normal t

help with a query

2001-11-02 Thread Greg Sarsons
All be the first to admit that I'm new with mysql. I'm looking for some guidance on putting a query together. What I have a database created by snort which is an IDS. The database information of all the packets that crossed a network segment. For example IP src address, IP destination address,

Re: Innodb file sizes

2001-11-02 Thread Stephen Lee
> In the last episode (Nov 02), Stephen Lee said: >> I have the following settings in /etc/my.cnf: >> >> default-table-type=innodb >> innodb_data_file_path = ibdata1:1000M >> set-variable = innodb_log_file_size=5M >> >> The resulting files: >> -rw-rw1 mysqlmysql2560 Nov 2 12:1

Re: Need help with a query ...

2001-11-02 Thread John Kelly
Hi, thanks for your response. I don't see how the LIKE command would help me pull records that matched the category name or its parent category if none exist, or its parent category if none exists. Perhaps you could provide a example. I want something that follows this logic ... SELECT * FROM ta

Re: Need help with a query ...

2001-11-02 Thread Michael
You need to use the LIKE command I think. The MySQL manual should give you all the details. If you need further help I can just write the whole query out for you. Or was the problem that you only want to worry about the if..then stuff if needed? If so could you tell what your pulling back from tha

Re: Innodb file sizes

2001-11-02 Thread Dan Nelson
In the last episode (Nov 02), Stephen Lee said: > I have the following settings in /etc/my.cnf: > > default-table-type=innodb > innodb_data_file_path = ibdata1:1000M > set-variable = innodb_log_file_size=5M > > The resulting files: > -rw-rw1 mysqlmysql2560 Nov 2 12:17 ib_arc

Need help with a query ...

2001-11-02 Thread John Kelly
Hi, I have a MySQL table with a column that contains some of a web site directory's category names in the format: Sports:Football:Players I am trying to build a query that that locates all records that match the above category name OR if none exist its parent "Sports:Football" OR if none exist i

Where UPDATE documentation?

2001-11-02 Thread Uriel Wittenberg
I am trying to do an UPDATE that is slightly less trivial than UPDATE persondata SET age=age+1; What I want is something like UPDATE persondata SET age = select age from othertable where persondata.id = othertable.id; But the manual gives no clue as to whether this is possible. And if there is

Re: mysql and cgi

2001-11-02 Thread paco anubis
oops, I meant to type Perl for 4 weeks, I am using version Perl 5.6.0 --- Michael Ayres <[EMAIL PROTECTED]> wrote: > Hi Paco, > > If I could make a suggestion... I think you'll be > much happier using a > newer version of perl than 4. With perl 5 and up > you get to use the > wonderful featur

mysql@lists.mysql.com

2001-11-02 Thread root
>Description: >How-To-Repeat: >Fix: >Submitter-Id: >Originator:root >Organization: >MySQL support: [none | licence | email support | extended email support ] >Synopsis: >Severity: >Priority: >Category: mysql >Class: >Release:

RE: mysql question

2001-11-02 Thread Jim Chivas
On Fri, 2 Nov 2001, Rick Emery wrote: > SHOW GRANTS FOR user@localhost > > I don't know how to remove users other than directly removing them from > mysql.user table > This may be very obvious but being a new mysql admin user how do I do what you say above, to delete the user from the user ta

Repeated corruption of the same table under 3.23.36 (redhat i386)

2001-11-02 Thread jem
>Description: We're running mysql version 3.23.36-1 under Redhat i386 7.1. The machine is a two processor Va Linux box with 512 Mb of RAM. This is the command line we're running: /usr/libexec/mysqld --defaults-file=/etc/my.cnf --basedir=/usr --datadir=/var/lib/mysql --user=mysql

Win32 mysqld-opt: Invalid page fault on certain query

2001-11-02 Thread Ken
I'm running MySQL 3.23.41 on Win95 (just upgraded from an earlier 3.23 beta, in case that would solve the problem). I have a moderately complex query that causes the MySQL server to crash when I execute it. (invalid page fault in module MYSQLD-OPT.EXE) The same query works fine on a Redhat ve

Design,Performance and Speed of MySQL

2001-11-02 Thread Manjeet Singh
Hi Group, I am new to mysql, and would like you all to give some time in resolving my trouble. I am stuck up with a problem of designing stores database for a big company.The company is located in different places and wants web-based insertion, retrival and maintaining of data and records in the

Error when compiling API

2001-11-02 Thread Douglas Blood
I have been compiling into qmail support to mysql and was getting many errors. I have found out most of them and have fixed them by changing the Makefile for qmail but I can not understand why when I load all of the mysql libraries(libdbug.a, libmygcc.a, libmysqlclient.a, libmystrings.a, libmysys

linking to a database id

2001-11-02 Thread chip . wiegand
I have a database of dealers. A web page loads a list of states, a user clicks on the state and the database is queried and lists in a table the dealers for that state. Simple enough. When the dealers page is first loaded, it shows all dealers in the database, name, address, phone, etc. I want to

scaling/tuning problem

2001-11-02 Thread another oracle dba
Hi. I have a query which completes in about 9 sec when executed alone, but the time grows dramatically when I execute several similar queries at the same time. If I execute 3 queries the time grows to 27-40sec, for 5 queries - toabout 1min, for 20 queries ran simultaniously the time jumps to 2-4

RE: mysql question

2001-11-02 Thread Rick Emery
SHOW GRANTS FOR user@localhost I don't know how to remove users other than directly removing them from mysql.user table -Original Message- From: Jim Chivas [mailto:[EMAIL PROTECTED]] Sent: Friday, November 02, 2001 4:53 PM To: Mark Maunder Cc: Jim Chivas; [EMAIL PROTECTED] Subject: Re: m

Innodb file sizes

2001-11-02 Thread Stephen Lee
I have the following settings in /etc/my.cnf: default-table-type=innodb innodb_data_file_path = ibdata1:1000M innodb_data_home_dir = /var/lib/mysql/ innodb_log_group_home_dir = /var/lib/mysql/ innodb_log_arch_dir = /var/lib/mysql/ set-variable = innodb_mirrored_log_groups=1 set-variable = innodb_

Re: mysql question

2001-11-02 Thread Jim Chivas
On Fri, 2 Nov 2001, Mark Maunder wrote: > Jim Chivas wrote: snip.. I checked this site and it appears to match other docs I have. There are still no examples of removing users just revoking grants. What commands would tell me what users have what rights to what databases and tables? Thanks Ji

RE: changing column order in MySQL tables?

2001-11-02 Thread Bill Blowitz
Or the way they go in when you issue a INSERT query. If you still need to have the field (we'll call the field "C") you can add a NEW column where you want the this existing column "C" (we'll call this field "C1"). Next, update all your data that's in "C" so It's also in "C1". Next, alter the

Re: MySQL-Max database recovery crashed - Fixed!

2001-11-02 Thread Stephen Lee
> Stephen, > > At 01:37 PM 11/2/01 -0800, you wrote: >>> Stephen, >>> >>> At 12:38 PM 11/2/01 -0800, you wrote: Heikki, Removal of the log= option and even the log-bin statement did not help. I used the latest (2.23.44) RPMs from one of the mysql.com mirrors. I don't think it'

Re: changing column order in MySQL tables?

2001-11-02 Thread Paul DuBois
At 2:12 PM -0800 11/2/01, Bennett Haselton wrote: >How do you change the order of columns in MySQL tables? I assume >the tables have a concept of column order, since the DESCRIBE >command always lists the columsn in the order in which they were >created. > >I figured that the place to look wou

changing column order in MySQL tables?

2001-11-02 Thread Bennett Haselton
How do you change the order of columns in MySQL tables? I assume the tables have a concept of column order, since the DESCRIBE command always lists the columsn in the order in which they were created. I figured that the place to look would be the syntax page for the ALTER TABLE statement:

Replication Trouble

2001-11-02 Thread Stephen_Morad
Hello, I'm trying to get replication working between two MySQL servers. I'm running MySQL 3.23.43-log on a Solaris Server and MySQL 3.23.43-nt on a Win2k Server. I am trying to set up the Solaris Server as a slave and the Win2k Server as the master. Following the replication instructions on htt

Re: MySQL-Max database recovery crashed

2001-11-02 Thread Heikki Tuuri
Stephen, At 01:37 PM 11/2/01 -0800, you wrote: >> Stephen, >> >> At 12:38 PM 11/2/01 -0800, you wrote: >>>Heikki, >>> >>>Removal of the log= option and even the log-bin statement did not help. >>>I used the latest (2.23.44) RPMs from one of the mysql.com mirrors. I >>>don't think it's a download

Re: MySQL-Max database recovery crashed

2001-11-02 Thread Stephen Lee
> Stephen, > > At 12:38 PM 11/2/01 -0800, you wrote: >>Heikki, >> >>Removal of the log= option and even the log-bin statement did not help. >>I used the latest (2.23.44) RPMs from one of the mysql.com mirrors. I >>don't think it's a download issue because the problem originally >>occured with the

Re: mysql and cgi

2001-11-02 Thread Michael Ayres
Hi Paco, If I could make a suggestion... I think you'll be much happier using a newer version of perl than 4. With perl 5 and up you get to use the wonderful features of DBI (Perl's database interface module) and DBD (database drivers such as the one for Mysql). Not without saying you'll g

Re: MySQL-Max database recovery crashed

2001-11-02 Thread Heikki Tuuri
Stephen, At 12:38 PM 11/2/01 -0800, you wrote: >Heikki, > >Removal of the log= option and even the log-bin statement did not help. I >used the latest (2.23.44) RPMs from one of the mysql.com mirrors. I don't >think it's a download issue because the problem originally occured with the >2.23.43 dis

Re: MySQL-Max database recovery crashed

2001-11-02 Thread Stephen Lee
Heikki, Removal of the log= option and even the log-bin statement did not help. I used the latest (2.23.44) RPMs from one of the mysql.com mirrors. I don't think it's a download issue because the problem originally occured with the 2.23.43 distribution. The crash occurs within seconds of startin

Re: How to flush text to mysql.err file? <<

2001-11-02 Thread Heikki Tuuri
Brent, I realize we should call fflush for stderr after every error message (or meybe every 5 seconds). But a way to see the error message immediately is to run from the MS-DOS prompt with options --standalone --console. When writing to the command prompt window operating systems seem to flush al

mysql and cgi

2001-11-02 Thread paco anubis
Hello, I started learning Perl 4 weeks ago and mysql 3 days ago so I know that I am in over my head, but here goes nothing. I am trying to build a Perl CGI application (using DBI) to pass form contents from a web page directly into a MySql database. I don't know how to pass the Perl variable fr

Re: When will MySQL 4 for Windows be out? ( Waiting for Godot) <<

2001-11-02 Thread Heikki Tuuri
Brent, >Is there any news on the release date for MySQL 4 for Windows? >I feel like I'm sitting by the side of the road waiting for Godot. Is it >ever going to show up? > >Brent I found it from the downloads page. Heikki -

How to flush text to mysql.err file? <<

2001-11-02 Thread BD
When I get a MySQL error, the error message is only partially written to MySQL.Err file (on WIn2k). If I call the MySQL.Err text file up in an editor window, only half of the error message is visible. I tried MySLAdmin flush-logs but that didn't help. How do I get the entire error message disp

Re: MySQL-Max database recovery crashed

2001-11-02 Thread Heikki Tuuri
Stephen, I resolved now with the mysql-max-3.23.44...tar.gz distribution. I still do not understand what mysqld is trying to do here. What distribution do you use, or did you compile yourself? 0x807b90f handle_segfault__Fi + 383 0x8253c7a pthread_sighandler + 106 0x80cf21a change_active_index__1

Solaris 8 and gcc

2001-11-02 Thread Peter L. Berghold
Hi folks, I'm trying to compile mysql on a Solaris 8 box with gcc. When I run compile for reasons I do not understand configure thinks the g++ compiler is running as a cross compiler which it is not. This causes the test for the return type of sprintf to fail with the message "can not run test

When will MySQL 4 for Windows be out? ( Waiting for Godot) <<

2001-11-02 Thread BD
Is there any news on the release date for MySQL 4 for Windows? I feel like I'm sitting by the side of the road waiting for Godot. Is it ever going to show up? Brent - Before posting, please check: http://www.mysql.com/manual

Re: MySQL-Max database recovery crashed

2001-11-02 Thread Stephen Lee
> Stephen, > > I resolved the stack dump based on the 3.23.43 symbols file. I do not > understand what mysqld is trying to do here. Are you sure the stack > dump is from 3.23.43? > > 0x807b90f init_signals__Fv + 71 > 0x8253c7a __tfx + 26 > 0x80cf21a index_prev__11ha_innobasePc + 74 > 0x8078693 mys

SELECT MAX makes MYSQL Crush

2001-11-02 Thread Michael Widenius
Hi! > "macbethh" == macbethh writes: macbethh> PLATFORM: macbethh> MySQL Server Version: 3.23.42-max-nt (on SQL Server 2000), 3.23 (on Caldera Linux) [Latest stable versions] macbethh> MyODBC Version:2.50.39 macbethh> Client OS Version= Windows 2000 Server macbethh> Client Program

Re: Can't set max_connections on debian version

2001-11-02 Thread William R. Mussatto
Thanks, got it. On Wed, 31 Oct 2001, Wouter de Jong wrote: > Date: Wed, 31 Oct 2001 09:19:14 +0100 > From: Wouter de Jong <[EMAIL PROTECTED]> > To: "William R. Mussatto" <[EMAIL PROTECTED]> > Cc: [EMAIL PROTECTED] > Subject: Re: Can't set max_connections on debian version > > On Tue, Oct 30, 20

Re: MySQL-Max database recovery crashed

2001-11-02 Thread Heikki Tuuri
Stephen, I resolved the stack dump based on the 3.23.43 symbols file. I do not understand what mysqld is trying to do here. Are you sure the stack dump is from 3.23.43? 0x807b90f init_signals__Fv + 71 0x8253c7a __tfx + 26 0x80cf21a index_prev__11ha_innobasePc + 74 0x8078693 mysql_lock_remove__FP

Re: Indexing support

2001-11-02 Thread Sasha Pachev
On Friday 02 November 2001 11:39 am, Deepanshu Shukla wrote: > I have a course project at hand which deals with > indexing in MySQL. Has anyone worked with Indexing in > MySQLie worked on code.i seem 2 be a bit lost > i the source code..Can anyone help me out. What is it exactly you are t

Substract tables. Hard query. Non-trivial problem?

2001-11-02 Thread Andrey
Hi! There was a problem and its solution will be interesting, I think, not only for me. In what essence: I create quiz the game... On a condition, there is the base of questions, placed, for example, in table Quests. Players in the game answer on 10 randomly (it important!) selected questions. R

MySQL-Max database recovery crashed

2001-11-02 Thread Stephen Lee
I converted my myISAM tables to Innodb format and everything went fine. When I restarted MySQL-Max (2.23.43) I noticed that my query log file was not being accessed anymore so I included "log=/var/lib/mysql/server1.log" to /etc/my.cnf. Running MySQL-Max this time though caused a continuous restart

Indexing support

2001-11-02 Thread Deepanshu Shukla
I have a course project at hand which deals with indexing in MySQL. Has anyone worked with Indexing in MySQLie worked on code.i seem 2 be a bit lost i the source code..Can anyone help me out. Deepanshu = Deepanshu [ KReSIT ] IIT-B [EMAIL PROTECTED] __

RE: UPDATE table1 FROM table2

2001-11-02 Thread Steve Meyers
On Fri, 2001-11-02 at 09:57, Paul DuBois wrote: > At 9:47 AM -0700 11/2/01, Steve Meyers wrote: > >That's a dangerous solution. If there are more columns in test2 than ID > >and Value, the REPLACE will delete those values. As you noted in the > >manual, the old record is deleted before the new r

Re: Can't create InnoDb table via PHP script

2001-11-02 Thread Carl Troein
BD writes: > I'm just started using PHP so maybe I'm doing something silly here, but for > some reason I can't create an InnoDb table from within a PHP script. > The same script can create a MYSIAM table just fine when "Type=MyISAM", but > when the table type is "Type=InnoDb" then the query fa

how to spool timing of a query into a spool file

2001-11-02 Thread another oracle dba
Hi this is a 2nd attempt. My first post never made it to the list. What I'm trying to do is to spool queries results into a spool file (via tee command). For some reason the timing information doesn't get there. When I run a query from mysql, the output is followed by a line with the number of ro

Can't create InnoDb table via PHP script

2001-11-02 Thread BD
I'm just started using PHP so maybe I'm doing something silly here, but for some reason I can't create an InnoDb table from within a PHP script. The same script can create a MYSIAM table just fine when "Type=MyISAM", but when the table type is "Type=InnoDb" then the query fails. MySQL.Err has n

RE: UPDATE table1 FROM table2

2001-11-02 Thread Paul DuBois
At 9:47 AM -0700 11/2/01, Steve Meyers wrote: >That's a dangerous solution. If there are more columns in test2 than ID >and Value, the REPLACE will delete those values. As you noted in the >manual, the old record is deleted before the new record is inserted. > >Multi-table updates should happen

RE: InnoDB disk full problem

2001-11-02 Thread Heikki Tuuri
Wai, At 11:39 AM 11/2/01 -0500, you wrote: >Hi, >The table has 76 columns in it, there are 35 columns are not populated yet >but they are all in VARCHAR format (NOT FIXED-SIZE columns). Does it still >take space even in VARCHAR format? no, a NULL in a VARCHAR column only takes 1 - 2 bytes. >Let

RE: UPDATE table1 FROM table2

2001-11-02 Thread Steve Meyers
That's a dangerous solution. If there are more columns in test2 than ID and Value, the REPLACE will delete those values. As you noted in the manual, the old record is deleted before the new record is inserted. Multi-table updates should happen in 4.1, I think, which is due out fairly soon. If

RE: InnoDB disk full problem

2001-11-02 Thread Wai Lee
Hi, The table has 76 columns in it, there are 35 columns are not populated yet but they are all in VARCHAR format (NOT FIXED-SIZE columns). Does it still take space even in VARCHAR format? Let's say the 35 columns take space, the worst case will be doubling the space like myISAM table is taking t

Re: Can I use the concept of Effective Date with MySQL?

2001-11-02 Thread Steve Meyers
Rich and Alejandro, Have I got a query for you! :) Using Alejandro's example, here is a query that would work: SELECT s.trans_id, b.price FROM sales s, rates a, rates b WHERE a.item=s.item AND b.item=a.item AND a.date < s.date GROUP BY s.trans_id, b.item, b.date HAVING b.date=MAX(s.date) Steve

Re: SELECT MAX makes MYSQL Crush

2001-11-02 Thread Heikki Tuuri
Cenk, if the table type is InnoDB, then this is a known bug and it was fixed to 3.23.44. The bug only happens if the table is empty and you do a SELECT MAX(col) where col is a part, but not the first part of a multi-column index. Please see the 3.23.44 release note posted today to this same maili

SELECT MAX makes MYSQL Crush

2001-11-02 Thread Cenk Akyüz
PLATFORM: MySQL Server Version: 3.23.42-max-nt (on SQL Server 2000), 3.23 (on Caldera Linux) [Latest stable versions] MyODBC Version:2.50.39 Client OS Version= Windows 2000 Server Client Program = ODBCTest 3.00 PROBLEM: When I run the following commands MYSQL crushes. It says ["The inst

how to spool timing of a query into a spool file

2001-11-02 Thread another oracle dba
Hi. this is a minor problem that is driving me nuts. I have a query that runs nicely and I want to save its timing information in a spool file. When I connect to mysql and run the query it adds the time elapsed after the data (9 rows in set 1.1 sec). But when I run the same query in the line mode

The same query takes much longer on 3.23 than on 3.22

2001-11-02 Thread Vladislav Uvarov
Yo! We've upgraded from 3.22 to 3.23 with isam->myisam conversion and everything was ok but this - one particular query became much slower. Here's how it was with 3.22: mysql> select a.ID,c.name,a.title,a.publishedDate,c.id,count(a.id),k.id,c.parentID from articles a LEFT JOIN comments k O

Re: InnoDB disk full problem

2001-11-02 Thread Heikki Tuuri
Wai, >Hi, > >Help!!! Can anyone kindly tell me why InnoDB will take up 10 times table >space comparing with myISAM's table file? I only have one index built in >this table and I don't think it took a lot of table space. The table has >543009 records and has a file size 256M in myISAM but it takes

Re: newby question about datetime fields

2001-11-02 Thread Tony
Try this: select * from my_table order by my_datetime ASC; select * from my_table order by my_datetime DESC; Cheers, T On Thursday 01 November 2001 06:15 am, brainheap wrote: > Hi ppl! > > I have a table with datetime type column in it. > > > when I make request "select * from

RE: error in mysql using poolman

2001-11-02 Thread felix
I have tried all the transaction isolation levels (READ_COMMITTED,READ_UNCOMMITTED,...) and even I have deleted that line in poolman.xml file, but it isn't working yet I'm new in mysql and I haven't modified any configuration in mysql. Maybe any option that I haven't configured. Any idea? Thanks

RE: PHP4 and MySQL

2001-11-02 Thread Curtis Gordon
No Benj, it's not built in, just support for it is, I'm using apache, PHP4 and mysql on a win32 box and you have to grab and install all the parts yourself. It's not difficult though, I managed to do it! (C: >From: "Benj Arriola" <[EMAIL PROTECTED]> >Reply-To: <[EMAIL PROTECTED]> >To: <[EMAIL

Re: error in mysql using poolman

2001-11-02 Thread TAKAHASHI, Tomohiro
HI, I think MySQL does not support TransactionIsolationLevel NONE. And, setTransactionIsolation method of 'org.gjt.mm.mysql.Driver' will throw SQL Exception. Because, in that case, driver sends SQL statement 'SET SESSION TRANSACTION ISOLATION LEVEL ;' to MySQL. This SQL statement is wro

InnoDB disk full problem

2001-11-02 Thread Wai Lee
Hi, Help!!! Can anyone kindly tell me why InnoDB will take up 10 times table space comparing with myISAM's table file? I only have one index built in this table and I don't think it took a lot of table space. The table has 543009 records and has a file size 256M in myISAM but it takes 2.3G table

Re: mysql.sock deletes itself on Solaris

2001-11-02 Thread Sinisa Milivojevic
[EMAIL PROTECTED] writes: > >Description: > /tmp/mysql.sock is there and then apparently randomly its removed without > warning.. mysql still accepts TCP connections and theres no log comment > to indicate an error. > > >How-To-Repeat: > It seems random.. Hi! The above is a consequence

error in mysql using poolman

2001-11-02 Thread felix
First of all, sorry for this email if you are not the proper person, but I'm desperate with this problem I am testing PoolMan to provide database connection pooling on W98 running mysql with the mm.mysql JDBC drivers and JDK 1.3.1. When I execute my sample code the next error appears: "java.s

RE: UPDATE table1 FROM table2

2001-11-02 Thread Rick Emery
Funny you should ask that. There was a similar questoin answer on the PH-DB mailing list (different poster, though) Answer is: REPLACE INTO test2 (test2.ID, test2.Value) SELECT test1.ID, test1.Value FROM test1 WHERE test1.ID LIKE '1' >From manual: "...REPLACE works exactly like INSERT,

Re: Query mych slower when using index (Innodb)

2001-11-02 Thread Michael Widenius
Hi! I didn't cc the bugs lists, because this isn't a repeatable bug. > "nsabbi" == nsabbi <[EMAIL PROTECTED]> writes: mysql> select count(*) from keywords where keyword IN ('tubo'); nsabbi> +--+ nsabbi> | count(*) | nsabbi> +--+ nsabbi> |31210 | nsabbi> +--

4.1

2001-11-02 Thread Denis Rudakov
Hi. Question for MySQL developers: when the 4.1 may be released ? Thanx. dannis. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To reques

Re: Need source codes.

2001-11-02 Thread Carl Troein
Kasture Baswaraj Mahaling writes: > I Am M.S. student . i need to modify storage structure of mysql as part > of my acadamic. > pls. may i know related files. I don't comprehend what you're trying to say, but if you're looking for the source to MySQL, just download it from the web site.

Re: mysql.sock deletes itself on Solaris

2001-11-02 Thread Stephen J. Wilcox
very sure theres nothing deleting the file.. i'll move it tho and see what happens.. Steve On Fri, 2 Nov 2001, Brian P. Austin wrote: > mysql, query, server > > > there is probably a cron job or sumptin that is deleting your sock > file. Try putting it in a different place. > > [EMAIL PROT

Re: Installing Calendar 0.9.33 on Mac OS X

2001-11-02 Thread Brian P. Austin
query, mysql server Try this mysqladmin -u root -p create intranet mysql -u root -p intranet < tables-mysql.sql next time tell us what the error is and it is a lot easier to fix the problem :) Quentin Bennett wrote: > First pointer - what errors are you getting! > > -Original Message-

Re: mysql.sock deletes itself on Solaris

2001-11-02 Thread Brian P. Austin
mysql, query, server there is probably a cron job or sumptin that is deleting your sock file. Try putting it in a different place. [EMAIL PROTECTED] wrote: > >Description: > /tmp/mysql.sock is there and then apparently randomly its removed without > warning.. mysql still accepts TCP connecti

Need source codes.

2001-11-02 Thread Kasture Baswaraj Mahaling
Hello, I Am M.S. student . i need to modify storage structure of mysql as part of my acadamic. pls. may i know related files. Pls. thanks a lot. ---http://www.cse.iitb.ac.in/~baswaraj- [EMAIL PROTECTED] ---

Re: mysql question

2001-11-02 Thread Mark Maunder
Jim Chivas wrote: > Greetings: > > I saw a reply you sent to a mysql user about setting up new users to > mysql. I am hoping you can clarify some questions for me. > > I referenced the url you gave out at the mysql.com/documentation/. It > was suppose to show how to setup users but does not g

Error

2001-11-02 Thread Аркадий
Hello. fields of type TEXT and VARCHAR are not CONCATenating in version 3.23.42 under Windows 98. i'm using ActivePerl & DBI:mysql module; 1. create table a_table (Name char(16), Info text) 2. insert # blah blah blah... 3. select concat(Name, ' ', Info) from a_table result is empty without a

mysql.sock deletes itself on Solaris

2001-11-02 Thread steve
>Description: /tmp/mysql.sock is there and then apparently randomly its removed without warning.. mysql still accepts TCP connections and theres no log comment to indicate an error. >How-To-Repeat: It seems random.. >Fix: Good question - any ideas?! >Submitter-Id: steve >Originator:

UPDATE table1 FROM table2

2001-11-02 Thread Moshe Gurvich
In MySQL 3.23, how to update one table using information from another table. update table1 set value1=t2.value2 from table1 as t inner join table2 as t1 using(pk_key) ??? or update table1 as t1 inner join table2 as t2 using(pk_key) set t1.value1=t2.value2 ??? Is it possible at all? Thank you

MySQL4.X Agent

2001-11-02 Thread Stuart Fox
Hi all, Is there any progress on the load balancing agent? I ask because Ive been working on a HA/LB solution for my company but dont want to duplicate work. My system is independent of MySQL and all in perl and should support and database that does hot replication. Stuart

Re: Query mych slower when using index (Innodb)

2001-11-02 Thread nsabbi
without the index on keywords.codice: mysql> show index from keywords; +--++--+--+-+---+-+--++-+ | Table| Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part |

Re: Help - Migration to mysql from a legacy ISAM

2001-11-02 Thread Sergei Golubchik
Hi! On Nov 01, Ian Collins wrote: > So how do you use the HANDLER command in a C program? > I perused the code for 3.2x for this, and ended up installing mysql-4.0.0. > I found what I believe to be the code for HANDLER in > libmysqld/sql_handler.cc > in the functions, > mysql_ha_open, mysql_ha_cl

Re: Excluding results based on contents of secondary table

2001-11-02 Thread Anvar Hussain K.M.
Hi Moishe, The following query will solve your provlem. Select a.* from a left join b on a.c = b.c where b.c is null; Anvar. At 09:53 PM 01/11/2001 -0800, you wrote: >Perhaps this is more of a general SQL question than a MySQL specific one, >and I may be exposing my ignorance by asking this, b

Replication Server is missing rows

2001-11-02 Thread Ershad Shafi Chowdhury
Hi! Has anyone experienced a replication server to miss updates? Our master is running Mysql 3.23.33 on RH 6.1 Kernel 2.2.12-20 and the slave is running 3.23.24 on Solaris 2.5.1 Normally Inserts and updates occur on the master and SELECT queries occur on the slave. Recently the mirroring stopped

FREEBSD4.4

2001-11-02 Thread Riccardi Moreno
Hi all, I install mysql-client-3.23.42 on FreeBSD4.4 from FreeBSD boot disk but I'm not able to start the server. Anyone have any ideas how to start server?? Moreno - Moreno Riccardi

Re: Can I use the concept of Effective Date with MySQL?

2001-11-02 Thread Rich Duzenbury
I've got the same issue that you do. Here is my thinking thus far: Say I have a transaction table: Record_Key Service_Date Item_Code Item_Quantity I'm considering this structure for the rate table: Item_Code Effective_Date Rate It's practical from a data entry perspective, but I can't seem to

RE: PHP4 and MySQL

2001-11-02 Thread brother
> -Original Message- > From: Benj Arriola [mailto:[EMAIL PROTECTED]] > > I guess to find out, I'll have to install it, but being far > from the US and with small bandwith, downloading large files > is not always ideal to do. :-) http://www.php.net/mirrors.php /bro. database,sql,query,t

orionserver-mysql

2001-11-02 Thread preda
Hello, I'm writing a java-based web mail client using JavaMail and ejb, and i want to know if i can use mysql server for databases. For the moment I use a postgreSQL database and the application works. I tried to make the application work with mysql. I tried to create a database using the m