how to upgrade mysql from 3.20 to 3.23

Dear All, I want to upgrade my mysql ver 3.20.32a-3 on my Red Hat linux 6.2 machine to mysql 3.23 version. Presently i have glib-1.2.6-3 and libc-5.3.12-3.1. How can i upgrade to version 3.23. thanks in advance sankalap -- MySQL General Mailing List For list archives:

Re: how to upgrade mysql from 3.20 to 3.23

Dear All, I want to upgrade my mysql ver 3.20.32a-3 on my Red Hat linux 6.2 machine to mysql 3.23 version. Presently i have glib-1.2.6-3 and libc-5.3.12-3.1. How can i upgrade to version 3.23. thanks in advance sankalap -- MySQL General Mailing List For list

MySQL extensions in C

Hello, I read in the docs about the extensions but I didn't met any example. Please, if you could, give me a link or a site with extensions in C/C++ for MySQL. Best Regards, Iulian Teodosiu Economist/software developer Falticeni Municipality -- MySQL General Mailing List For list archives:

how to 'tell' the select what to omit

Hallo suppose you have a table with great number of columns (20 or 30), and you would like to specify every one but two or tree columns in a SELECT statement. Is there a way to specify only those two or tree columns for omission (which would be the 'short' way to do the job) instead of

Problem reading my.cnf

Hi, I have just upgraded mysql server version from 4.0.13 to 4.0.14, from FreeBSD 5.1 ports collection. Before upgrade mysql command line client could read password from /etc/my.cnf file and I could use mysql without supplying -p option. But after upgrade it could read password only up to #

How to Ask Questions the Smart Way...

Maybe the weed has got me high right now, but here is something some of you on this list may find funny, others may find this useful. This is not spam, this is actually a good manual you should all read: http://catb.org/~esr/faqs/smart-questions.html Good Reading. -- MySQL General Mailing

Re: Problem reading my.cnf

Try to not use # if you want the password to be in my.cnf file. The # is for comments if my.cnf file. - Original Message - From: Ganbold [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, August 04, 2003 11:08 AM Subject: Problem reading my.cnf Hi, I have just upgraded mysql

Re: How to Ask Questions the Smart Way...

Ralph, Yes, indeed. It's a good idea to read this book. Iulian - Original Message - From: Ralph Guzman [EMAIL PROTECTED] To: mySQL Mailing List [EMAIL PROTECTED] Sent: Monday, August 04, 2003 11:13 AM Subject: How to Ask Questions the Smart Way... Maybe the weed has got me high right

Re: Problem reading my.cnf

Hi, It was Ok in previous version of mysql. Why they changed ? Thanks anyway. Ganbold At 11:21 AM 8/4/2003 +0300, you wrote: Try to not use # if you want the password to be in my.cnf file. The # is for comments if my.cnf file. - Original Message - From: Ganbold [EMAIL PROTECTED] To:

RE: Problem reading my.cnf

