Manual upgrade to MySQL 4.1.22 on the CURRENT tree ?

[#mOdY#]

Hello,

I realized that the EDGE tree now have the mysql-4.1.22 rpm's, this version addresses many bugs which we really need.

The question is ! how to manually upgrade from mysql-4.1.21 on the CURRENT tree to mysql-4.1.22 from the EDGE tree, I've got the rpm's related to this.

Here's the rpm's I've got.

MySQL-bench-4.1.22-0.glibc23.x86_64.rpm
MySQL-devel-4.1.22-0.glibc23.x86_64.rpm
MySQL-server-4.1.22-0.glibc23.x86_64.rpm
MySQL-client-4.1.22-0.glibc23.x86_64.rpm
MySQL-embedded-4.1.22-0.glibc23.x86_64.rpm
MySQL-shared-4.1.22-0.glibc23.x86_64.rpm

However, when running "$rpm -Uhv *", it spits out this error..

error: Failed dependencies:
perl-DBI is needed by MySQL-bench-4.1.22-0.glibc23.x86_64
perl(DBI) is needed by MySQL-client-4.1.22-0.glibc23.x86_64
perl(DBI) is needed by MySQL-server-4.1.22-0.glibc23.x86_64


I queried the rpm database and couldn't fine this perl-DBI rpm installed.

How is it suggested to proceed ?


,Thanks.

[curriertech]

I'd love to do this as well. I'm not willing to go to EDGE just yet to get it.

[deastwood]

i could do with this as have a couple of scripts that don't report data correctly under 4.1.21, any help would be appreciated.

[cpanelkenneth]

This is not supported, so do so at own risk:

1. Touch /etc/mysqlupdisable
2. rpm -Uvh --force --nodeps *.rpm

[deastwood]

is it likely to cause issues? will cpanel be supporting it soon, if so i will maybe wait until they do

[ttk_2k]

Can't the upgrading be done this way:

http://forums.cpanel.net/showthread....pgrad%2A+mysql

???

[deastwood]

no because we already have 4.1 installed.

[ttk_2k]

Ok, thanks... actually I just tried that method a few seconds ago, and I couldn't have my mysql upgraded..

So anyone tried above ways and got done successfully?

[ttk_2k]

OK, SEEMS TO BE AN IMPORTANT UPDATE

I tried hardly to successfully upgraded the MySQL on one of my machine from 4.1.21 to 4.1.22, and tested, and no problem at all, BUT BUT BUT.... see what, by running "upcp --force" it downgraded the MySQL version automatically back to 4.1.21.

So folks I'd suggest you guys do NOT do manually upgrade anything especially if you are like me not a professional server guy..

Sticking to 4.1.21.... wait untill CPanel to support it, and it will always do the upgrading job for you..

ciao
TT

EDIT: but again, why CPanel still does not support 4.1.22 since this new release of mysql has been released for a couple of months, just curious.

[cpanelkenneth]

OK, SEEMS TO BE AN IMPORTANT UPDATE

I tried hardly to successfully upgraded the MySQL on one of my machine from 4.1.21 to 4.1.22, and tested, and no problem at all, BUT BUT BUT.... see what, by running "upcp --force" it downgraded the MySQL version automatically back to 4.1.21.

So folks I'd suggest you guys do NOT do manually upgrade anything especially if you are like me not a professional server guy..

Sticking to 4.1.21.... wait untill CPanel to support it, and it will always do the upgrading job for you..

ciao
TT

EDIT: but again, why CPanel still does not support 4.1.22 since this new release of mysql has been released for certain months, just curious.

That's why you need to touch the /etc/mysqlupdisable file

We do support 4.1.22, just not in all branches.

[ttk_2k]

That's why you need to touch the /etc/mysqlupdisable file

We do support 4.1.22, just not in all branches.

OMG I see... so after touch /etc/mysqldisable, it won't be automatically upgraded even by running "upcp --force"??

Thank you very much.

[update]

Ok, done smoothly on all of my servers, just one question however:

why on every account's cPanel home page, it still shows this:

MySQL version: 4.1.21-standard

however on PhpMyAdmin and other places incld SSH are all showing I'm having the new version!

???

Thanks!!

TT

[update 2]

Never mind, solved by this:

http://forums.cpanel.net/showthread....version+cpanel

[Panagioths]

About how much time is it estimated for the mySQL 4.1.22 to be available for upgrade in a current or stable version?

Today 10.9.0 (build 7924) - CURRENT Tree was released but it stills supports 4.1.21 only.

[ttk_2k]

About how much time is it estimated for the mySQL 4.1.22 to be available for upgrade in a current or stable version?

Today 10.9.0 (build 7924) - CURRENT Tree was released but it stills supports 4.1.21 only.

Oh... I doubt that would be a short waiting...