• Registered: 2011-05-24
  • Posts: 3

Topic: Upgrade mysql 5.0 to 5.5 without PHP upgrade

This is a situation similar to this topic: http://forums.famillecollet.com/viewtopic.php?id=356

Currently, I have:

mysql.i386                               5.0.77-4.el5_5.5              installed
mysql-server.i386                        5.0.77-4.el5_5.5              installed
php.i386                                 5.2.10-1.el5.centos           installed
php-cli.i386                             5.2.10-1.el5.centos           installed
php-common.i386                          5.2.10-1.el5.centos           installed
php-devel.i386                           5.2.10-1.el5.centos           installed
php-mcrypt.i386                          5.2.9-2.el5.centos.3          installed
php-mysql.i386                           5.2.10-1.el5.centos           installed

When I update with: # yum --enablerepo=remi update mysql\*
Yum wants to update PHP to resolve dependencies:

[snip some output]

Dependencies Resolved

==================================================================================================================================
Package                          Arch                    Version                                   Repository               Size
==================================================================================================================================
Updating:
mysql                            i386                    5.5.12-1.el5.remi                         remi                    7.5 M
mysql-server                     i386                    5.5.12-1.el5.remi                         remi                     12 M
Installing for dependencies:
libedit                          i386                    2.11-2.20080712cvs.el5                    epel                     79 k
libtool-ltdl                     i386                    1.5.22-7.el5_4                            base                     37 k
mysql-libs                       i386                    5.5.12-1.el5.remi                         remi                    1.1 M
mysqlclient15                    i386                    5.0.67-1.el5.remi                         remi                    1.3 M
Updating for dependencies:
php                              i386                    5.3.6-4.el5.remi                          remi                    1.3 M
php-cli                          i386                    5.3.6-4.el5.remi                          remi                    2.6 M
php-common                       i386                    5.3.6-4.el5.remi                          remi                    970 k
php-devel                        i386                    5.3.6-4.el5.remi                          remi                    623 k
php-gd                           i386                    5.3.6-4.el5.remi                          remi                    205 k
php-mbstring                     i386                    5.3.6-4.el5.remi                          remi                    2.3 M
php-mcrypt                       i386                    5.3.6-4.el5.remi                          remi                     45 k
php-mysql                        i386                    5.3.6-4.el5.remi                          remi                    148 k

I need PHP to remain at 5.2.10. How can I accomplish this while upgrading mysql to 5.5.12? Thanks in advance for any advice.

  • Remi
  • Remi
  • Administrateur
  • Offline
  • From: Champagne...
  • Registered: 2009-04-28
  • Posts: 3,839

Re: Upgrade mysql 5.0 to 5.5 without PHP upgrade

I don't understand why yum pull php, it should get compat-mysql51 which provides the required client library for php-mysql..

I need the full yum output.

Laptop:  Fedora 38 + rpmfusion + remi (SCL only)
x86_64 builder: Fedora 39 + rpmfusion + remi-test
aarch64 builder: RHEL 9 with EPEL
Hosting Server: CentOS 8 Stream with EPEL, rpmfusion, remi

Remi's Website

  • Registered: 2011-05-24
  • Posts: 3

Re: Upgrade mysql 5.0 to 5.5 without PHP upgrade

Thanks for your response! I'm using remi, epel and CentOS-Testing repos. I do have "includepkgs=php*" option in CentOS-Testing repo, but I'm not sure that makes a difference here. I followed the CentOS Wiki HowTo http://wiki.centos.org/HowTos/PHP_5.1_To_5.2 back when I upgraded PHP from 5.1 to 5.2.

Here's the full yum output:

[root@chi yum.repos.d]# yum --enablerepo=remi update mysql\*
Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile
 * remi: rpms.famillecollet.com
