Issues with downgrading 5.7.26 to 5.7.21

[David Dalle]

Hello, I have been trying to do some upgrading and downgrading between 5.7.21 and 5.7.26 on a sandbox server before upgrading our servers. All our servers are Linux RHEL 7.4. I cannot use YUM for our servers, so I am using rpm.

Steps I did:
1. Installed 5.7.21
2. Ran the 5.7.26 rpm contents individually (e.g. rpm -Uvh mysql-commercial...) and ran into a dependency issue between the client and the libs.
3. Downgraded the parts I already installed successfully back to 5.7.21
4. ran this to successfully upgrade to 5.7.26: rpm -Uvh mysql-commercial-{server,client,common,libs-compat,libs}-*
5. Tried to downgrade to 5.7.21 again because I wanted to try a couple other upgrade scenarios, but ran into another dependency issue:


[root]# rpm -Uvh --oldpackage mysql-commercial-common-5.7.21-1.1.el7.x86_64.rpm
error: Failed dependencies:
mysql-commercial-common(x86-64) = 5.7.26-1.1.el7 is needed by (installed) mysql-commercial-server-5.7.26-1.1.el7.x86_64
[root]# rpm -Uvh --oldpackage mysql-commercial-server-5.7.21-1.1.el7.x86_64.rpm
error: Failed dependencies:
mysql-commercial-common(x86-64) = 5.7.21-1.1.el7 is needed by mysql-commercial-server-5.7.21-1.1.el7.x86_64

This seems to result in a catch-22, so I upgraded components I downgraded back to 5.7.26 and that is where I'm at now.

Is there a downgrade equivalent of the following command?
rpm -Uvh mysql-commercial-{server,client,common,libs-compat,libs}-*

I tried the following and it did not work:
rpm -Uvh --oldpackage mysql-commercial-{server,client,common,libs-compat,libs}-*

Any suggestions?

Thank you