How to upgrade MySQL 5.5 to 5.6/5.7 or MariaDB 5.5 to 10.x on Linux?

Follow

Comments

190 comments

  • Avatar
    Miguel Ángel (Edited )

    Hi!! :)

    After upgrade mariaDB (5.5.65 >> 10.2.34) doesn't start with mysqld_safe option :(

    Any ideas?

    Thanks!

    0
    Comment actions Permalink
  • Avatar
    Ivan Postnikov

    Learning Curve

    Thank you for the feedback

    0
    Comment actions Permalink
  • Avatar
    Ivan Postnikov

    Hello Miguel Ángel

    This option by itself shouldn't cause the issue.

    If it's still actual, submit a support request.

    0
    Comment actions Permalink
  • Avatar
    Jan Bludau

    Possible Bugfix while Upgrading from 10.3 directly to 10.5 on CentOS 8.x.

    file /usr/share/mysql/charsets/swe7.xml from install of MariaDB-common-10.5.8-1.el8.x86_64 conflicts with file from package mysql-common-8.0.21-1.module_el8.2.0+493+63b41e36.x86_64

    run this command:

    sudo rpm -e mysql-common-8.0.21-1.module_el8.2.0+493+63b41e36.x86_64 --nodeps

     

    0
    Comment actions Permalink
  • Avatar
    Mitchell van Bijleveld

    Is it normal that I see the following error message upgrading from 10.3.x to 10.5.x on Ubuntu 20?

    dpkg: mariadb-server-10.3: dependency problems, but removing anyway as you requested:

     plesk-mysql-server depends on mariadb-server | virtual-mysql-server; however:

      Package mariadb-server is not configured yet.

      Package virtual-mysql-server is not installed.

      Package mariadb-server-10.3 which provides virtual-mysql-server is to be removed.

     plesk-mysql-server depends on mariadb-server | virtual-mysql-server; however:

      Package mariadb-server is not configured yet.

      Package virtual-mysql-server is not installed.

      Package mariadb-server-10.3 which provides virtual-mysql-server is to be removed.

     plesk-mysql-server depends on mariadb-server | virtual-mysql-server; however:

      Package mariadb-server is not configured yet.

      Package virtual-mysql-server is not installed.

      Package mariadb-server-10.3 which provides virtual-mysql-server is to be removed.

     plesk-mysql-server depends on mariadb-server | virtual-mysql-server; however:

      Package mariadb-server is not configured yet.

      Package virtual-mysql-server is not installed.

      Package mariadb-server-10.3 which provides virtual-mysql-server is to be removed.

    0
    Comment actions Permalink
  • Avatar
    Mitchell van Bijleveld

    Why don't you offer a Graphical User Interface for this?

    0
    Comment actions Permalink
  • Avatar
    Michael Hall

    We are using Plesk in the AWS environment. You cannot log in as root, but instead, login as ec2-user then use sudo.

    Issue at step 1:

    sudo MYSQL_PWD=`cat /etc/psa/.psa.shadow` mysqldump -u admin --verbose --all-databases --routines --triggers > /tmp/all-database
    cat: /etc/psa/.psa.shadow: Permission denied
    -- Connecting to localhost...
    mysqldump: Got error: 1045: "Access denied for user 'admin'@'localhost' (using password: NO)" when trying to connect. I did confirm the username is 'admin'

    How do I get past the Permission Denied? Thank you.

     

    0
    Comment actions Permalink
  • Avatar
    Thomas Hellwig

    Hi there,

    some changes for CloudLinux:

    1. Please add

    mariadb103 for MariaDB v10.3
    mariadb104 for MariaDB v10.4

    2. Please remove:

    MYSQL_PWD=`cat /etc/psa/.psa.shadow` mysql_upgrade -uadmin

    This command is not needed. Console say it is already performed and you have to add -force...

     

    Big thank you and have a great day!

    0
    Comment actions Permalink
  • Avatar
    Vinod Vyas

    Hi,

    I am planning to upgrade mariadb to 10.5, below are few outputs, 

    [##### ssh]# rpm -qa | grep -i mysql
    perl-DBD-MySQL-4.023-6.el7.x86_64
    plesk-mysql-server-18.0-2.centos.7+p18.0.27.0+t200421.1927.noarch
    plesk-php80-mysql-8.0.0-1centos.7.201130.1749.x86_64
    plesk-php73-mysql-7.3.25-1centos.7.201126.1815.x86_64
    plesk-php74-mysql-7.4.13-1centos.7.201126.1815.x86_64

    [######]# rpm -qa | grep mariadb
    plesk-libmariadbclient-3.1-3.1.8-1centos.7.200603.1842.x86_64
    mariadb-libs-5.5.68-1.el7.x86_64
    mariadb-5.5.68-1.el7.x86_64
    mariadb-server-5.5.68-1.el7.x86_64

    [####### ssh]# cat /etc/*-release
    CentOS Linux release 7.9.2009 (Core)
    NAME="CentOS Linux"
    VERSION="7 (Core)"
    ID="centos"
    ID_LIKE="rhel fedora"
    VERSION_ID="7"
    PRETTY_NAME="CentOS Linux 7 (Core)"
    ANSI_COLOR="0;31"
    CPE_NAME="cpe:/o:centos:centos:7"
    HOME_URL="https://www.centos.org/"
    BUG_REPORT_URL="https://bugs.centos.org/"

    CENTOS_MANTISBT_PROJECT="CentOS-7"
    CENTOS_MANTISBT_PROJECT_VERSION="7"
    REDHAT_SUPPORT_PRODUCT="centos"
    REDHAT_SUPPORT_PRODUCT_VERSION="7"

    18.0.32.2
    Plesk Obsidian 18.0
    CentOS Linux release 7.9.2009 (Core)
    CentOS Linux release 7.9.2009 (Core)

    Is it okay to safely use instructions mentioned above for "Plesk on CentOS 7 / RHEL 7" and upgrade to mariadb 10.5

    0
    Comment actions Permalink
  • Avatar
    francesco

    What about this error? upgrading on debian 9 from mariadb 10.1 to 10.2

    Any clue how to fix it and continue upgrade?

    Removing mariadb-server-10.1 (10.1.47-0+deb9u1) ...
    (Reading database ... 97403 files and directories currently installed.)
    Preparing to unpack .../mariadb-server-10.2_10.2.36+maria~stretch_amd64.deb ...
    /var/lib/mysql: found previous version 10.1
    Unpacking mariadb-server-10.2 (10.2.36+maria~stretch) ...
    dpkg: error processing archive /var/cache/apt/archives/mariadb-server-10.2_10.2.36+maria~stretch_amd64.deb (--unpack):
    trying to overwrite '/usr/bin/mysql_install_db', which is also in package mariadb-server-core-10.1 10.1.47-0+deb9u1
    dpkg-deb: error: subprocess paste was killed by signal (Broken pipe)
    Errors were encountered while processing:
    /var/cache/apt/archives/mariadb-server-10.2_10.2.36+maria~stretch_amd64.deb
    E: Sub-process /usr/bin/dpkg returned an error code (1)
    0
    Comment actions Permalink

Please sign in to leave a comment.

Have more questions? Submit a request