Reducing CentOS-5 Testing to included packages only
Finished
Setting up Update Process
Resolving Dependencies
--> Running transaction check
--> Processing Dependency: libmysqlclient.so.15 for package: perl-DBD-MySQL
--> Processing Dependency: libmysqlclient.so.15 for package: php-mysql
--> Processing Dependency: libmysqlclient.so.15(libmysqlclient_15) for package: perl-DBD-MySQL
--> Processing Dependency: libmysqlclient.so.15(libmysqlclient_15) for package: php-mysql
---> Package mysql.i386 0:5.5.12-1.el5.remi set to be updated
--> Processing Dependency: mysql-libs = 5.5.12-1.el5.remi for package: mysql
---> Package mysql-server.i386 0:5.5.12-1.el5.remi set to be updated
--> Running transaction check
---> Package mysql-libs.i386 0:5.5.12-1.el5.remi set to be updated
---> Package mysqlclient15.i386 0:5.0.67-1.el5.remi set to be updated
---> Package php-mysql.i386 0:5.3.6-4.el5.remi set to be updated
--> Processing Dependency: php-pdo = 5.3.6-4.el5.remi for package: php-mysql
--> Running transaction check
---> Package php-pdo.i386 0:5.3.6-4.el5.remi set to be updated
--> Processing Dependency: php-common = 5.3.6-4.el5.remi for package: php-pdo
--> Running transaction check
--> Processing Dependency: php-api = 20041225 for package: php-mcrypt
--> Processing Dependency: php-common = 5.2.10-1.el5.centos for package: php-xmlrpc
--> Processing Dependency: php-common = 5.2.10-1.el5.centos for package: php-gd
--> Processing Dependency: php-common = 5.2.10-1.el5.centos for package: php
--> Processing Dependency: php-common = 5.2.10-1.el5.centos for package: php-cli
--> Processing Dependency: php-common = 5.2.10-1.el5.centos for package: php-xml
--> Processing Dependency: php-common = 5.2.10-1.el5.centos for package: php-mbstring
---> Package php-common.i386 0:5.3.6-4.el5.remi set to be updated
--> Running transaction check
--> Processing Dependency: php = 5.2.10-1.el5.centos for package: php-devel
---> Package php.i386 0:5.3.6-4.el5.remi set to be updated
---> Package php-cli.i386 0:5.3.6-4.el5.remi set to be updated
--> Processing Dependency: libedit.so.0 for package: php-cli
---> Package php-gd.i386 0:5.3.6-4.el5.remi set to be updated
---> Package php-mbstring.i386 0:5.3.6-4.el5.remi set to be updated
---> Package php-mcrypt.i386 0:5.3.6-4.el5.remi set to be updated
--> Processing Dependency: libltdl.so.3 for package: php-mcrypt
---> Package php-xml.i386 0:5.3.6-4.el5.remi set to be updated
---> Package php-xmlrpc.i386 0:5.3.6-4.el5.remi set to be updated
--> Running transaction check
---> Package libedit.i386 0:2.11-2.20080712cvs.el5 set to be updated
---> Package libtool-ltdl.i386 0:1.5.22-7.el5_4 set to be updated
---> Package php-devel.i386 0:5.3.6-4.el5.remi set to be updated
--> Finished Dependency Resolution

Dependencies Resolved

==================================================================================================================================
 Package                          Arch                    Version                                   Repository               Size
==================================================================================================================================
Updating:
 mysql                            i386                    5.5.12-1.el5.remi                         remi                    7.5 M
 mysql-server                     i386                    5.5.12-1.el5.remi                         remi                     12 M
Installing for dependencies:
 libedit                          i386                    2.11-2.20080712cvs.el5                    epel                     79 k
 libtool-ltdl                     i386                    1.5.22-7.el5_4                            base                     37 k
 mysql-libs                       i386                    5.5.12-1.el5.remi                         remi                    1.1 M
 mysqlclient15                    i386                    5.0.67-1.el5.remi                         remi                    1.3 M
Updating for dependencies:
 php                              i386                    5.3.6-4.el5.remi                          remi                    1.3 M
 php-cli                          i386                    5.3.6-4.el5.remi                          remi                    2.6 M
 php-common                       i386                    5.3.6-4.el5.remi                          remi                    970 k
 php-devel                        i386                    5.3.6-4.el5.remi                          remi                    623 k
 php-gd                           i386                    5.3.6-4.el5.remi                          remi                    205 k
 php-mbstring                     i386                    5.3.6-4.el5.remi                          remi                    2.3 M
 php-mcrypt                       i386                    5.3.6-4.el5.remi                          remi                     45 k
 php-mysql                        i386                    5.3.6-4.el5.remi                          remi                    148 k
 php-pdo                          i386                    5.3.6-4.el5.remi                          remi                    113 k
 php-xml                          i386                    5.3.6-4.el5.remi                          remi                    207 k
 php-xmlrpc                       i386                    5.3.6-4.el5.remi                          remi                     86 k

Transaction Summary
==================================================================================================================================
Install       4 Package(s)
Upgrade      13 Package(s)

Total download size: 31 M
Is this ok [y/N]: N
Exiting on user Command
Complete!
  • Remi
  • Remi
  • Administrateur
  • Offline
  • From: Champagne...
  • Registered: 2009-04-28
  • Posts: 3,839

Re: Upgrade mysql 5.0 to 5.5 without PHP upgrade

try with --exclude=php\*

Laptop:  Fedora 38 + rpmfusion + remi (SCL only)
x86_64 builder: Fedora 39 + rpmfusion + remi-test
aarch64 builder: RHEL 9 with EPEL
Hosting Server: CentOS 8 Stream with EPEL, rpmfusion, remi

Remi's Website

  • Registered: 2011-05-24
  • Posts: 3

Re: Upgrade mysql 5.0 to 5.5 without PHP upgrade

That is the solution! big_smile

Thanks for your help and for contributing your repos to the community.