Error upgrading mysql 5.5 to MariaDB 10.1

willrijo

• May 15, 2017 23:53

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

  • May 16, 2017 09:41

  From your log file, it rather looks like someone replaced the default cPanel supplied MySQL server with Percona-Server ( see

  0
• 

  ChrisI

  • May 16, 2017 12:36

  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!

  0
• 

  willrijo

  • May 16, 2017 14:46

  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

  0
• 

  rpvw

  • May 16, 2017 16:13

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

  0

Please sign in to leave a comment.