List:General Discussion« Previous MessageNext Message »
From:tony.chamberlain Date:January 14 2010 4:02pm
Subject:Re: version
View as plain text  
I am using RPM.  And for Centos 5 it was installing a lower version
of mysql than what was installed with the system.  That is why I want
to check before doing the RPM.  I guess the alternative is to use the
latest version all the time, but not sure whether that will work on
the 4.5 version.

The other thing is, mysql appears to keep changing between
/etc/init.d/mysqld and /etc/init/mysql so I also have to do an
ls /etc/init.s/mysql* to figure out what to use to start which is also
kind of a pain.

-----Original Message-----
From: Johan De Meersman [mailto:vegivamp@stripped]
Sent: Thursday, January 14, 2010 09:44 AM
To: tony.chamberlain@stripped
Cc: mysql@stripped
Subject: Re: version

You *should* be using a package manager (perfectly fine RPMs available for
all your needs), but if you must do this, it's a reasonably safe bet to
right-align and zero-pad all your number to 4 digits, at which point you're
free to concatenate them and treat them as a single number. then becomes 0014 0012 0005 0000 0019 which becomes

You'd probably be safe with 3 or maaaaaaaybe even two positions, depending
on how many releases get done :-)

The better-but-more-work way is to compare every number separately, starting
with the major release.

On Thu, Jan 14, 2010 at 4:21 PM, <tony.chamberlain@stripped> wrote:

> I have an install script that does some stuff with mysql (i.e. install,
> start, etc).  It installs
> mysql  Ver 14.12 Distrib 5.0.19, for pc-linux-gnu (i686) using readline 5.0
> This was good when we just used CentOS 4.5.  Now we are doing some later
> CentOS versions and the mysql version may be higher.
> I want to do something like  "mysql --version" and process the result and
> if the version is >= 5.0.19 skip the mysql installation and just do the
> other stuff.  I can't compare as it is right now because the . and stuff
> may screw up the comparison (e.g. ver 5.2 will show as greater than 5.19
> eg).
> I want to know, if I break the individual pieces like 14 12 5 0 19 I can do
> some sort of calculation to determine a number that I can actually compare.
> Or can I just remove all the decimal points, like becomes
> 14125019?  I might have to make it like  14120050019 or something.
> What is an algorithm I can use?
> Thanks
> --
> MySQL General Mailing List
> For list archives:
> To unsubscribe:

Bier met grenadyn
Is als mosterd by den wyn
Sy die't drinkt, is eene kwezel
Hy die't drinkt, is ras een ezel

versiontony.chamberlain14 Jan
  • Re: versionJohan De Meersman14 Jan
Re: versiontony.chamberlain14 Jan
  • Re: versionJohan De Meersman14 Jan