Ganbold Because the bug that did not recognise the comment character in the password line has been fixed? Andy -Original Message- From: Ganbold [mailto:[EMAIL PROTECTED] Sent: 04 August 2003 09:51 To: Primaria Falticeni Cc: [EMAIL PROTECTED] Subject: Re: Problem reading my.cnf

RE: Problem reading my.cnf

Try to quote the password: password= 'test#istest$' or password= test#istest$ Not sure if MySQL is doing command expansion. If yous, use the first example, if not, it should not matter. Cheers /rudy -Original Message- From: Andy Eastham [mailto:[EMAIL PROTECTED] Sent: maandag

replication question

HI all, Is it possible to perform replication as follow? HOW? master (innodb) ---replication--- slave (myisam) Rgds, Ringo -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: replication question

Replication just executes the commands in the binary log (i.e INSERT, UPDATE, DELETE, ...). So if you make sure that you do not issue a DDL for creation/altering in the master DB, everything should work fine. However, I would advice against it (it is not a supported feature, but a trick) Cheers

Convert date from .txt file

How do you convert a date dd/mm/ from a .txt file into mysql date format when using LOAD DATA INFILE ? __ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com -- MySQL General Mailing List For list

RE: Convert date from .txt file

[snip] How do you convert a date dd/mm/ from a .txt file into mysql date format when using LOAD DATA INFILE ? [/snip] LOAD DATA INFILE cannot do the conversion on-the-fly. You could use a scripting language (sed, awk,etc.) to read and convert the dates. HTH! -- MySQL General Mailing List

RE: Convert date from .txt file

Or load the date into a column date_str and then convert and copy the date into a column date AFTER loading. Cheers /rudy ps: I already posted a function of how to convert this date format into a MySQL date format somewhere on this list (prev month I think) -Original Message- From: Jay

Security related! Not possible to hide table structure. I couldn't find..... ?

Hello, Think that we have a database named DATABASE1, and table named TABLE1, and fields named FIELD1, FIELD1,FIELD2,FIELD3,FIELD4 You want to give a specific permission to a user named USER1 For ex, you give only SELECT permission to USER1 for FIELD1 and FIELD4 in TABLE1 and DATABASE1.

RE: Security related! Not possible to hide table structure. I couldn't find..... ?

If you give access rights to a user on a DB, he will always be able to see the table structure. This is how it is implemented in MySQL (which does not mean that I like this). Cheers /rudy -Original Message- From: QWERTY [mailto:[EMAIL PROTECTED] Sent: maandag 4 augustus 2003

Re: Creating Grant Tables on WinXP

[EMAIL PROTECTED] wrote: I've installed 4.0.13 on a WinXP system. The service starts and stops just fine, but I cannot connect to the server, nor can I ping the 3306 port. I think the problem may be failure to complete the post-installation processing. The doc says to run

Re: how to 'tell' the select what to omit

Miroslav I. [EMAIL PROTECTED] wrote: suppose you have a table with great number of columns (20 or 30), and you would like to specify every one but two or tree columns in a SELECT statement. Is there a way to specify only those two or tree columns for omission (which would be the 'short'

Extensions for MySQL in C not MySQL API

Hello, I want to make some extensions for MySQL in C/C++. Please give me some samples. I read the documentation but I didn't find anything about this. Thanks Anticipated, Iulian -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:

Re: max_connections doesn't change

Jan Josefowicz [EMAIL PROTECTED] wrote: I'm trying to change the value of max_connections variable but mysqld doesn't accept that. I use mysql 3.23.54 and my config file /etc/my.cnf looks like: [mysql.server] ... ... set-variable max_connections=200 After a newstart of mysqld the

Error after upgrading to 4.1.0-alpha-max-debug LibMySQL.dll missing

Hello programmers this is my path, C:\mysql\binpath PATH=C:\WINNT\system32;C:\WINNT;C:\WINNT\System32\Wbem;C:\mysql\bin After installing 4.1.0-alpha-max-debug I try to start winmysqladmin.exe Then I get this error, === Die dynamic link library libmysql.dll wurde nicht im angegebenen Pfad

Re: Error after upgrading to 4.1.0-alpha-max-debug LibMySQL.dll missing

At 16:06 4/8/2003 +0200, Morten Gulbrandsen wrote: Hi, Just copy c:\mysql\lib\opt\libmysql.dll into the c:\mysql\bin directory. When is final release of 4.1.0 scheduled please ? I highly appreciate and thank you all eternally for Enabling nested selects like SELECT article, dealer, price FROM

Replication and LOAD DATA INFILE MySQL Max 3.23.56-1

Hello, After recently replicating using the stop databases and copy innodb and mysql files method, things were fine... Until the slave thread stopped complaining about duplicate rows after one of our developers did a LOAD DATA INFILE operation on the master. Unfortunately the insert's are into

MySQL, IIS and PHP

Hi all I've just recoded a website in PHP from ASP, running off IIS 5. It has been tested by a dozen users over the weekend, but now I have put it live the CPU utilisation is up at 100%, mainly swallowed up by mysql-nt.exe. I wondered if anyone could offer any advice as to why this could be

table error 127

I have mysql setup on two computers with identical databases. When I run a group of queries on the one computer I get back an error 127 which I checked on an it appears to be a table corruption error. On the other computer, the queries run fine. Since I had all the data for the table in

Open Source Software Survey

Dear MySQL Contributors, I am studying for a Master's degree with Henley Management College in the UK, and in the past have used a variety of Open Source Software. As part of my course I am conducting a survey in an attempt to identify the critical success factors for Open Source projects. If

SubQuery bug in 4.1

Hi all, I have two tables CREATE TABLE main ( ID int not null, Value int ); CREATE TABLE sub ( mainID int not null, KeyDate date not null, SubValue int not null ); I want the Value field in the main table to be set to the latest SubValue in the sub table. I suppose this syntax should

Re: SubQuery bug in 4.1

Daniel Kiss writes: Hi all, I have two tables CREATE TABLE main ( ID int not null, Value int ); CREATE TABLE sub ( mainID int not null, KeyDate date not null, SubValue int not null ); I want the Value field in the main table to be set to the latest SubValue

Re: SubQuery bug in 4.1

Surely this will just work? update main,sub set main.Value = sub.subValue where main.id=sub.mainid; Or have I misunderstood what you are wanting? -- Mark - Original Message - From: Daniel Kiss [EMAIL PROTECTED] To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Monday, August 04, 2003 4:09

MySQL extension

Hello, Would you help me with some samples for making a MySQL extension in C/C++? Please! Thanks Anticipated, Iulian -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: SubQuery bug in 4.1

Your primary query has no where clause, so you are setting all Value to a value from a random record for the most recent date. Hardly looks like a 'bug' to me. And why the cross post? Daniel Kiss wrote: Hi all, I have two tables CREATE TABLE main ( ID int not null, Value int ); CREATE

RE: Books advice

At 21:04 -0400 7/31/03, Asif Iqbal wrote: I just ordered this book MySQL The definitive guide to using, programming, and administering MySQL 4 by Paul Dubois I found it more technical than MySQL cook book by Paul Dubois Comparison information: http://www.kitebird.com/mysql-book-comparison.php

Re: Extensions for MySQL in C not MySQL API

At 16:40 +0300 8/4/03, Primaria Falticeni wrote: Hello, I want to make some extensions for MySQL in C/C++. Please give me some samples. I read the documentation but I didn't find anything about this. Thanks Anticipated, Iulian What do you mean by extension? If you mean user-defined function, the

Unable to ADD databases

Hello All - I'm just started the process of learning MySQL and databases in general. I just bought the book 'MySQL' written by Paul DuBois, who I gather is really active in this community. Anyhow.. Here's the problem that I'm having. mysql GRANT ALL ON sampdb.* TO 'sampadm'@'localhost'

Re: table error 127

Jonathan Patton wrote: I have mysql setup on two computers with identical databases. When I run a group of queries on the one computer I get back an error 127 which I checked on an it appears to be a table corruption error. On the other computer, the queries run fine. Since I had all the

RE: Books advice

Just to drop my $.02 in on this.. I started reading the 1st version of Pauls' MySQL book online a week or so back using my account over at 'Safari', once I read a little and decided that I was genuinely interested in this MySQL 'thing', I went over to Barnes and Noble with intentions of getting a

Re: Unable to ADD databases

Jeffery C. Baldwin wrote: Hello All - I'm just started the process of learning MySQL and databases in general. I just bought the book 'MySQL' written by Paul DuBois, who I gather is really active in this community. Anyhow.. Here's the problem that I'm having. mysql GRANT ALL ON

RE: Unable to ADD databases

A GEEZ! I apologize to all, I did not take the time to 'think' before I wrote. Sorry for the waste of bandwidth :-) And thank you to Leonardo for the reply. Jeff -Original Message- From: Leonardo Rodrigues Magalhães [mailto:[EMAIL PROTECTED] Sent: Monday, August 04, 2003 12:21

RE: Books advice

At 12:14 -0400 8/4/03, Jeffery C. Baldwin wrote: Just to drop my $.02 in on this.. I started reading the 1st version of Pauls' MySQL book online a week or so back using my account over at 'Safari', once I read a little and decided that I was genuinely interested in this MySQL 'thing', I went over

Re: Unable to ADD databases

On 4 Aug 2003 at 12:06, Jeffery C. Baldwin wrote: Anyone notice the problem? Even though I get no error.. the sampdb is not being greated. When are you attempting to create it? All you've shown is a GRANT statement, which creates *permissions* for the database (and works even if the

Re: Adv. Mysql query

- Original Message - From: Andy Jackman [EMAIL PROTECTED] To: Mattias Larsson [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Saturday, August 02, 2003 4:23 PM Subject: Re: Adv. Mysql query Mattias, It may not be such a good idea to store the 6 items in 1 record. An alternative

Re: Extensions for MySQL in C not MySQL API

Yes, indeed! Sorry for mistake. I'd like to know functions in MySQL I can use for replacing. For example: in the docs it's writing about xxx_reset This function is called when MySQL finds the first row in a new group. . I need the description of such kind of the functions which can be wrapped and

Re: Security related! Not possible to hide table structure. I couldn't find..... ?

what is so bad at seeing the table structure? i mean to work with the table, you need to know the fields and their types to avoid syntax errors. and what should happen on a SELECT * FROM...? do you want to see nothing, because it would let the user know about the structure, or all fields, as

Re: RE: Books advice

Paul's book is long, but like good code, it's modular, so the length isn't an issue. From: Jeffery C. Baldwin [EMAIL PROTECTED] Date: 2003/08/04 Mon AM 11:14:29 CDT To: 'Paul DuBois' [EMAIL PROTECTED], 'Asif Iqbal' [EMAIL PROTECTED], 'Ralph Guzman' [EMAIL PROTECTED] CC: 'Fawad

RE: Order by umm OR?

Hey Kevin, Ya I know thousands of items in the IN clause is not a good way, and it takes a while but from all the other process I've tried it has been actually the quickest (join for instance takes longer on my tests). Like yourself though I'm quiet clueless on what another way to do this might

Re: table error 127

I have been getting this type of error ever since I upgraded from MySQL 3 to 4. I actually have set up a cron to check/repair tables hourly because of this. The following diagnoses have been suggested, but I would bet it's an obscure MySQL bug: 1. Kernel 2.4.18 IO problem 2. Another shared

Re: table error 127

On Monday 04 August 2003 02:10 pm, Richard Gabriel wrote: I have been getting this type of error ever since I upgraded from MySQL 3 to 4. I actually have set up a cron to check/repair tables hourly because of this. The following diagnoses have been suggested, but I would bet it's an obscure

Re: SubQuery bug in 4.1

Mark, I agree there is no reason for the sub-select. I'd make one change in response to the original request - asking for the most recent item. Take Mark's statement and suffix AND m.KeyDate = MAX(m.KeyDate); to the last WHERE statement (see example). UPDATE main m, sub s SET m.Value =

File Permission

Greetings all I am not able to GRANT file permission to users. All permissions end up being issued with FILE being left out. What could I be missing? I running 3.23.53 on Mac OS 10.2. Thank you. - David Scott -- MySQL General Mailing List For list archives:

doubts

Want to chat instantly with your online friends? Get the FREE Yahoo! Messenger http://uk.messenger.yahoo.com/ Sir, My name is Reji.Iam studying for a master degree in computer applications.Iam new to mySQL.I

Re: File Permission

Since you don't show your grant statement, it is difficult tell you what the problem is. Since FILE is a global permission you need to grant it on *.* not somedatabase.* David Scott wrote: Greetings all I am not able to GRANT file permission to users. All permissions end up being issued with

Query Help

I have a table that records connections from customers to our server. When there is a software problem with our customer's that have older versions of our software, it will dial our server constantly over and over again. I want to be able to detect this by having a query that does something like

Re: table error 127

Thanks walt. Actually I use mysqlcheck to check the databases. This can be safely run while the server is in use. Richard Gabriel Director of Technology, CoreSense Inc. (518) 306-3043 x3951 - Original Message - From: walt [EMAIL PROTECTED] To: Richard Gabriel [EMAIL PROTECTED];

RE: Query Help

So you want to group by the customer, but only show those gorupings with a count 5. That means you want to apply your restriction after the GROUP BY. Thus, the clause goes into the HAVING area. Try: Select count(*), cust.id from cust where cust.time UNIX_TIMESTAMP(DATE_SUB(NOW(),interval 1

Re: Query Cache slow downs?

Hey There, Our MySQL database server is: 1. Sun Ultra Enterprise 4500 System Chassis with SBus I/O 4. 6 System Boards, each with 2 UltraSPARC II 400 mhz CPU's and 2 GB's of memory (12 CPU, 12 GB memory) 2. 1 SBus I/O board, with SCSI-2 and dual fibre channel interfaces on it. 3. The SCSI-2

RE: Query Help

Thanks, that did it! Jeff -Original Message- From: Kevin Fries [mailto:[EMAIL PROTECTED] Sent: Monday, August 04, 2003 3:05 PM To: Jeff McKeon; [EMAIL PROTECTED] Subject: RE: Query Help So you want to group by the customer, but only show those gorupings with a count 5.

Re: File Permission

Thank you Gerald. That was the problem. I thought I read that FILE permission could not be set to a specific table so I was using somedatabase.*. David Scott On Monday, August 4, 2003, at 11:42 AM, gerald_clark wrote: Since you don't show your grant statement, it is difficult tell

Re: Searching on Two Keys with OR?

Joshua, Joshua Spoerri wrote: Which version is targetted for optimization of OR searching on two keys, that is, select * from sometable where f1 = 123 or f2 = 123, as described in http://www.mysql.com/doc/en/Searching_on_two_keys.html ? As described there MySQL can use only one index per table.

Check table script

Hey, having trouble running mysqlcheck from a script. Running 4.0.13 on Linux. I can run the following command: /usr/local/mysql/bin/mysqlcheck -u root -p -A -a -m -v --auto-repair /var/log/mysql/check_tables.log from the command line, plug in the password at the prompt, and everything

benchmarks

At the conference a few months ago, the mysql team said that the benchmarks they where running would be published here http://www.mysql.com/benchmarks but it doesn't look like this is the link. Basically I'm trying to figure out what a saturation level is for mysql when it has 2 2.4Ghz Intel

books advice

Dear all, Thank you very much for all your responses. I have settled on the at least one book, SQL Queries for Mere Mortals: A Hands-On Guide to Data Manipulation in SQL by Michael J. Hernandez, John L. Viescas. I would, however, ask Paul to recommend one from his list of numerous titles,

Re: MySQL, IIS and PHP

Gary Broughton wrote: Hi all I've just recoded a website in PHP from ASP, running off IIS 5. It has been tested by a dozen users over the weekend, but now I have put it live the CPU utilisation is up at 100%, mainly swallowed up by mysql-nt.exe. I wondered if anyone could offer any advice as

Re: books advice

At 21:47 +0100 8/4/03, Fawad Siddiqui wrote: Dear all, Thank you very much for all your responses. I have settled on the at least one book, SQL Queries for Mere Mortals: A Hands-On Guide to Data Manipulation in SQL by Michael J. Hernandez, John L. Viescas. I would, however, ask Paul to

Re: Check table script

Jean Hagen wrote: Hey, having trouble running mysqlcheck from a script. Running 4.0.13 on Linux. I can run the following command: /usr/local/mysql/bin/mysqlcheck -u root -p -A -a -m -v --auto-repair /var/log/mysql/check_tables.log from the command line, plug in the password at the

Re: Check table script

At 15:14 -0500 8/4/03, Jean Hagen wrote: Hey, having trouble running mysqlcheck from a script. Running 4.0.13 on Linux. I can run the following command: /usr/local/mysql/bin/mysqlcheck -u root -p -A -a -m -v --auto-repair /var/log/mysql/check_tables.log from the command line, plug in the

Re: Check table script

At 16:57 -0400 8/4/03, walt wrote: Jean Hagen wrote: Hey, having trouble running mysqlcheck from a script. Running 4.0.13 on Linux. I can run the following command: /usr/local/mysql/bin/mysqlcheck -u root -p -A -a -m -v --auto-repair /var/log/mysql/check_tables.log from the command line,

Can't start up - access denied to root

I am fairly much a beginner and have probably done something wrong but version 4.0.12 will not let me in. I have been using MySQL (via MySQL Front and PHPMyAdmin as interfaces usually) on a Windows ME PC with Apache, all just for learning databases, SQL and PHP. I learn slowly since I have to do

Message

I am just learning mysql and I'm trying to write a cgi to update the database from a form. Also just learning Perl. I have the following script started that is called by an HTML form. I get the follwing message when I execute it. Where can I find the message descriptions. DBI::st=HASH(0x1b31f28)

Re: Searching on Two Keys with OR?

That doesn't seem to work (and not with bigger table either): mysql create temporary table x (y int, z int, index (y), index(z)); insert into x values (1,2), (3,4), (5,6); explain select * from x where y = 1 or z = 1; Query OK, 0 rows affected (0.00 sec) Query OK, 3 rows affected (0.00 sec)

Re: Searching on Two Keys with OR?

Forgive me, that example is no good. Oddly, it works, but the following does not: mysql create temporary table x (y int, z int, q int, index (y, z)); insert into x values (1,2,3), (3,4,5), (5,6,7); explain select * from x where y = 1 or z = 1; Query OK, 0 rows affected (0.00 sec) Query OK, 3

Re: Searching on Two Keys with OR?

Have you tried using the UNION statement? That worked great for me. So, something like: (select * from sometable where f1 = 123) UNION (select * from sometable where f2 = 123) ? -- Rudi Benkovic [EMAIL PROTECTED] -- MySQL General Mailing List For list archives:

Re: Books advice

Jeff, thanks for our .02. I'm about done with my second SQL book so after reading your words the company just bought mePauls Mysql book. Thanks for your opinion. SJohnson On Mon, 4 Aug 2003 12:14:29 -0400 Jeffery C. Baldwin wrote: Just to drop my $.02 in on this.. I started reading the 1st

post install of 4.0 complications

Hello- I just installed mySql 4.0.14-0 onto my redhat 9.0 based laptop. Everything works fine except that there are ten copies of mysqld running. I have removed the /etc/my.cnf file, changed the file, restored the file and nothing changes the number of daemons running. Another guy I worked

Fw: table error 127

Even though we don't know what exact query produces this, is there a way to raise it up to the MySQL team to take a look at? It seems to be more than a random occurrence. Thanks. Richard Gabriel Director of Technology, CoreSense Inc. (518) 306-3043 x3951 - Original Message - From: