• Registered: 2011-08-26
  • Posts: 1

Topic: Files changed by upgrade

Hello Remi

Recently I upgraded successfully to MySQL 5.5 using your repo. I would like to rollback and do it again for the purpose of training/documentation before applying to production. Which directories do I restore from backup to achieve that goal? My yum history:
Jun 11 10:23:46 Installed: mysqlclient15-5.0.67-1.el5.remi.i386
Jun 11 10:23:46 Updated: mysql-connector-odbc-3.51.26r1127-2.el5.i386
Jun 11 10:23:49 Updated: MySQL-python-1.2.3-0.1.c1.el5.i386
Jun 11 10:23:50 Updated: mysql-5.5.25-1.el5.remi.i386
Jun 11 10:23:52 Installed: mysql-libs-5.5.25-1.el5.remi.i386
Jun 11 10:24:04 Updated: mysql-server-5.5.25-1.el5.remi.i386
Jun 12 13:47:55 Installed: glibc-2.5-49.el5_5.4.i686

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

Re: Files changed by upgrade

Downgrading RPM installaing could not be done by restoring a backup.

You must remove the new RPM and reinstall old one.

AS the update is quite complex (mysqlclient15 compat lib installed, mysql-libs split, ...) the trivial "yum downgrade" will probably not work.

And, the old yum version in EL-5 don't have the "yum undo" command

So

yum remove mysqlclient15 mysql-libs
yum --disablerepo=remi install mysql-server

This will probably remove a lot of other packages which need to be reinstalled.

After, you can restore, if exists, the databases (/var/lib/mysql) from a backup before "mysql_upgrade" run.

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

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

Re: Files changed by upgrade

For training/documentation, and any new installation, you should probably use a more recent version (such as EL-6) where yum have the "history" option. EL-5 seems quite old now.

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