weird select - version 2

2008-02-27 Thread dante
Hi, Dont know if my last post got to the list, but since then my problem got a bit more complicated. I know how to solve it using two or more queries, but was wondering if it would be possible using only one: tableA id_tA numof descr 1 0809 john 2 0808 peter table_out id_tOut

Maria Engine and AMD and 5.1.23 binary version

2008-02-14 Thread Mariella Petrini
Hi All, Is there any plan to release a binary version for mysql-5.1.23-maria-alpha for Linux 64 for AMD ? Thanks in advance for your help, Mariella Looking for last minute shopping deals? Find them

Re: Maria Engine and AMD and 5.1.23 binary version

2008-02-14 Thread Sergei Golubchik
Hi! On Feb 14, Mariella Petrini wrote: Hi All, Is there any plan to release a binary version for mysql-5.1.23-maria-alpha for Linux 64 for AMD ? Yes. Regards / Mit vielen Grüssen, Sergei -- __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Sergei Golubchik [EMAIL PROTECTED

Re: Maria Engine and AMD and 5.1.23 binary version

2008-02-14 Thread Mariella Petrini
Hi, Do you know an approximate date ? Thanks, Mariella --- Sergei Golubchik [EMAIL PROTECTED] wrote: Hi! On Feb 14, Mariella Petrini wrote: Hi All, Is there any plan to release a binary version for mysql-5.1.23-maria-alpha for Linux 64 for AMD ? Yes. Regards / Mit vielen

Navicat MySQL GUI for Linux version 8.0.23 is released.

2008-01-30 Thread samnav
: Compatible with any MySQL server version up to 5.1.x. Incremental Search, Hex Editor and more supports in Table View. Usability enhancement in Table Design. Many other improvements on features and user-friendliness. To find out more details about the product, please visit at: http

Re: Navicat MySQL GUI for Linux version 8.0.23 is released.

2008-01-30 Thread Barry Newton
Hmm. Speaking of Navicat, does anybody out there have an easy way to scrub the control coding from scripts developed under Navicat? I expect that they're there mostly for coloration on displays, but it's kind of obnoxious when you want to do anything else with them. -- Barry -- MySQL

left join in version 5.0.45

2008-01-28 Thread Malki . Cymbalista
We have just moved to a new machine where we are running MySQL 5.0.45. On the old machine we were running MySQL 4.0.15a. The following query worked in 4.0.15a but gives an error mesage in 5.0.45. We're pretty sure the problem is with the left join. Did anything change? Here's the query:

Re: left join in version 5.0.45

2008-01-28 Thread Baron Schwartz
Hi, On Jan 28, 2008 5:31 AM, [EMAIL PROTECTED] wrote: We have just moved to a new machine where we are running MySQL 5.0.45. On the old machine we were running MySQL 4.0.15a. The following query worked in 4.0.15a but gives an error mesage in 5.0.45. We're pretty sure the problem is with the

Re: left join in version 5.0.45

2008-01-28 Thread Peter Brawley
Malki, which gives the error: ERROR 1054 (42S22): Unknown column 'depts.dept_code' in 'on clause' See the JOINs page of the manual. As of 5.0.12, MySQL improved ISO SQL compliance in query parsing; ambiguities due to comma join syntax became errors. It's highly recommended to switch from

mysqldump - new version = no data?

2008-01-17 Thread Amer Neely
produces this output file: -- MySQL dump 10.10 -- -- Host: localhostDatabase: database_name -- -- -- Server version 5.0.27 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS

Re: Inter-version client/server compatibility

2008-01-06 Thread Shawn Green
Charles Jardine wrote: To what extent can MySQL clients interact with servers of different versions? In particular, if I link an Apache PHP module with the client libraries for MySQL version 5.0.51, will I be able to use it to connect to a version 4.1.22 server? I ask this because I am running

Inter-version client/server compatibility

2008-01-02 Thread Charles Jardine
To what extent can MySQL clients interact with servers of different versions? In particular, if I link an Apache PHP module with the client libraries for MySQL version 5.0.51, will I be able to use it to connect to a version 4.1.22 server? I ask this because I am running a web hosting service

Re: Stable MySQL Version

2007-12-19 Thread Amit Nair
-0800, Amit Nair wrote: Could some one please let me know a stable version of MySQL for my computer? Version 5.0.45. http://dev.mysql.com/downloads/mysql/5.0.html#win32 -- Tiago Cruz http://everlinux.com Linux User #282636 - Never miss a thing. Make

Re: Stable MySQL Version

2007-12-19 Thread Rob Wultsch
Amit Tiago Cruz [EMAIL PROTECTED] wrote: On Wed, 2007-12-05 at 07:13 -0800, Amit Nair wrote: Could some one please let me know a stable version of MySQL for my computer? Version 5.0.45. http://dev.mysql.com/downloads/mysql/5.0.html#win32 You said that you are running Windows XP, not Window

Re: Stable MySQL Version

2007-12-19 Thread Amit Nair
] == This installation package is not supported by this processor type. Contact your product vendor Thanks Amit Tiago Cruz wrote: On Wed, 2007-12-05 at 07:13 -0800, Amit Nair wrote: Could some one please let me know a stable version of MySQL for my computer? Version 5.0.45. http://dev.mysql.com

