mysql upgrade fail, so downgrade

hi, i installed mysql 5.7 and has issues starting it

now i have to revert it to 5.1 how do I go about this ?

if I uninstall using YUM i see following errors

[root@billing lib]# rpm -qa | grep mysql
mysql-community-libs-5.7.15-1.el6.x86_64
mysql-community-libs-compat-5.7.15-1.el6.x86_64
mysql-community-common-5.7.15-1.el6.x86_64
php55-php-mysqlnd-5.5.21-4.el6.x86_64
php-mysql-5.3.3-48.el6_8.x86_64
[root@billing lib]

[root@billing lib]# rpm -e mysql-community-libs-5.7.15-1.el6.x86_64
error: Failed dependencies:
        mysql-libs is needed by (installed)  
        mysql-community-libs(x86-64) >= 5.7.9 is needed by (installed) mysql-community-libs-compat-5.7.15-1.el6.x86_64
[root@billing lib]#
Status: 
Needs work

Comments

Howdy -- we're unfortunately not familiar with the process of using MySQL versions from third party repositories, so we don't know the specifics if how to downgrade from another MySQL version back to the standard CentOS version.

You could also see some problems due to the newer MySQL version changing the table structures.

However, if you try to remove the existing MySQL package with "rpm -e", any package on your system that depends on MySQL would throw a dependency error.

What you may need to do is use "yum downgrade" to install the older MySQL version, remembering that you need mysql, mysql-libs, and mysql-common.

There's some details on using "yum downgrade" here:

http://www.cyberciti.biz/faq/howto-yum-downgrade-packages-on-rhel-centos...