Error upgrading mysql 5.5 to MariaDB 10.1

[willrijo]

Hello

Im having trouble trying to upgrade mysql to mariadb with this error:

We expected to upgrade to 5.6; however, the system is currently on version 5.5. at /usr/local/cpanel/Whostmgr/Mysql/Upgrade.pm line 827

Attached you will find the log and the version, any suggestions?

 

[rpvw]

From your log file, it rather looks like someone replaced the default cPanel supplied MySQL server with Percona-Server ( see How to Replace MySQL with Percona - cPanel Knowledge Base - cPanel Documentation )

Before you do anything make sure you have complete backups of all the databases on the server - and just for safety - take another set, and put them somewhere else !!

I would guess that you would need to uninstall the Percona-Server, and replace it with the correct default cPanel MySQL RPM's before the upgrade will work.

 

[ChrisI]

Hello!

It does look like Percona rpms are causing issues when installing the MySQL rpms.

[2017-05-15 21:45:32 -0700] file /usr/bin/mysql from install of MySQL56-client-5.6.35-1.cp1156.x86_64 conflicts with file from package Percona-Server-client-55-5.5.55-rel38.8.el6.x86_64

To remove that, you should just need to do the reverse of the instructions in the link that was provided previously.

How to Replace MySQL with Percona - cPanel Knowledge Base - cPanel Documentation

Once Percona is removed and MySQL is managed by cPanel, you should be able to run the update again.

Thanks!

 

[willrijo]

As simple as it should be (aparently) I'm novice in server managing.

Should I get an expert to do it? or could you point the reverse process.

I understand I need to remove percona then load the cpanel rpms for mysql and mariaDB but the way to do it is not clear to me :P

 

[rpvw]

You might like to have a look at System Administration Services | cPanel Forums and see if any of them can help you