MySQL Server Version Reference

2007-12-12 Thread Stefan Hinz
we'll add, well, excerpts from the MySQL Manual. To begin with, we've added a document called MySQL Server Version Reference that should make life easier for everyone who needs cross-version information. It's available for download but you can also browse it online: http://dev.mysql.com/doc/mysqld

Re: Stable MySQL Version

2007-12-05 Thread Tiago Cruz
On Wed, 2007-12-05 at 07:13 -0800, Amit Nair wrote: Could some one please let me know a stable version of MySQL for my computer? Version 5.0.45. http://dev.mysql.com/downloads/mysql/5.0.html#win32 -- Tiago Cruz http://everlinux.com Linux User #282636 -- MySQL General Mailing List

Stable MySQL Version

2007-12-05 Thread Amit Nair
Hello Team Could some one please let me know a stable version of MySQL for my computer? Configuration is as below: OS- Windows XP Professional Service Pack 2 Processor – AMD Athlon 64 Processor 2800+ 1.8Ghz RAM – 1 GB Actually I have downloaded one which was meant for AMD processor

Need help with a natural sort order for version numbers and release code names

2007-10-12 Thread Daevid Vincent
I'm trying to get some 'release/version numbers' to sort properly. mysql SELECT ReleaseID, Name FROM releases ORDER BY Name DESC; +---+-+ | ReleaseID | Name| +---+-+ |18 | Unspecified | |20

Re: Need help with a natural sort order for version numbers and release code names

2007-10-12 Thread Jay Pipes
Daevid Vincent wrote: I'm trying to get some 'release/version numbers' to sort properly. mysql SELECT ReleaseID, Name FROM releases ORDER BY Name DESC; +---+-+ | ReleaseID | Name| +---+-+ |18

RE: Need help with a natural sort order for version numbers and release code names

