upgrade mariadb to newest version in centos 7

Discussion in 'ISPConfig 3 Priority Support' started by JOP, Jan 14, 2023.

  1. JOP

    JOP Member HowtoForge Supporter

    there is a howto to install mariadb 10 on CentOS 7 "Install MariaDB on CentOS 7: Step By Step | MariaDB".
    Is it possible to upgrade from version 5 and does it fit with ispconfig?

    Are existing wordpress/mariadb installations affected? Do they work after mariadb upgrade or what must be done?
    Has someone done this bevor and has some hints or a howto?
     
  2. Th0m

    Th0m ISPConfig Developer Staff Member ISPConfig Developer

    JOP likes this.
  3. JOP

    JOP Member HowtoForge Supporter

    thank you Th0m, will try and report.
    Will take some time...
     
  4. JOP

    JOP Member HowtoForge Supporter

    upgrade to MariaDB version 10.10.3-1 worked fine, all websites working but db backup now fails and an error reported when opening phpMyAdmin:
    ispconfig.log:
    - ERROR - Failed to make backup of database "dbname", because mysqldump failed

    when opening phpMyAdmin:
    Notice in ./libraries/mysql_charsets.inc.php#49
    [​IMG] Undefined index:
    Backtrace
    ./libraries/sqlparser.lib.php#42: include_once(./libraries/mysql_charsets.inc.php)
    ./libraries/common.inc.php#1055: include_once(./libraries/sqlparser.lib.php)
    ./index.php#12: require_once(./libraries/common.inc.php)
    Notice in ./index.php#305
    [​IMG] Undefined index: utf8
    Backtrace

    Any idea what goes wrong and how to fix it?
     
  5. JOP

    JOP Member HowtoForge Supporter

     
    till likes this.
  6. till

    till Super Moderator Staff Member ISPConfig Developer

    Regarding phpmyadmin, did you maybe upgrade the PHP version as well? To me, it looks like this might be an incompatibility between the PHPMyadmin version and the PHP version.
     
    JOP likes this.
  7. JOP

    JOP Member HowtoForge Supporter

     
  8. JOP

    JOP Member HowtoForge Supporter

    thanks, upgrade phpMyAdmin did the job.
     

Share This Page