The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Error upgrading mysql 5.5 to MariaDB 10.1

Discussion in 'Database Discussions' started by willrijo, May 15, 2017.

  1. willrijo

    willrijo Registered

    Joined:
    May 15, 2017
    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    Santo Domingo
    cPanel Access Level:
    Root Administrator
    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?
     

    Attached Files:

  2. rpvw

    rpvw Well-Known Member

    Joined:
    Jul 18, 2013
    Messages:
    260
    Likes Received:
    76
    Trophy Points:
    28
    Location:
    Spain
    cPanel Access Level:
    Root Administrator
    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.
     
    #2 rpvw, May 16, 2017
    Last edited: May 16, 2017
  3. cPanelChrisI

    cPanelChrisI Technical Analyst II
    Staff Member

    Joined:
    Mar 24, 2014
    Messages:
    67
    Likes Received:
    11
    Trophy Points:
    83
    cPanel Access Level:
    Root Administrator
    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!
     
  4. willrijo

    willrijo Registered

    Joined:
    May 15, 2017
    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    Santo Domingo
    cPanel Access Level:
    Root Administrator
    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
     
  5. rpvw

    rpvw Well-Known Member

    Joined:
    Jul 18, 2013
    Messages:
    260
    Likes Received:
    76
    Trophy Points:
    28
    Location:
    Spain
    cPanel Access Level:
    Root Administrator
Loading...

Share This Page