Re: 4.0.20 WINDOWS VERSION

2004-05-24 Thread Victoria Reznichenko
Massimo Petrini [EMAIL PROTECTED] wrote: When it will be avalaible to download ? It will be available in a few days. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/

4.0.20 WINDOWS VERSION

2004-05-22 Thread Massimo Petrini
When it will be avalaible to download ? regards massimo - Massimo Petrini c/o Omt spa Via Ferrero 67/a 10090 Cascine Vica (TO) Tel.+39 011 9505334 Fax +39 011 9575474 E-mail [EMAIL PROTECTED] -- MySQL General Mailing List For

AS error with version 4.0.18-standard

2004-05-22 Thread Aaron Wolski
Hi all, Have a query that used to work on one server but then MYSQL version was upgraded and now it no longer works. Here's the query: SELECT *, SUM(quantity)*100/ AS percentage FROM CartTable WHERE company ='1' AND submitted='1' AND dateinserted='946702800' AND dateinserted='1085247047

Re: AS error with version 4.0.18-standard

2004-05-22 Thread Michael Stassen
server but then MYSQL version was upgraded and now it no longer works. Here's the query: SELECT *, SUM(quantity)*100/ AS percentage FROM CartTable WHERE company ='1' AND submitted='1' AND dateinserted='946702800' AND dateinserted='1085247047' AND product_index='148' GROUP BY product_index,colour,size

Backups with version 4.1

2004-05-17 Thread Mauricio Pellegrini
Hi I'm using, Mysql version 4.1.1 with InnoDB under SuSE linux 8.2 I don't know if this is the right place to ask. If not please point me in the right direction. I'm performing nightly backups of the datadir. So my backups include a database and the Mysql databases themselves ( also I think

Re: Backups with version 4.1

2004-05-17 Thread William R. Mussatto
Mauricio Pellegrini said: Hi I'm using, Mysql version 4.1.1 with InnoDB under SuSE linux 8.2 I don't know if this is the right place to ask. If not please point me in the right direction. I'm performing nightly backups of the datadir. So my backups include a database and the Mysql databases

Re: Documentation on character sets for version 4.0.17

