Re: Need Help bad!.. today.. of all days!

hope you version came out better thn mine.. in my mail it was all out of shape.. maybe could attach a text file.. doubt the list allows that thoough alot dont Upload it as your_code_name.txt to your website and send an URL to the list. filter: mysql query sql Bye, B.

SMP, Parallel queries, MERGE, RAID

Hi. Just wondering if this is something that has been planned for MySQL... If MERGE table are used, from the documentation, my understanding is that they are searched in sequence when a SELECT is issued. However, would it not be reasonably easy to implement a parallel search algorythm, so

Re: Stored Procedure

So sprach »Cafetechno« am 2001-12-26 um 10:34:59 +0700 : If mysql will include the stored procedure feature, what kind of langguage to be used for the stored procedure ? If you use myperl, it will be perl. Alexander Skwar -- How to quote: http://learn.to/quote (german) http://quote.6x.to

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

Downgrade to 2.95.3 - Original Message - From: luhar-123 [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, December 25, 2001 2:09 AM Subject: How to make use of mysql++ with gcc 2.96 Hi guys, i have installed red hat linux 7.2 and mysql server version 3.23.42. but i need

Help! Replication: Cleanup after failover

Please help, I've read through the manual and this case is suggested but not really laid out. I'm using mysql 3.23.37 and can't upgrade to 4.0 yet. Okay, I've got replication on 2 machines with a one-way failover setup: Master fails, slave takes over. Now the slave has been recording updates

Newbie Problem .

Hi list, This is the first time I am installing MySql on my machine. I downloaded the latest tar version (3.23.46) from mysql.com and tried to install it. But when I gave the command ./configure --prefix=/usr/local/mysql It gave me the message that you don't need to configure

Re: Help! Replication: Cleanup after failover

Steve, Are the two servers roughly equal in terms of hardware? Scott Helms Please help, I've read through the manual and this case is suggested but not really laid out. I'm using mysql 3.23.37 and can't upgrade to 4.0 yet. Okay, I've got replication on 2 machines with a one-way

Re: Jdbc Help

Hi, Is it first time in using library(*.jar) with WebApplication? Put it in webappdir/WEB-INF/lib/ dir. This is a easiest way. Hari Yellina wrote: Hi Guys, I am using mm.mysql driver, to connect to mysql. I have placed in lid of tomcat and given classpath as well. But it says

Re: Help! Replication: Cleanup after failover

Steve, There isn't an automated way, but you can at least semi-script this. To switch the slave to the master after the old master has failed and then brought back up do this: Shut down MySQL on the NEW master mysqladmin -u root -ppassword shutdown Snapshot all the data on your NEW master

Re: Stored Procedure

Explain how to configure the handlers for myperl under the win32 platform... Alexander Skwar wrote: So sprach »Cafetechno« am 2001-12-26 um 10:34:59 +0700 : If mysql will include the stored procedure feature, what kind of langguage to be used for the stored procedure ? If you use myperl,

how to select only NOT NULL fields ?

Hi ! I need a help on the syntax. My table has over 100 different fields: I want to display only the NOT NULL fields and also the names of these NOT NULL fields. so the simple mysql command : mysql select * from tabID where tabID.login='john'; returns a long ... long line, with many items

Re: how to select only NOT NULL fields ?

is NOT NULL in the whare close 26/12/2001 16:46:44, Gilles Missonnier [EMAIL PROTECTED] wrote: Hi ! I need a help on the syntax. My table has over 100 different fields: I want to display only the NOT NULL fields and also the names of these NOT NULL fields. so the simple mysql command :

Can't Connect

I am attempting to connect to a MySQL instance hosted by addr.com, and I receive the error Can't connect to MySQL server on '209.249.147.203' (10060) What does this error 10060 typically indicate? Kelvin- - Before posting,

Re: Stored Procedure

[ obfilter: mysql database ] Sinisa Milivojevic wrote: Cafetechno writes: When The Stored Procedure Capability will be included in mySQL Take a look at myperl on http://freshmeat.net Interesting start, of course. What would be nice is to support a proper create or replace

conceptual problem with ODBC and mysql

i am following 'SAMS teach yourself MYSQL in 21 days.. i have a conceptual problem with how i am going to get the data from my microsoft Access database and insert it into mysql tables. i thought i was going to use ODBC but after reading lots of pages it looks like you use this program if you

bin/safe_mysqld fails after startup

Description: I have installed RH7.2, compiled GCC 2.95.3 then removed 2.96 prior to make install. After extracting mysql to /usr/local/src/mysql-version and making a symbolic link from /usr/local, i ran the configure script. Mysql started and ended. I thought maybe the permissions were

Re: To Chris Mercury

database,sql,query,table Haven't been able to solve the File DSN problem yet (running into the same thing as you), but I'm able to connect using a system dsn. is there any reason why you need a file based one?0. - Before

Newbie install problem

I've just downloaded and installed the rpm (to RH7.1), thus: # rpm -iv MySQL-3.23.46-1.i386.rpm Preparing packages for installation... MySQL-3.23.46-1 Preparing db table Preparing host table Preparing user table Preparing func table Preparing tables_priv table

Re: Newbie install problem

You know what i download a different on. go to rpmfind.net do a mysql search. also down load the client plus the common ... it should work. if you have trouble let me know ok ... Luis On Wed, 2001-12-26 at 10:09, Richard Lyons wrote: I've just downloaded and installed the rpm (to RH7.1),

RE: conceptual problem with ODBC and mysql

Hi, -Original Message- From: Barbara Ferrell [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 26, 2001 10:11 AM To: [EMAIL PROTECTED] Subject: conceptual problem with ODBC and mysql i am following 'SAMS teach yourself MYSQL in 21 days.. i have a conceptual problem with

Re: conceptual problem with ODBC and mysql

No problem, Barbara. No ODBC required, either. I wish all my problems were this easy. Basically you need to go back to your PC. Export your database as CVS files from Access (use TAB between fields, single quotes around each field, and newline at end-of record). Put each table into a file

RE: Newbie install problem

I've just downloaded and installed the rpm (to RH7.1), thus: cut a'lot PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER ! This is done with: /usr/bin/mysqladmin -u root -p password 'new-password' /usr/bin/mysqladmin -u root -h potty.coho -p password 'new-password'

RE: Can't Connect

-Original Message- From: Kelvin King [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 26, 2001 6:29 PM To: [EMAIL PROTECTED] Subject: Can't Connect I am attempting to connect to a MySQL instance hosted by addr.com, and I receive the error Can't connect to MySQL server on

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

This post is partially a reply to a request to share my MyISAM/InnoDB/Oracle comparison testing with you guys. In addition, I have a question about locking mechanisms in InnoDB which I'll ask at the end of the post. I've been comparison testing MyISAM, InnoDB, and Oracle for the past two weeks

Re: Selecting unknown columns

Alex, With reference to Dave's comments/suggestions:- I've got a 700-question multiple choice quiz that I've got imported into MySQL, with one small problem: the answers to the quiz are not a separate column. I have three columns for each of the possible answers; the correct answer is

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

Walt, thank you for the test! This post is partially a reply to a request to share my MyISAM/InnoDB/Oracle comparison testing with you guys. In addition, I have a question about locking mechanisms in InnoDB which I'll ask at the end of the post. I've been comparison testing MyISAM, InnoDB, and

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

On Thu, Dec 27, 2001 at 12:18:38AM +0200, Heikki Tuuri wrote: : The MyISAM table obviously fit in the OS file cache, otherwise 1750 inserts : per second would not be possible. Did the table fit in the buffer pool of : InnoDB or the SGA of Oracle? Did you commit each insert individually in :

synopsis of the problem (one line)

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

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

Philip, On Thu, Dec 27, 2001 at 12:18:38AM +0200, Heikki Tuuri wrote: : The MyISAM table obviously fit in the OS file cache, otherwise 1750 inserts : per second would not be possible. Did the table fit in the buffer pool of : InnoDB or the SGA of Oracle? Did you commit each insert individually

DOC BUG: mysqladmin

The command FLUSH TABLES WITH READ LOCK has an equivalent, supposedly, from mysqladmin. But whatever it is, it's not documented! I've unsuccessfully tried mysqladmin flush-tables --with-read-lock mysqladmin flush-tables --read-lock What works? Anyone? -- Steve Rapaport World Citizen

binary varchar fields seems non-binary

Description: It seems that there's a bug on the case-sensitive / case insensitive fields. I have a table created as follows: CREATE TABLE hosoktest ( idx int(11) DEFAULT '0' NOT NULL, nev varchar(20) binary DEFAULT '' NOT NULL, jelszo

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

Sinisa Milivojevic [EMAIL PROTECTED] writes: luhar-123 writes: Hi guys, i have installed red hat linux 7.2 and mysql server version 3.23.42. but i need mysql++ also.but it seems that gcc version 2.96 will give lot of problems for mysql++. can any one pls give me a solution to use

Re: DOC BUG: mysqladmin

In the last episode (Dec 27), Steve Rapaport said: The command FLUSH TABLES WITH READ LOCK has an equivalent, supposedly, from mysqladmin. I doubt it. If the manual says there is it should probably be fixed. Table locks are only held for as long as the connection that created them is

Re: DOC BUG: mysqladmin

Thanks, Dan, that sounds eminently sensible. In that case, the doc bug becomes: http://www.mysql.com/doc/F/L/FLUSH.html which says: [[[You can also access each of the commands shown above with the mysqladmin utility, using the flush-hosts, flush-logs, reload, or flush-tables commands.]]]

Bug in embedded libmysqld library or configuration problem?

From: Niksa Jurinovic [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: Bug in embedded libmysqld library or configuration problem Description: mysql-4.0.1-alpha, Linux Mandrake 8.1, Kernel 2.4.8 I have configured and compiled source code as always, without any problems. 'make test' was

How can I select in multi table

In my catalogs, there are many tables with the same structure. Every table is very large, several million records and about 1 GB size. It is impossible to merge them into single one. How can I select in all of them at the same time but not select * from table1 where ... then select * from

Re: How can I select in multi table

On Thu, 27 Dec 2001 11:19:18 +0800, cbsly [EMAIL PROTECTED] wrote: | In my catalogs, there are many tables with the same structure. Every table is very |large, several | million records and about 1 GB size. It is impossible to merge them into single one. | How can I select in all of them at the

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

Dear Stavros, Durga and all, Thanks for Stavros and Durga reply my email so fast. Durga I can't find a file mysql.sock from /var/lib/mysql directory and I restart the server it still don't exist. I may add more information form my MySQL server to help all of you to solve my problem. OS: Sun

error message

Hello! I use MySQL 3.23.37 for made small base with access by LAN trough Apache PHP. I receive next message: File 'c:\mysql\\share\charsets\?.conf' not found (Errorcode: 2) Caracter set '#14' in not a compiled character set and not specified in the 'c:\\mysql\\share\charsets\Index' file This

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

On Thu, 27 Dec 2001 12:00:08 +0800, Kevin Chan [EMAIL PROTECTED] wrote: [...] | # ./bin/mysql | ERROR 2002: Can't connect to local MySQL server through socket | 'path-for-socket-file' (2) [...] You may want to edit your my.cnf file to have the path to the socket file. :-) Thanks, Michael --

RE: Is this possible with MySQL?

* Stig Nørgaard Jepsen select distinct t1.textkey, if(t2.textid,t2.languageid,t3.languageid) as languageid, if(t2.textid,t2.textid,t3.textid) as textid, if(t2.textid,t2.textvalue,t3.textvalue) as textvalue from texts t1 left join texts t2 on t2.textkey=t1.textkey and

Re: Question of a Beginner

On Wed, Dec 26, 2001 at 05:34:34PM -0500, Jose Villanueva wrote: I'm a beginner in MYSQL, please can anyone tell me the right command in ORACLE equivalent to the EXEC SP of SQL Server, i'm working with ORACLE SP, i will apreciate any hepl, thanks. Sir, I'm confused. If you want the ORACLE

Re: binary varchar fields seems non-binary

Just my two cents: have you tried the following? SELECT nev FROM hosoktest WHERE (nev = 'Pokember') OR (nev = \ 'pokember'); Bogdan Barnabas BONA wrote: If I execute the following select: SELECT nev FROM hosoktest WHERE nev = 'pokember' OR nev = \

Re: SQL sintax problem of a biginner

On Thu, Dec 27, 2001 at 12:11:17AM +0100, [EMAIL PROTECTED] wrote: Hi everybody, I really hope that there will be somebody who will waste a bit of his time helping a very, very beginner. I have a front-end database in MS Access that gets data from a MySQL back-end. When I

General error: Got error -30996 from table handler

Hi, We have an application that uses JBoss 2.4.3 as an app server and mysql 3.23.36 as the database. All the database tables are of type BerkeleyDB . All our DB updations are done within a session bean, our application executes approx. 1000 db updations per minute for a period of 10 minutes.

Case Sensitivity in MySQL

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 case-sensitive in

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

Dear Michael and all, Hi Michael, do you mind to tell me where is the location of the my.cnf file in my michane (Sun Solaris2.8) beacuse I can't find it ? And what I should change on that file to solve the problem? ... thanks ! Thanks and regards, Kevin Chan Michael Brunson Wrote Sent:

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

Kevin Chan wrote: Dear Michael and all, Hi Michael, do you mind to tell me where is the location of the my.cnf file in my michane (Sun Solaris2.8) beacuse I can't find it ? And what I should change on that file to solve the problem? ... thanks ! Thanks and regards, Kevin Chan Michael

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

Dear Phillip and all, I am installing from Binary Distribution and just follow the INSTALL-BINARY file to install. I just did all the steps below: shell groupadd mysql shell useradd -g mysql mysql shell cd /usr/local shell gunzip /path/to/mysql-VERSION-OS.tar.gz | tar xvf - shell ln -s

Re: binary varchar fields seems non-binary

It works the way you want with this data when your query is written: SELECT nev FROM hosoktest WHERE nev = ('pokember' OR 'Pokember'); Regards, Doug On Thu, 27 Dec 2001 01:33:57 +0100, Barnabas BONA wrote: If I execute the following select: SELECT nev FROM hosoktest WHERE

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

Hello look at the permitions of mysql data directory. - Original Message - From: Kevin Chan [EMAIL PROTECTED] To: Phillip B. Bruce [EMAIL PROTECTED] Cc: Michael Brunson [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Thursday, December 27, 2001 7:49 AM Subject:

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

Dear Marek and all, The directory for MySQL (/etc/local)as below: lrwxrwxrwx 1 root other 34 Dec 5 16:32 mysql - mysql-3.23.46-sun-solaris2.8-sparc drwxr-xr-x 13 root mysql512 Dec 5 16:30 mysql-3.23.46-sun-solaris2.8-sparc Thanks and regards, Kevin Chan Marek

Re: Stored Procedure

- Original Message - From: Shankar Unni [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, December 27, 2001 12:57 AM Subject: Re: Stored Procedure [ obfilter: mysql database ] Sinisa Milivojevic wrote: Cafetechno writes: When The Stored Procedure Capability will be

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 case-sensitive in

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

Dear Marek and all, I only can find one file end with err (sune250.trasy.com.err) and I can't find any error message on that file after I run the following command: # ./bin/mysql ERROR 2002: Can't connect to local MySQL server through socket 'path-for-socket-file' (2) # # pwd

Re: Stored Procedure

So sprach »Fredrick Bartlett« am 2001-12-26 um 07:30:44 -0800 : Explain how to configure the handlers for myperl under the win32 platform... I don't know. filter: sql Alexander Skwar -- How to quote: http://learn.to/quote (german) http://quote.6x.to (english) Homepage: