Manual upgrade to MySQL 4.1.22 on the CURRENT tree ?

mOdY

Well-Known Member
Dec 25, 2004
80
0
156
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.
 

deastwood

Member
Sep 22, 2006
16
0
151
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

cPanel Development
Staff member
Apr 7, 2006
4,607
76
308
cPanel Access Level
Root Administrator
This is not supported, so do so at own risk:

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

deastwood

Member
Sep 22, 2006
16
0
151
is it likely to cause issues? will cpanel be supporting it soon, if so i will maybe wait until they do
 

ttk_2k

Well-Known Member
Jan 22, 2005
45
0
156
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

Well-Known Member
Jan 22, 2005
45
0
156
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. :eek: :eek: :eek:

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

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.
 
Last edited:

cPanelKenneth

cPanel Development
Staff member
Apr 7, 2006
4,607
76
308
cPanel Access Level
Root Administrator
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. :eek: :eek: :eek:

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

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

Well-Known Member
Jan 22, 2005
45
0
156
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.php?t=58420&highlight=mysql+version+cpanel
 
Last edited:

Panagioths

Registered
Mar 15, 2004
3
0
151
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

Well-Known Member
Jan 22, 2005
45
0
156
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...