2007-10-12 Thread Daevid Vincent
-Original Message- From: Jay Pipes [mailto:[EMAIL PROTECTED] Sent: Friday, October 12, 2007 2:07 PM To: Daevid Vincent Cc: mysql@lists.mysql.com Subject: Re: Need help with a natural sort order for version numbers and release code names Daevid Vincent wrote: I'm trying

Re: Need help with a natural sort order for version numbers and release code names

2007-10-12 Thread Adam Randall
out what the ultimate goal was. I think it's kind of clever myself :) Yes, there's no possibility of indexing here, but it gets the job done. Adam. On Oct 12, 2007, at 12:39 PM, Daevid Vincent wrote: I'm trying to get some 'release/version numbers' to sort properly. mysql SELECT ReleaseID

Re: Need help with a natural sort order for version numbers and release code names

2007-10-12 Thread Adam Randall
trying to get some 'release/version numbers' to sort properly. mysql SELECT ReleaseID, Name FROM releases ORDER BY Name DESC; +---+-+ | ReleaseID | Name| +---+-+ |18 | Unspecified | |20 | Next Patch

Re: The current version is 5.0.48, no?

2007-09-14 Thread Maurice Volaski
Thank you for this info, but it just seems make a simple question a matter of confusion. It tells us that MySQL is being marketed under two editions, but nowhere does it say that the current release of each is matched bugfix for bugfix and the version difference is just arithmetic. Since

Re: The current version is 5.0.48, no?

2007-09-14 Thread Jeremy Cole
, but it just seems make a simple question a matter of confusion. It tells us that MySQL is being marketed under two editions, but nowhere does it say that the current release of each is matched bugfix for bugfix and the version difference is just arithmetic. Since community's 5.0.45 came out a few months

Re: The current version is 5.0.48, no?

2007-09-14 Thread Baron Schwartz
Jim wrote: Can these be legally run without a license? They ARE licensed: under the GPL. http://www.gnu.org/copyleft/gpl.html Baron -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: The current version is 5.0.48, no?

2007-09-14 Thread Jim
Can these be legally run without a license? Is the only difference that MySQL AB doesn't publish links to the current version on their web page, instead purposely choosing to leave the community version several revisions behind? Yeah, I'm a little confused. - Original Message

The current version is 5.0.48, no?

2007-09-13 Thread Maurice Volaski
I just learned that the current version of MySQL is 5.0.48, described here http://dev.mysql.com/doc/refman/5.0/en/releasenotes-es-5-0.html and available from http://download.dorsalsource.org/files/b/5/165/mysql-5.0.48.tar.gz When I search this list, I see no mention of it or the previous

Re: The current version is 5.0.48, no?

2007-09-13 Thread Dan Nelson
In the last episode (Sep 13), Maurice Volaski said: I just learned that the current version of MySQL is 5.0.48, described here http://dev.mysql.com/doc/refman/5.0/en/releasenotes-es-5-0.html and available from http://download.dorsalsource.org/files/b/5/165/mysql-5.0.48.tar.gz The current

[ANN] BLOB streaming engine (MyBS), version 0.5 Alpha released

2007-07-27 Thread Paul McCullagh
Hi All, I have just released version 0.5 of the BLOB streaming engine for MySQL. This version includes all the basic functionality required to stream BLOB data in and out of MySQL tables. The main features are: - Uploading of BLOB data directly into the database using HTTP PUT or GET

Re: Change in behaviour in version 5.0.41

2007-06-19 Thread Paul DuBois
At 12:10 PM -0400 6/18/07, Baron Schwartz wrote: Paul DuBois wrote: At 3:29 PM +0100 6/15/07, Ben Clewett wrote: Dear MySql, I have noticed a change in behaviour in MySql 5.0.41 from 5.0.26 with date comparisons. In 5.0.26:'2007-06-15' = '2007-06-15 00:00:00' is True. In 5.0.41:

Re: Change in behaviour in version 5.0.41

2007-06-18 Thread Paul DuBois
At 3:29 PM +0100 6/15/07, Ben Clewett wrote: Dear MySql, I have noticed a change in behaviour in MySql 5.0.41 from 5.0.26 with date comparisons. In 5.0.26:'2007-06-15' = '2007-06-15 00:00:00' is True. In 5.0.41:'2007-06-15' = '2007-06-15 00:00:00' is False. In 5.1.6-alpha:

Re: Change in behaviour in version 5.0.41

2007-06-18 Thread Baron Schwartz
Paul DuBois wrote: At 3:29 PM +0100 6/15/07, Ben Clewett wrote: Dear MySql, I have noticed a change in behaviour in MySql 5.0.41 from 5.0.26 with date comparisons. In 5.0.26:'2007-06-15' = '2007-06-15 00:00:00' is True. In 5.0.41:'2007-06-15' = '2007-06-15 00:00:00' is

Change in behaviour in version 5.0.41

2007-06-15 Thread Ben Clewett
Dear MySql, I have noticed a change in behaviour in MySql 5.0.41 from 5.0.26 with date comparisons. In 5.0.26:'2007-06-15' = '2007-06-15 00:00:00' is True. In 5.0.41:'2007-06-15' = '2007-06-15 00:00:00' is False. In 5.1.6-alpha: '2007-06-15' = '2007-06-15 00:00:00' is True.

Re: Change in behaviour in version 5.0.41

2007-06-15 Thread Mogens Melander
On Fri, June 15, 2007 16:29, Ben Clewett wrote: Dear MySql, I have noticed a change in behaviour in MySql 5.0.41 from 5.0.26 with date comparisons. In 5.0.26:'2007-06-15' = '2007-06-15 00:00:00' is True. In 5.0.41:'2007-06-15' = '2007-06-15 00:00:00' is False. In

Re: Change in behaviour in version 5.0.41

2007-06-15 Thread Baron Schwartz
Ben Clewett wrote: Dear MySql, I have noticed a change in behaviour in MySql 5.0.41 from 5.0.26 with date comparisons. In 5.0.26:'2007-06-15' = '2007-06-15 00:00:00' is True. In 5.0.41:'2007-06-15' = '2007-06-15 00:00:00' is False. In 5.1.6-alpha: '2007-06-15' = '2007-06-15

Re: MySql Version difference

2007-01-24 Thread Peter Brawley
How could i know the difference between these 2 version and there compatiblity. Read the Change History section of the manual for versions 5.0.19 through 5.0.27. PB - Nilesh wrote: Hi, I have a webapplication developed using J2EE. For the application, the database

RE: MySql Version difference

2007-01-24 Thread Nilesh
Thanks Peter. But is there any other way to do that. Can't i directly compare the 2 version, instead of reading Change Histroy section for all the version in between. Regards, Nilesh _ From: Peter Brawley [mailto:[EMAIL PROTECTED] Sent: Thursday, January 25, 2007 11:56 AM

Re: yum version 5.*

2007-01-17 Thread Colin Charles
Karl Larsen wrote: I am using Red Hat Fedora Core 4 and I wanted to yum mysql version 5 of any other and find with Core 4 I can yum only mysql version 4. I imagine Core 5 might be able to yum mysql version 5 but not certain of that. Is there a way I can yum the later version? I studied

Setting up version 5

2006-12-18 Thread Karl Larsen
Is there a paper I can d/l that covers intalling MYSQL on Red Hat Linux? Karl Larsen -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Setting up version 5

2006-12-18 Thread Duncan Hill
On Monday 18 December 2006 13:10, Karl Larsen wrote: Is there a paper I can d/l that covers intalling MYSQL on Red Hat Linux? http://dev.mysql.com/doc/refman/5.1/en/linux-rpm.html perhaps? -- Scanned by iCritical. -- MySQL General Mailing List For list archives:

Re: Does new Community version change C API licensing?

2006-10-30 Thread Warren Young
Kaj Arnö wrote: So: For client licensing, nothing as changed -- but stay tuned for an announcement next week! Did I miss it? It's been almost 2 weeks, and I don't see anything in the MySQL press release archive or your blog. -- MySQL General Mailing List For list archives:

Does new Community version change C API licensing?

2006-10-17 Thread Warren Young
I've looked over as much of the information on the new Community vs. Enterprise version stuff as I can find, and I don't see an answer to this question. Basically, I want to know if the MySQL C API is still dual licensed, under the GPL and the MySQL commercial license. If so, I don't see how

Re: Does new Community version change C API licensing?

2006-10-17 Thread Kaj Arnö
vs. Enterprise version stuff as I can find, and I don't see an answer to this question. Basically, I want to know if the MySQL C API is still dual licensed, under the GPL and the MySQL commercial license. If so, I don't see how this new model is any different than before, except

install new version of mysql with old version running

2006-10-09 Thread tllcll
Hi, I would like to install the new versin of mysql but currently i have mysql version 3.23 running... I need to have 2 version of mysql running at the moment in win2000 for different app. what is the steps for me to install the new version of mysql without causing error and able to run

[ANN] Beta version of the PBXT storage engine has been released

2006-10-04 Thread Paul McCullagh
Hi All, This is the first Beta release of the PrimeBase XT storage engine for MySQL. The new version includes: - Integration into the MySQL 4.1.21 build. - A pluggable storage engine for MySQL 5.1. Downloads, release notes and other information is available from: http

What happened to left join under version 5?

2006-09-21 Thread Mailing List Receiver
Worked under version 4. Does not work under version 5. $Qstr = select distinct replace(reftraffic.refurl,'http://',''),\ count(*)\ from reftraffic,site\ left join links\ on left(replace(reftraffic.refurl,'http://',''),locate('/',replace(reftraffic.refurl,'http

Re: What happened to left join under version 5?

2006-09-21 Thread Joerg Bruehe
Mailing List Receiver wrote: Worked under version 4. Does not work under version 5. $Qstr = select distinct replace(reftraffic.refurl,'http://',''),\ count(*)\ from reftraffic,site\ left join links\ on left(replace(reftraffic.refurl,'http://',''),locate

Re: What happened to left join under version 5?

2006-09-21 Thread Gerald L. Clark
Mailing List Receiver wrote: Worked under version 4. Does not work under version 5. $Qstr = select distinct replace(reftraffic.refurl,'http://',''),\ count(*)\ from reftraffic,site\ left join links\ on left(replace(reftraffic.refurl,'http://',''),locate

phpinfo() Client API version 3.23.49

2006-09-19 Thread Muthu
Hi, I am using apache2.0+php4.3.4+mysql 4.1.1 in windows. If I type phpinfo(); , in mysql section it is coming as Client API version 3.23.49 . Is the installation correct?. Will the php connect to the mysql 4.1.1 server?. If i need to see Client API version 4.1.1 in mysql section, what

RE: phpinfo() Client API version 3.23.49

2006-09-19 Thread Quentin Bennett
Hi, The 3.23.49 is the version of the client that php is using. This may been what it was compiled with, or what it is getting from an external library. If it is compiled that way, you'll need a new compile of php including the newer client library. If its a runtime load, you may get away

Version 4.1.9 crash

2006-08-08 Thread Ben Clewett
Dear MySQL, I posted a problem with 4.1.9 crashing when reading data from a InnodB HotBackup image, and then encountering a foreign key conflict. I can't talk to InnoDB, they make it very clear on their web site that they do not offer support until money changes hands. This will not happen

PBXT version 0.9.6 has been released

2006-08-08 Thread Paul McCullagh
Hi All, PBXT version 0.9.6 has been released and can be downloaded from http://www.primebase.com/xt. Most of the mysql-test-run scripts now run correctly with PBXT as the default storage engine. This version has also been compiled and tested on a multi-processor, 64-bit machine. In addition

Re: Version 4.1.9 crash

2006-08-08 Thread Dan Buettner
Sort of a chicken/egg problem - no support until you pay, but you won't pay until your problem is fixed? Have you contacted them to inquire whether this is a problem they could help you with if you did pay for support? Another avenue to pursue might be a support contract with MySQL. We had one

Re: Version 4.1.9 crash

2006-08-08 Thread Daniel da Veiga
GEEK CODE BLOCK- Version: 3.1 GCM/IT/P/O d-? s:- a? C++$ UBLA++ P+ L++ E--- W+++$ N o+ K- w O M- V- PS PE Y PGP- t+ 5 X+++ R+* tv b+ DI+++ D+ G+ e h+ r+ y++ --END GEEK CODE BLOCK-- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http

version of mysql

2006-08-03 Thread Vittorio Zuccalà
Hello, i'm installing an open source program based on mysql because i want to try it. It controls mysql's version and it wants 4.1.16 but i've 4.1.11... Is it possible telling to mysql server to give a different number of its version? In other words: is there some configuration that let me

Re: version of mysql

2006-08-03 Thread Chris
Vittorio Zuccalà wrote: Hello, i'm installing an open source program based on mysql because i want to try it. It controls mysql's version and it wants 4.1.16 but i've 4.1.11... Is it possible telling to mysql server to give a different number of its version? In other words: is there some

Version 5.1.6-alpha-log unexpected total crash

2006-08-02 Thread Ben Clewett
Dear MySQL, I am getting an unexpected crash in MySQL 5.1.6, with nothing written to the log. This happens with InnoDB tables and an Foreign Key error. Tables are something like: CREATE TABLE tax ( `type` varchar(8) NOT NULL, PRIMARY KEY (`type`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8

Re: Version 5.1.6-alpha-log unexpected total crash MORE DETAILS

2006-08-02 Thread Ben Clewett
MySQL, After thinking hard on the subject, I realise the server in question was running a data set from an InnoDB HotBackup. (Which is on trial so I have no support.) The source machine is a PowerPC IBM. The crashing server is an Intel Pentium. The difference being that one is

Re: yum version 5.*

2006-07-27 Thread Duncan Hill
On Wednesday 26 July 2006 22:16, Karl Larsen wrote: I am using Red Hat Fedora Core 4 and I wanted to yum mysql version 5 of any other and find with Core 4 I can yum only mysql version 4. I imagine Core 5 might be able to yum mysql version 5 but not certain of that. Is there a way I

yum version 5.*

2006-07-26 Thread Karl Larsen
I am using Red Hat Fedora Core 4 and I wanted to yum mysql version 5 of any other and find with Core 4 I can yum only mysql version 4. I imagine Core 5 might be able to yum mysql version 5 but not certain of that. Is there a way I can yum the later version? I studied the man for yum

Re: MySQL version 4.0.23 uses 99% of processor on FreeBSD 4.11

2006-07-17 Thread Jeremiah Foster
On Fri, 2006-07-14 at 09:47 -0300, Miles Thompson wrote: At 09:15 AM 7/14/2006, Jeremiah Foster wrote: Nearly once or twice a day the mysql daemon on our FreeBSD server has to be restarted since it is taking up most of the processor. That is about 3 hours and a billion rows examined. Is it

MySQL version 4.0.23 uses 99% of processor on FreeBSD 4.11

2006-07-14 Thread Jeremiah Foster
Hello, Nearly once or twice a day the mysql daemon on our FreeBSD server has to be restarted since it is taking up most of the processor. One of the entries in our slow_queries log looks like this; # Query_time: 14074 Lock_time: 0 Rows_sent: 11 Rows_examined: 1020472928 SELECT pp.art_num,

Re: MySQL version 4.0.23 uses 99% of processor on FreeBSD 4.11

2006-07-14 Thread Miles Thompson
to perform the search quicker. This is taken from http://mysqld.active-venture.com/MySQL_indexes.html -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.1.394 / Virus Database: 268.10.0/388 - Release Date: 7/13/2006 -- MySQL General Mailing List For list archives: http

Re: PBXT version 0.9.5 has been released

2006-07-07 Thread Paul McCullagh
Hi DÆVID, Thanks for your feedback. What version of IE are you using? You got a point about the style. I'll look into it... Please reply to me directly, or write to [EMAIL PROTECTED] Thanks, Paul On Jul 6, 2006, at 9:17 PM, Daevid Vincent wrote: Your site has a bunch of JS errors (using IE

RE: PBXT version 0.9.5 has been released

2006-07-06 Thread Daevid Vincent
realize those were links until I randomly rolled over one and it highlighted bright red. DÆVID -Original Message- From: Paul McCullagh [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 05, 2006 6:51 AM To: mysql@lists.mysql.com Subject: PBXT version 0.9.5 has been released Hi All

PBXT version 0.9.5 has been released

2006-07-05 Thread Paul McCullagh
Hi All, PBXT version 0.9.5 has been released and can be downloaded from http://www.primebase.com/xt. This version includes a number of major structural changes to the implementation in order to improve performance. In addition, all bugs reported so far have been fixed. For further

Version Numbers - Precedence

2006-06-24 Thread Asif Lodhi
Hi, Mathematically speaking, the 5.0.22 I am using came _before_ 5.0.5. Is that correct? Or 5.0.5 came first and then came 5.0.22? -- Asif -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Version Numbers - Precedence

2006-06-24 Thread Asif Lodhi
Hi, I am replying to my own post to clarify my query. Actually, I have 5.0.22 installed and I want to use the BIT data-type on InnoDB Engine. Can I do it or do I have to install 5.0.5 version (which is not stable) ? -- TIA Asif On 6/24/06, Asif Lodhi [EMAIL PROTECTED] wrote: Hi

Re: Version Numbers - Precedence

2006-06-24 Thread Duncan Hill
On Saturday 24 June 2006 12:50, Asif Lodhi wrote: Hi, Mathematically speaking, the 5.0.22 I am using came _before_ 5.0.5. Is that correct? Or 5.0.5 came first and then came 5.0.22? After. 5 22. Major.Minor.Release -- Scanned by iCritical. -- MySQL General Mailing List For list

Re: Version Numbers - Precedence

2006-06-24 Thread Pooly
2006/6/24, Asif Lodhi [EMAIL PROTECTED]: Hi, Mathematically speaking, the 5.0.22 I am using came _before_ 5.0.5. mathematically speaking, there no such number like 5.0.5 anyway... 5.05 perhaps... MySQL are numbered according to a X.Y.Z release number. X : is the major version, where major

ANN: Multi DBMS tool Database Workbench version 2.8.7 released

2006-06-14 Thread Martijn Tonies
Ladies, gentlemen, Upscene Productions is proud to announce the next version of the popular database development tool: Database Workbench 2.8.7 has been released today! Download a trial at: http://www.upscene.com What's new?: http://www.upscene.com/products/dbw/whatsnew.htm Full list

Uninstall old version

2006-06-02 Thread nngau
I was able to install the mysql 5.0 on my machine. But it Looks like there is a older version of mysql that was installed. When I run this command: mysql --version mysql Ver 14.7 Distrib 4.1.13a, for apple-darwin8.0 Now I need to remove this version because when I Type the command mysql

Re: Uninstall old version

2006-06-02 Thread Dan Buettner
Hello - Yes, looks you've got two versions installed. One is in your PATH (where UNIX looks for items by default), and one is not. To remove your old version, execute 'whereis mysql' from your command prompt and you will get the full path to the mysql version it knows about and is running

SV: Determine version of *.frm, *.MYD and *.MYI

2006-05-06 Thread Nils Lastein
Well... It did document it In my wiki... which is gone... Nils -Oprindelig meddelelse- Fra: sheeri kritzer [mailto:[EMAIL PROTECTED] Sendt: fr 05-05-2006 21:57 Til: Nils Lastein Cc: mysql@lists.mysql.com Emne: Re: Determine version of *.frm, *.MYD and *.MYI No backups? And you

Re: Determine version of *.frm, *.MYD and *.MYI

2006-05-06 Thread James Harvard
I know it a 4.1... But as I compiled it my self it is not so easy to figure it out And it might take a while to trial-n-error all 4.1.x You should be able to see from the change log / version history pages in the manual which minor version releases introduced incompatible changes

Determine version of *.frm, *.MYD and *.MYI

2006-05-05 Thread Nils Lastein
After a disk crash I managed to save the *.frm, *.MYD and *.MYI-files from the disk. When putting these files into another mysql server I get: mysql select * from validate; ERROR 1033 (HY000): Table './mydb/validate' was created with a different version of MySQL and cannot be read Unfortunately

Re: Determine version of *.frm, *.MYD and *.MYI

2006-05-05 Thread Barry
Nils Lastein schrieb: After a disk crash I managed to save the *.frm, *.MYD and *.MYI-files from the disk. When putting these files into another mysql server I get: mysql select * from validate; ERROR 1033 (HY000): Table './mydb/validate' was created with a different version of MySQL

Re: Determine version of *.frm, *.MYD and *.MYI

2006-05-05 Thread sheeri kritzer
/upgraded mysql on the box? If so you might be able to figure out which release it was. You can try to use something in the same branch -- if it was 4.1.something, try the latest in the 4.1 branch. Where were your backups stored? If you used mysqldump it logged the server version at the top

SV: Determine version of *.frm, *.MYD and *.MYI

2006-05-05 Thread Nils Lastein
Emne: Re: Determine version of *.frm, *.MYD and *.MYI You don't have ANY idea what branch it was created with? 3.2x, 4.0, 4.1, 5.0, 5.1 ? I'd recommend finding another similar server in your dept and see what it's running (assuming there's no standards doc, or sysadmin to ask, etc). Do you

Error 1714. The older version of Mysql Query Browser1.1 cannot be removed.

2006-05-05 Thread romyd misc
Hi All, I submitted this query in Mysql Query Browser forum last month and haven't got any help to fix this, so here I'm submitting this again. I tried to install mysql query browser 1.1.20 and previous i had version 1.1.6, but every time i try installing i keep getting the following error

Re: Determine version of *.frm, *.MYD and *.MYI

2006-05-05 Thread sheeri kritzer
No backups? And you compiled it yourself with no records of how you compiled it or what version you used? what if you want to compile a new version with the same flags, how would you remember how to do that? If those don't help, trial and error is the only way. And you know it's not 4.1.19

Re: Determine version of *.frm, *.MYD and *.MYI

2006-05-05 Thread mysql
This is right off the top of my head so I might be wrong! Does myisamchk not return the mysql version that the table was created with, if you use a very verbose option to check the *.MYI files? You could make a copy of your tables and experiment with myisamchk on the copies, see

Re: Determine version of *.frm, *.MYD and *.MYI

2006-05-05 Thread sheeri kritzer
I think you're thinking of mysqlcheck: (from the documentation) -check-upgrade, -g Invoke CHECK TABLE with the FOR UPGRADE option to check tables for incompatibilities with the current version of the server. This option was added in MySQL 5.0.19. -Sheeri On 5/5/06, [EMAIL PROTECTED] [EMAIL

difference between mysql max version and non-max version

2006-05-02 Thread ashwini c.v
Can anybdoy please tell me the difference between mysql max version andthe non-max version? Also lemme know how the max version is helpful if the installation of mysql on the clinet machine is to be done easily wihout any hassals and minimal human intervension regards, Ashwini

difference between mysql max version and non-max version

2006-05-02 Thread ashwini c.v
Note: forwarded message attached. Yahoo! India Answers: Share what you know. Learn something new. Click here---BeginMessage--- Can anybdoy please tell me the difference between mysql max version andthe non-max version? Also lemme know how the max version is helpful if the installation

Re: difference between mysql max version and non-max version

2006-05-02 Thread Joerg Bruehe
Hi! ashwini c.v wrote: Can anybdoy please tell me the difference between mysql max version andthe non-max version? I answered this here on April 26. Also, please use exact terminology: A version is a two- or three-level numeric designator, like 4.1 or 5.0.21. max is a package, or (coming

Re: difference between mysql max version and non-max version

2006-05-02 Thread Daniel da Veiga
On 5/2/06, ashwini c.v [EMAIL PROTECTED] wrote: Can anybdoy please tell me the difference between mysql max version andthe non-max version? Also lemme know how the max version is helpful if the installation of mysql on the clinet machine is to be done easily wihout any hassals and minimal

Re: Older version MySQL

2006-04-24 Thread Joerg Bruehe
.+ version that will install on this type of server without have to upgrade alot of other stuff ?? Or can we build it from source, and if so, what is the recommend configure options used to build from source ? Yes, you can build it from source. IMHO, running the RPM build process (using the spec file

RE: Older version MySQL

2006-04-23 Thread Nicolas Verhaeghe
Dependency issue, I would use RPM Package Manager. It always solved that type of issue. http://www.rpm.org/ -Original Message- From: Mike Blezien [mailto:[EMAIL PROTECTED] Sent: Friday, April 21, 2006 3:17 PM To: MySQL List Subject: Older version MySQL Hello, I am attempting

RE: Older version MySQL

2006-04-23 Thread Nicolas Verhaeghe
Dependency issue, I would use RPM Package Manager. It always solved that type of issue. http://www.rpm.org/ -Original Message- From: Mike Blezien [mailto:[EMAIL PROTECTED] Sent: Friday, April 21, 2006 3:17 PM To: MySQL List Subject: Older version MySQL Hello, I am attempting

Older version MySQL

2006-04-21 Thread Mike Blezien
libpthread.so.0(GLIBC_2.3.2) is needed by MySQL-shared-4.0.26-0 libc.so.6(GLIBC_2.3) is needed by MySQL-shared-compat-4.0.26-0 libpthread.so.0(GLIBC_2.3.2) is needed by MySQL-shared-compat-4.0.26-0 Now of the RPM's will install. Is there a 4.0.+ version that will install on this type

RE: Older version MySQL

2006-04-21 Thread Nicolas Verhaeghe
Dependency issue, I would use RPM Package Manager. It always solved that type of issue. http://www.rpm.org/ -Original Message- From: Mike Blezien [mailto:[EMAIL PROTECTED] Sent: Friday, April 21, 2006 3:17 PM To: MySQL List Subject: Older version MySQL Hello, I am attempting

RE: Older version MySQL

2006-04-21 Thread mysql
and practice are the same; in practice they are not. On Fri, 21 Apr 2006, Nicolas Verhaeghe wrote: To: 'Mike Blezien' [EMAIL PROTECTED], 'MySQL List' mysql@lists.mysql.com From: Nicolas Verhaeghe [EMAIL PROTECTED] Subject: RE: Older version MySQL Dependency issue, I would use RPM Package

Re: Older version MySQL

2006-04-21 Thread Mike Blezien
Subject: RE: Older version MySQL You might like to take a look at smart package manager. It's a wizz at dealing with dependancy conflicts. http://labix.org/smart http://wiki.suselinuxsupport.de/wikka.php?wakka=HowtoSmartPackageManager http://forums.suselinuxsupport.de/index.php?showtopic=21121

myodbc version 3.21.X

2006-04-20 Thread Reinhart Viane
Hey list, I'm am currently looking for myODBC 3.21.X but can't seem to find a suited downloadsite. Does anyone know a link to this version? Thanks in advance, Reinhart Viane

restoring database previous mysql version

2006-04-03 Thread murat .
Dear Sir, I have 8 mb total SQL database, i'm currently using mysql version: 4.1.11-debian. Our database uses latin5 character set and collate: latin5_turkish_ci And now... how can i restore this database without problem; previous mysql version? previous mysql version is: 4.0.25-standart

Re: restoring database previous mysql version

2006-04-03 Thread Kishore Jalleda
database, i'm currently using mysql version: 4.1.11-debian. Our database uses latin5 character set and collate: latin5_turkish_ci And now... how can i restore this database without problem; previous mysql version? previous mysql version is: 4.0.25-standart Note: I have SSH Access. This is very

Re: mysql query and version problem .... Help!

2006-03-22 Thread Gregory Machin
, Mark [EMAIL PROTECTED] wrote: -Original Message- From: Gregory Machin [mailto:[EMAIL PROTECTED] Sent: 21 March 2006 11:28 To: mysql@lists.mysql.com Subject: mysql query and version problem Help! Hi. I have just found out that my hosting provider is using mysql 4

Re: mysql query and version problem .... Help!

2006-03-22 Thread Gabriel PREDA
You don't need to drop a TEMPORARY table... it is dropped at connection-close ! You don't need to wory about different names for TEMPORARY tables... Manual says: A TEMPORARY table is visible only to the current connection, and is dropped automatically when the connection is closed. This means

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