2004-05-05 Thread Nils Valentin
Hi David, (B (BThank you for the detailed description. That certainly makes things easier to (Bargue now ;-). (B (BO.K Where to start ? (B (BFirst, as you know in version 4.0 you can basically set the character sets (Bonly for server and client side (not for DB, table, columns

Re: Documentation on character sets for version 4.0.17

2004-05-04 Thread Victoria Reznichenko
David Jourard [EMAIL PROTECTED] wrote: I got the 4.0.17 documentation but when it discusses character sets it discusses this topic wrt 4.1 Where can I find documentation specifically in regards to the production version on how to work with, store, and search asian character sets

Re: Documentation on character sets for version 4.0.17

2004-05-04 Thread David Jourard
version on how to work with, store, and search asian character sets specifically Japanese. In version 4.0.17 you should specify character set with --default-character-set option. For Japanese language take a look at sjis and ujis character sets: http://dev.mysql.com/doc/mysql/en

Re: Documentation on character sets for version 4.0.17

2004-05-04 Thread Nils Valentin
/04 +0300, Victoria Reznichenko wrote: (B David Jourard [EMAIL PROTECTED] wrote: (B I got the 4.0.17 documentation but when it discusses character sets it (B discusses this topic wrt 4.1 (B (B Where can I find documentation specifically in regards to the (B production version on how

Re: Documentation on character sets for version 4.0.17

2004-05-04 Thread David Jourard
to set this up for this version not 4.1 From your documentation I gather I need to tell the server what character set to use and also about data coming from and going to the client. My problem is I'm not too sure how to start. Here is the data flow: Storing Data 1. web page (uses

Help with search on Japanese and version 4.015

2004-05-03 Thread David Jourard
Hi, I'm implementing a search on fields some using the latin character set and others the Japanese character set; however because its virtually hosted I'm limited to using mysql 4.015 Is the documentation for this version online. I tried to find but could only get for the latest version which

Documentation on character sets for version 4.0.17

2004-05-03 Thread David Jourard
Hi, I got the 4.0.17 documentation but when it discusses character sets it discusses this topic wrt 4.1 Where can I find documentation specifically in regards to the production version on how to work with, store, and search asian character sets specifically Japanese. Thank-you David Jrt; x

Still getting problems creating a new super user on version 4 under WinXP

2004-04-27 Thread Jeff Ritchie
GRANT ALL PRIVILEGES ON *.* TO 'username'@'localhost' IDENTIFIED BY 'password' WITH GRANT OPTION; Excuted in a MySQL console returns the following SQL error ERROR 1064:you have an error in your SQL syntax. check the manual that corresponds to you MYSQL server version for the right syntax to use

Re: Still getting problems creating a new super user on version 4 under WinXP

2004-04-27 Thread Lou Olsten
problems creating a new super user on version 4 under WinXP GRANT ALL PRIVILEGES ON *.* TO 'username'@'localhost' IDENTIFIED BY 'password' WITH GRANT OPTION; Excuted in a MySQL console returns the following SQL error ERROR 1064:you have an error in your SQL syntax. check the manual that corresponds

Mysqlclient is missing from binary version Aix 5.2

2004-04-20 Thread erricharl
Hello. I have installed binary version 4.0 for aix 5.2 from www.mysql.com and when i try to compile cyrus-sasl with mysql support it don't find mysqlclient libraries. I use --with-mysql=/usr/local/mysql/ to build but i get: checking for mysql_select_db in -lmysqlclient... no configure: WARNING

Getting an older version of MySQL

2004-04-19 Thread Lou Olsten
Hi, I'm currently running some instances of 4.0.18. I read the following in the docs: Beginning with MySQL 4.0.3, many server system variables are dynamic and can be set at runtime using SET GLOBAL or SET SESSION. You can also select their values using SELECT. But when I look at the

RE: Getting an older version of MySQL

2004-04-19 Thread Chris
4.0.18 is the latest 4.0.x release. 4.0.3 4.0.9 4.0.10 4.0.18 4.0.3 != 4.0.30 -Original Message- From: Lou Olsten [mailto:[EMAIL PROTECTED] Sent: Monday, April 19, 2004 1:44 PM To: [EMAIL PROTECTED] Subject: Getting an older version of MySQL Hi, I'm currently running some

Re: Getting an older version of MySQL

2004-04-19 Thread Lou Olsten
Ah Ha! Thanks!!! Lou - Original Message - From: Chris [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, April 19, 2004 5:14 PM Subject: RE: Getting an older version of MySQL 4.0.18 is the latest 4.0.x release. 4.0.3 4.0.9 4.0.10 4.0.18 4.0.3 != 4.0.30 -Original

How to replace a installed mysql version?

2004-04-13 Thread Walter Andreas
Hi there, I am a bit confused. It is not clear to me that the version I am currently running is the one I compiled last. How can I check the date of compiling? In order to get more performance I did try to install mysql 4.0.18 with different configure commands, now I am not sure if the make

version 4.0 , 4.1 and 5.0

2004-04-07 Thread Saurabh Data
Dear users Can someone give me a brief description of version 4.0 , 4.1 and 5.0 The website says that 4.0 is a production release where as version 4.1 and 5.0 are alpha releases. I mainly want to know the difference between 4.1 and 5.0 . Why dhould one one 4.1 and not 5.0 and viceversa

Re: version 4.0 , 4.1 and 5.0

2004-04-07 Thread Paul DuBois
At 22:46 + 4/7/04, Saurabh Data wrote: Dear users Can someone give me a brief description of version 4.0 , 4.1 and 5.0 The website says that 4.0 is a production release where as version 4.1 and 5.0 are alpha releases. I mainly want to know the difference between 4.1 and 5.0 . Why dhould

Version 5.0 vs. 4.1

2004-04-06 Thread Yves Goergen
Just a short question: does MySQL version 5.0 contain all features of version 4.1? And will new additions to 4.1 also be implemented to 5.0 in the same step or may it take some time for both versions to be synchronous? -- Yves Goergen [EMAIL PROTECTED] -- MySQL General Mailing List For list

Re: Version 5.0 vs. 4.1

2004-04-06 Thread Victor Medina
Yves Goergen wrote: Just a short question: does MySQL version 5.0 contain all features of version 4.1? And will new additions to 4.1 also be implemented to 5.0 in the same step or may it take some time for both versions to be synchronous? generally yes

Compiling MySQL 4.1.1 For New OpenSSL Version

2004-03-27 Thread Robert L Cochran
them. This is because I had just upgraded that machine system to OpenSSL 0.9.7. (The *-shared-compat* RPM failed to install for the same reason.) So I downloaded and installed the source code RPM for MySQL 4.1.1. I changed the release number (as my only change to the SPEC file) in the version

(simple select) bug? version problem? or just bad SQL?

2004-03-22 Thread ryan
Hi, I am running this (simple?) query on mysql 3.23 : select * from clients_tb where active='on' AND first_name LIKE '%ja%' AND middle_name LIKE '%ja%' AND last_name LIKE '%ja%'; I know there are people in the table with: first name James last name James middle name Jacob etc but it does not

RE: (simple select) bug? version problem? or just bad SQL?

2004-03-22 Thread Jennifer Horne
can have 'ja' in them, use the OR. Jennifer Horne Panda Voice Systems Inc. 1.888.767.2632 ext 23 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Monday, March 22, 2004 9:41 AM To: [EMAIL PROTECTED] Subject: (simple select) bug? version problem? or just bad SQL

New version of sql-bench is available from BitKeeper

2004-03-16 Thread Peter Zaitsev
Dear MySQL users, MySQL benchmark team is proud to announce availability of the new version of sql-bench suite. It is currently available only in BitKeeper tree, named mysql-bench. This is still development release and we would really appreciate your testing, bug reports as well as comments

mySQL, mySQL Max and stored procedure support (version problem?)

2004-03-09 Thread Ivan Sergio Borgonovo
end as well as create procedure 'pippo' begin select 1 end and many other combination Is my syntax wrong? am I using the wrong version of mySQL to have SP support? Should I configure anything to have SP support? If I'm using the wrong version of mySQL which one has SP support

Re: mySQL, mySQL Max and stored procedure support (version problem?)

2004-03-09 Thread Martijn Tonies
Hi, I'm running: mysql Ver 12.21 Distrib 4.0.15, for suse-linux (i686) ps says I'm running mysql-max mysql21397 0.0 1.7 71216 16064 pts/8 S10:32 0:00 /usr/sbin/mysqld-max that *should* support stored procedures, shouldn't it? As far as I know, MySQL 5 support stored

Re: mySQL, mySQL Max and stored procedure support (version problem?)

2004-03-09 Thread Ivan Sergio Borgonovo
stored procedures, shouldn't it? As far as I know, MySQL 5 support stored procedures. But what about Max version? Docs are not crystal clear. While it is clearly stated that mySQL started to support SP from version 5, nothing is said about Max where docs just say it supports them

Re: mySQL, mySQL Max and stored procedure support (version problem?)

2004-03-09 Thread Victoria Reznichenko
/usr/sbin/mysqld-max that *should* support stored procedures, shouldn't it? As far as I know, MySQL 5 support stored procedures. But what about Max version? Docs are not crystal clear. While it is clearly stated that mySQL started to support SP from version 5, nothing is said about

Re: mySQL, mySQL Max and stored procedure support (version problem?)

2004-03-09 Thread Ivan Sergio Borgonovo
On Tue, 09 Mar 2004 12:36:30 +0200 Victoria Reznichenko [EMAIL PROTECTED] wrote: 5 is a number of version. MySQL-Max is a name of MySQL server, where Max means that this MySQL server supports InnoDB and BDB storage engines. So this make MaxDB another product Could anyone post a correct 5

An doubt about mysql version 4.0.x agains 4.1.x

2004-03-05 Thread Luiz Rafael Culik Guimaraes
Dear Friend an friend of mine told that the follow line bellow dont work with mysql version 4.0.x * Support for subqueries and derived tables This mean query like : SELECT A.* FROM (SELECT * FROM TESTE WHERE X = Y) A WHERE COL1 = 3 is this true, or mysql version 4.0.x work properly

Re: An doubt about mysql version 4.0.x agains 4.1.x

2004-03-05 Thread Victoria Reznichenko
Luiz Rafael Culik Guimaraes [EMAIL PROTECTED] wrote: Dear Friend an friend of mine told that the follow line bellow dont work with mysql version 4.0.x * Support for subqueries and derived tables This mean query like : SELECT A.* FROM (SELECT * FROM TESTE WHERE X = Y) A WHERE COL1 = 3

Mysql version 4.0.x ,LOCKS and Transactions

2004-03-02 Thread Luiz Rafael Culik Guimaraes
Dear Friends Talking with an friend, he told he that mysql 4.0.x has many problems with lock and transactions, is this true. All table that i use are innodb Regards Luiz -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:

Re: Mysql version 4.0.x ,LOCKS and Transactions

2004-03-02 Thread Daniel Kasak
Luiz Rafael Culik Guimaraes wrote: Dear Friends Talking with an friend, he told he that mysql 4.0.x has many problems with lock and transactions, is this true. All table that i use are innodb Regards Luiz I haven't had any problems. Did your friend elaborate? -- signature Daniel

Re: Mysql version 4.0.x ,LOCKS and Transactions

2004-03-02 Thread Sasha Pachev
Luiz Rafael Culik Guimaraes wrote: Dear Friends Talking with an friend, he told he that mysql 4.0.x has many problems with lock and transactions, is this true. All table that i use are innodb If you program a certain way, you can run into deadlocks which will result in rolled back transactions

Error 2013 when using mysql client, Version 12.21

2004-02-25 Thread Bungarz, Kai
Hi! When i'm using mysql client, version 12.21 - Distrib: 4.0.15 / windows, for queries or loading data, i always get an error 2013 (lost connection...) after 30 seconds and the connection breaks down. This doesn't happen, when i use the older version 11.16 , Distrib: 4.0.0 / windows

Re: Error 2013 when using mysql client, Version 12.21

2004-02-25 Thread Victoria Reznichenko
Bungarz, Kai [EMAIL PROTECTED] wrote: When i'm using mysql client, version 12.21 - Distrib: 4.0.15 / windows, for queries or loading data, i always get an error 2013 (lost connection...)=20 after 30 seconds and the connection breaks down. This doesn't happen, when i use the older version

No version info for libmysql.dll

2004-02-20 Thread Eric King
Currently I am working under a win32 environment developing applications to work with mysql. I have found some inconsistencies with the newer version of libmysql.dll versus older files that are supplied with your current package I have found that there is no version information tied

Re: MySQL version 4.1.x

2004-02-19 Thread Heikki Tuuri
Hi! - Original Message - From: Sasha Pachev [EMAIL PROTECTED] Newsgroups: mailing.database.myodbc Sent: Thursday, February 19, 2004 12:58 AM Subject: Re: MySQL version 4.1.x lee wrote: Anyone know when 4.1.x is scheduled for going Production? The website says it's currently

MySQL version 4.1.x

2004-02-18 Thread lee
Anyone know when 4.1.x is scheduled for going Production? The website says it's currently in Alpha. We'd like to upgrade past 4.0.18 if possible, to have the improved subqueries, etc. in 4.1.x. From http://www.mysql.com/doc/en/News-4.0.x.html # C.2 Changes in release 4.1.x (Alpha) *

Re: MySQL version 4.1.x

2004-02-18 Thread Sasha Pachev
lee wrote: Anyone know when 4.1.x is scheduled for going Production? The website says it's currently in Alpha. We'd like to upgrade past 4.0.18 if possible, to have the improved subqueries, etc. in 4.1.x. I would guess 4.1.1 is roughly as good on the old features as the latest 4.0. However, I

Version 4.1.2. when?

2004-02-09 Thread Mirza
Is there any info on when 4.1.2. is scheduled for relase? I am stucked in 4.1.1. with fulltext problem (bug #2490). Thanks for info, mirza -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Version 4.1.2. when?

2004-02-09 Thread Victoria Reznichenko
Mirza [EMAIL PROTECTED] wrote: Is there any info on when 4.1.2. is scheduled for relase? I am stucked in 4.1.1. with fulltext problem (bug #2490). Binaries of 4.1.2 will be available in a month. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is

Re: Version 4.1.2. when?

2004-02-09 Thread Heikki Tuuri
Mirza, - Original Message - From: Mirza [EMAIL PROTECTED] Newsgroups: mailing.database.myodbc Sent: Monday, February 09, 2004 1:54 PM Subject: Version 4.1.2. when? Is there any info on when 4.1.2. is scheduled for relase? I am stucked in 4.1.1. with fulltext problem (bug #2490

Re: Faster version of Movie Search

2004-02-05 Thread Brent Baisley
The IN and NOT IN searches (sub-queries) are not optimized in MySQL yet. You may find doing a JOIN or LEFT JOIN and filtering out NULL entries to be faster. I don't know where you getting your ids not to match from, so I can't really give you a good example. On Feb 4, 2004, at 11:04 PM, Mark

Re: Faster version of Movie Search

2004-02-05 Thread Adam
Mark, You're killing me because I can't visualize the source tables. A query like this is bread and butter, it shouldn't take to long to execute. Give me a better idea of the table structure and relationships between them. I try to help. Regards, Adam On Feb 4, 2004, at 11:04 PM, Mark wrote:

RE: Faster version of Movie Search

2004-02-05 Thread Mark
subcategories as Star Wars. - Mark -Original Message- From: Adam [mailto:[EMAIL PROTECTED] Sent: Thursday, February 05, 2004 7:37 AM To: Mark Cc: MySQL List Subject: Re: Faster version of Movie Search Mark, You're killing me because I can't visualize the source tables. A query like

Faster version of Movie Search

2004-02-04 Thread Mark
I have a site where members rate movies they've seen. I run a routine to recommend 5 titles based on movies they've given a max 5 rating. It's very slow, and I think a better MySQL query can speed it up. I'm running MySQL 3.23.54. Tables: movies (unique id plus movie info) subcats (movie id,

Japanese in version 4.0

2004-01-25 Thread David Jourard
Hi, I need to implement a search in japanese (and also in english). Can 4.0 accept japanese characters and sort them From the documentation I see that it supports: EUC-JP Japanese or Shift-JIS Japanese a. What are the differences btw the two. b. How do i get the mysql to implement the sort.

Version Usage Statistics

2004-01-22 Thread David Recordon
Hi, I was wondering if anyone has compiled, or found, statistics in terms of what percentage of installs are running which version of MySQL. The main concern would be version 3 versus version 4. We are currently deciding if it makes more sense to optimize our software to run on 3

mysql version 4.1.2

2004-01-19 Thread Kate Lapan Fox
I need MySQL version 4.1.2 build for Windows. Does anyone have a built version of it, or know when it will be released? Thanks for your help, Kate

Re: enum version info

2004-01-15 Thread Victoria Reznichenko
Matthew P Ryder [EMAIL PROTECTED] wrote: Quick question since I can't see to find version information online. What version was enum first supported under? It's supported from 3.21.0: http://www.mysql.com/doc/en/News-3.21.0.html -- For technical support contracts, goto https

Turning off caches in Version 3.2

2004-01-15 Thread Priyanka Gupta
Hi, I would like to turn off caches completely to do some performance testing. I have version 3.2 of the mysql server installed. Could you tell me how can I achieve this. Thanks, Priyanka _ There are now three new levels of MSN

enum version info

2004-01-14 Thread Matthew P Ryder
Hi, Quick question since I can't see to find version information online. What version was enum first supported under? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

mysql version problem

2004-01-02 Thread jamie murray
get client authentication protocol errors. If I run command line everything works perfect but as soon as perl or php try to access the 5.0 database it bombs. What dll is responsible for this so i'll know where to find it and make sure it is the appropriate version(I'm assuming at this point both

ZeosDBO 5.5 x 6.1.2 Version

2004-01-01 Thread Carlos J Souza
Dear friends, What version of zesdbo is more faster, 5.5 or 6.1.2? .NET Plataform is a future you believe in this new plataform? Regards. Carlos J Souza >From Brazil -- inline: C:\\Documents and Settings\\Administrator\\My Documents\\vectra.JPG

Re: ZeosDBO 5.5 x 6.1.2 Version

2004-01-01 Thread Luciano Barcaro
Hi Carlos, I tested zeos in my application and 6.1 seems to be faster, and much more simple. Happy new year From Brazil too ;) - Luciano Barcaro Depto. Informática - Laboratório Alvaro Carlos J Souza wrote: Dear friends, What version of zesdbo is more faster, 5.5 or 6.1.2? .NET Plataform

How Do I Do This In Version 3.23.56?

2003-12-31 Thread John Boshier
I have spent all day working on a PHP/MySQL system offline using MySQL version 4.0.15-nt. One particular SQL statement that works perfectly wouldn't work when I uploaded it to my web site. It seems that my ISP is using version 3.23.56, and I have written a SQL statement that will only work on 4.04

RE: How Do I Do This In Version 3.23.56?

2003-12-31 Thread David Mohorn
upper/lower, or all upper, etc. I'd double check all your case to ensure everything is identical. -Original Message- From: John Boshier [mailto:[EMAIL PROTECTED] Sent: Wednesday, December 31, 2003 12:36 PM To: [EMAIL PROTECTED] Subject: How Do I Do This In Version 3.23.56? I have spent

4.0.16 doesn't like my Berkley DB version!

2003-12-03 Thread Greg G
I get this from ../configure --with-berkeley-db=/usr/local/BerkeleyDB.3.3 checking for BerkeleyDB... supplied configure: error: didn't find valid BerkeleyDB: '/usr/local/BerkeleyDB.3.3' doesn't look like a BDB directory (invalid version 3.3.11 (must be version 3.2.3h or )) The configure script

Re: Two version

2003-12-02 Thread Egor Egorov
Arnoldus Th.J. Koeleman [EMAIL PROTECTED] wrote: I try to run to different version 3.23 4.0 with ome my.cnf file with different mysqld section but Only one is started. Anybody have any idea how to run two versions There are several ways and they are described at: http

Re: Version 4.1.1

2003-12-01 Thread Egor Egorov
Daniel Kiss [EMAIL PROTECTED] wrote: Does anyone know when MySQL 4.1.1 will be released? I was told that around November 15th. Well, it's almost December now. Soon. Probably this week. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored

Two version

2003-12-01 Thread Arnoldus Th.J. Koeleman
I try to run to different version 3.23 4.0 with ome my.cnf file with different mysqld section but Only one is started. Anybody have any idea how to run two versions

Re: Version 4.1.1

2003-12-01 Thread Nils Valentin
Hi Dan, for me its already the 2nd of December ;-) here in Tokyo. On Sunday 30 November 2003 22:43, Daniel Kiss wrote: Hi all, Does anyone know when MySQL 4.1.1 will be released? I was told that around November 15th. Well, it's almost December now. Thanks, Dan -- kind regards

Version 4.1.1

2003-11-30 Thread Daniel Kiss
Hi all, Does anyone know when MySQL 4.1.1 will be released? I was told that around November 15th. Well, it's almost December now. Thanks, Dan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

mysql installation error - version SUNW 1.2 not found

2003-11-25 Thread Manjunath . Sangappan
Description: I am trying to install mysql 4.0.16 on Solaris 8 on a i86pc. I created the user and group and everything went fine until I ran scripts/mysql_install_db. When I run the script I come acoss the error ld.so.1: ./bin/mysqld: fatal: librt.so.1: version `SUNW_1.2' not found

Re: Status shows wrong version number for server after upgrade

2003-11-22 Thread Paul DuBois
At 11:23 -0500 11/21/03, Mark Marshall wrote: Got it. mysqladmin version showed the 4.0.4 version. The Find is what clued me in. It did indeed find two mysqld executables. One in /usr/local/share/mysql/... and the other in /usr/local/mysql/share/mysql/... I copied the right one over the wrong

Re: Status shows wrong version number for server after upgrade

2003-11-21 Thread Thomas Spahni
Mark, what's the output of shell mysqladmin version It appears that you still have a version of 4.0.4-beta running. Try shell find /usr /sbin /bin -name mysqld to see whether there is more than one copy of mysqld hanging around. Regards, Thomas Spahni On Wed, 19 Nov 2003, Mark Marshall

Re: Status shows wrong version number for server after upgrade

2003-11-21 Thread Mark Marshall
Got it. mysqladmin version showed the 4.0.4 version. The Find is what clued me in. It did indeed find two mysqld executables. One in /usr/local/share/mysql/... and the other in /usr/local/mysql/share/mysql/... I copied the right one over the wrong one and after cleaning up a couple

Status shows wrong version number for server after upgrade

2003-11-19 Thread Mark Marshall
Current database: Current user: [EMAIL PROTECTED] SSL:Not in use Current pager: stdout Using outfile: '' Server version: 4.0.4-beta-log Protocol version: 10 Connection: Localhost via UNIX socket Client characterset:latin1 Server

Re: In which version of MySQL was ADD COMMENT added

2003-11-11 Thread Matt W
:42 PM Subject: In which version of MySQL was ADD COMMENT added Hello Can somebody tell me the exact version of MySQL from which the functionality of adding COMMENTS to columsn was added. Karam -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe

Subqueries in version 4.1

2003-11-10 Thread Wouter Coppieters
Hi We installed version 4.1.0-alpha-max-nt and try to run a query with a subquery and get the message [DB_BAS_LOCAL] ERROR 1235: This version of MySQL doesn't yet support 'LIMIT IN/ALL/ANY/SOME subquery' Are subqueries supporeted in 4.1 as is mentioned in the doc or not? Thanks in advance

Re: Subqueries in version 4.1

2003-11-10 Thread Egor Egorov
Wouter Coppieters [EMAIL PROTECTED] wrote: We installed version 4.1.0-alpha-max-nt and try to run a query with a subquery and get the message [DB_BAS_LOCAL] ERROR 1235: This version of MySQL doesn't yet support 'LIMIT IN/ALL/ANY/SOME subquery' Are subqueries supporeted in 4.1

In which version of MySQL was ADD COMMENT added

2003-11-10 Thread Karam Chand
Hello Can somebody tell me the exact version of MySQL from which the functionality of adding COMMENTS to columsn was added. Karam __ Do you Yahoo!? Protect your identity with Yahoo! Mail AddressGuard http://antispam.yahoo.com/whatsnewfree -- MySQL General

Installing 3.23.57 version without root privileges

2003-11-04 Thread Fernando
Hello, I need to install 3.23.57 version (i've downloaded the source code from the mysql page) in a system where i'm not the root. How can i install it in my account without getting errors while doing the make install? I get this message saying i can't write in the default folder because i do

Re: Installing 3.23.57 version without root privileges

2003-11-04 Thread Gabriel Guzman
On Tuesday 04 November 2003 10:49 am, Fernando wrote: Hello, I need to install 3.23.57 version (i've downloaded the source code from the mysql page) in a system where i'm not the root. How can i install it in my account without getting errors while doing the make install? I get this message

Re: Installing 3.23.57 version without root privileges

2003-11-04 Thread Michael Stassen
Use the --prefix option to tell configure where mysql should go. Add --prefix=$HOME/mysql to your configure options. You could change $HOME/mysql to any path where you have write permission. Michael Fernando wrote: Hello, I need to install 3.23.57 version (i've downloaded the source code

Changing rpm installation to binary version

2003-10-27 Thread Manjit Patel
Hello, I have been testing with an RPM distribution of MySQL version 4.0.15. Now that I have bought a licenced version how do I change over to use the binary (version 4.0.16) instead of the previously installed rpm version? Operating system: Linux Red Hat 7.3 Thanks Manjit This message

Re: Changing rpm installation to binary version

2003-10-27 Thread Nitin
you can either erase the previous installation and then install the newer one or simply upgrade the previous one. - Original Message - From: Manjit Patel [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, October 27, 2003 8:02 PM Subject: Changing rpm installation to binary version

RE: Changing rpm installation to binary version

2003-10-27 Thread Manjit Patel
I have successfully done this when both versions have been rpm files but how do I upgrade from an rpm to a binary. I have unpacked the binary file installed it but the previous version keeps being started. And when I try to erase the previous version it says it is not installed

Restore problem: Delete link points outside datafile at 0 - on MySQL 3.23.49, FreeBSD 4.4, PHP Version 4.3.0

2003-10-14 Thread Global Country of World Peace
When restoring tables from a backup, get: Op: repair // - this should always be restore according to manual Msg_type: info Msg_text: Delete link points outside datafile at 0 The datafiles seem to restore ok. Have rtfm'd, googled and mysql forumed, but to no avail. Is this something to worry

Somebody tried MySQL version 5 / Stored Procedures

2003-09-29 Thread Hans van Dalen
Hi all, We want to migrate to MySQL, and because of its speed, we want to use MyISAM db. I plan to write code as an alternate transaction mechanism. But I have read that MySQL version 5 supports Stored Procedures (PL/SQL like). In PL/SQL it is possible to use in your stored procedures

Re: Somebody tried MySQL version 5 / Stored Procedures

2003-09-29 Thread Jeremy Zawodny
On Mon, Sep 29, 2003 at 08:45:39AM +0200, Hans van Dalen wrote: Hi all, We want to migrate to MySQL, and because of its speed, we want to use MyISAM db. I plan to write code as an alternate transaction mechanism. But I have read that MySQL version 5 supports Stored Procedures (PL/SQL like

Re: Somebody tried MySQL version 5 / Stored Procedures

2003-09-29 Thread Hans van Dalen
to use MyISAM db. I plan to write code as an alternate transaction mechanism. But I have read that MySQL version 5 supports Stored Procedures (PL/SQL like). In PL/SQL it is possible to use in your stored procedures transactions (at the end (eg) of a stored procedure you can do a commit

Somebody tried MySQL version 5 / Stored Procedures

2003-09-26 Thread Hans van Dalen
Hi all, We want to migrate to MySQL, and because of its speed, we want to use MyISAM db. I plan to write code as an alternate transaction mechanism. But I have read that MySQL version 5 supports Stored Procedures (PL/SQL like). In PL/SQL it is possible to use in your stored procedures

Protocol mismatch, Server Version = 9 Client Version =

2003-09-07 Thread Karam Chand
Hello I have a C app that uses libmysql.dll provided with MySQL 4.1.0-max-nt distribution. I am trying to connect to a remote server running MySQL 3.23.47 and I get the error - Error No. 2007 Protocol mismatch, Server Version = 9 Client Version = 10 whenever I try to connect using

Error No. 2007 Protocol mismatch, Server Version = 9 Client Version = 10

2003-09-06 Thread Karam Chand
Hello I have a C app that uses libmysql.dll provided with MySQL 4.1.0-max-nt distribution. I am trying to connect to a remote server running MySQL 3.23.47 and I get the error - Error No. 2007 Protocol mismatch, Server Version = 9 Client Version = 10 whenever I try to connect using

php version

2003-09-05 Thread albert
What is the best version of PHP to use with MySQL on Win32 to interact with the MySQL database in web-enabled forms with submit button? Thank you for your help. Albert -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com

RE: php version

2003-09-05 Thread Cory Lamle
Contents are Direct Alliance Corporation CONFIDENTIAL - Your best bet is to grab 4.3.1 or greater Windows version even has gui installer... http://us2.php.net/get/php-4.3.3-installer.exe/from/a/mirror This message is for the designated recipient(s) only and contains Direct Alliance Corporation

Re: php version

2003-09-05 Thread Yves Goergen
On Friday, September 05, 2003 6:22 PM CET, Cory Lamle wrote: Your best bet is to grab 4.3.1 or greater Windows version even has gui installer... http://us2.php.net/get/php-4.3.3-installer.exe/from/a/mirror actually it's all the same which version you take (from 4.1 on). but for win32, you'll

Re: where is the chinese (big5) version, windows binary distribution

2003-09-04 Thread Victoria Reznichenko
Donovan Hsieh [EMAIL PROTECTED] wrote: I have the same question as posted in this thread: http://lists.mysql.com/list.php?list=mysqlpost=71462 What the problem do you have? Official binary distributions are compiled with all supported character sets. You can download windows binary

Re: where is the chinese (big5) version, windows binary distribution

2003-09-03 Thread Donovan Hsieh
I have the same question as posted in this thread: http://lists.mysql.com/list.php?list=mysqlpost=71462 - Dhsieh -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Version 3.x tables with a new 4.0.x engine

2003-08-25 Thread Yrjö Mäenpää
Hi Can I expect newly upgraded MySQL 4.0.1x engine to read my old version 3.x tables without trouble, so I can optimize them after I have installed the the new engine. I am using MyISAM tables in both systems. thanks -- MySQL General Mailing List For list archives: http://lists.mysql.com

Re: Version 3.x tables with a new 4.0.x engine

2003-08-25 Thread Egor Egorov
Yrj? M?enp?? [EMAIL PROTECTED] wrote: Can I expect newly upgraded MySQL 4.0.1x engine to read my old version 3.x tables without trouble, so I can optimize them after I have installed the the new engine. Yes. You should make database backup before upgrading in any case. I am using MyISAM

User table and version

2003-08-14 Thread Robert Morgan
Hi I am using mysql 3.23.54 that came bundled with RH9. When I do a show databases there is no user table, I am working through the reference manual for 4.0 is the reason there is no user table because of the version? also I have tried updating to version 4.0 using the RPM available from

Re: User table and version

2003-08-14 Thread Victoria Reznichenko
Robert Morgan [EMAIL PROTECTED] wrote: Hi I am using mysql 3.23.54 that came bundled with RH9. When I do a show databases there is no user table, I am working through the reference manual for 4.0 is the reason there is no user table because of the version? also I have tried updating

Re: How to write query to select the Max(version) for each unique file_name record?

2003-07-21 Thread Michael Satterwhite
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Sunday 20 July 2003 22:59, Tanamon wrote: ++---+--+ | id | file_name | max(version) | ++---+--+ | 6 | ffour |2 | | 1 | fone |3 | | 5 | fthree

<    1   2   3   4   5   6   7   8   9   10   >