mariadb

  1. M

    DO NOT transfer from MariaDB to MySQL

    We are trying to migrate from a 60+ account server: CentOS 7.9 cPanel 106 MariaDB 10.3 To a new server with: AlmaLinux v8.7 cPanel 106 MySQL 8.0 Assuming that since MySQL is the default option for new cPanel installs and MariaDB option is no longer present, it would be a better tech stack for...
  2. V

    Ubuntu fresh install mariadb database server

    Hello On our Ubuntu 20.04 server, we were able to use the mariadb server by adding the line mysql-version=10.5 to the /root/cpanel_profile/cpanel.config file, but this setting no longer works. I see an error during the installation phase and the installation does not continue; 2022-12-23...
  3. jimjoe

    MariaDB upgrade needed for Kernel update - but I must keep php 5.6

    I MUST keep php 5.6 on my server, or I'm out of business, but now I see that kernel won't upgrade on MariaDB 10.2. What higher version of mariadb will still work with php 5.6? Is there a way to test to confirm if php 5.6 site will work with any mariadb upgrade before making it permanent...
  4. tbutler

    SOLVED New Server Stuck on MySQL 8, Not MariaDB

    I'm preparing to migrate to a new server my datacenter just provisioned. My current cPanel server is running MariaDB 10.3, but as threads such as this one talk about, cPanel now seems to default to MySQL 8 during installation, which makes installing MariaDB impossible. I'm concerned on a couple...
  5. M

    I have phpMyAdmin 4.9.7 Do I need to update?

    Hi On my CentOS server (7.9) I have PhpMyAdmin I use it every day, I saw that the installed version is 4.9.7 and I saw that there is a version latest 5.2.0, how should I update with WHM? If I update do I also have to update Mariadb or not? The mariadb version that I have is the 10.3.37, If for...
  6. Q

    cPanel / WHM Mysql offline

    Good afternoon, I wanted to ask the help of the friends of the forum! I currently have a cpanel/whm server with cloudlinux 8.6.0, and Database MariaDB 10.5 I'm having a problem with my database, it's suddenly going offline, to get back online I have to go online again. but this is happening...
  7. Sujoy Dhar

    SOLVED Unable to Upgrade from MariaDB 10.3 to 10.5

    Hi, Recently I tried to upgrade from MariaDB 10.3 to MariaDB 10.5 but it Failed and thrown the below error message , Can you please help me in this ?
  8. behinam

    could not be added to the database The request failed

    When I want to add a database to the user I give this error: could not be added to the database aaa_bbb”. The request failed. (Error ID: rcyg25) Ask your hosting provider to research this error in cPanel & WHM’s main error log. in Cpanel log show this error: Error from MySQL query: (XID...
  9. S

    MariaDB upgrade fails due to corrupted/missing package

    MariaDB upgrade fails due to corrupted/missing package. When we run MySQL/MariaDB Upgrade in WHM, cPanel overwrites the Mariadb repo file each time we modify baseurl value. Starting process with log file at /var/cpanel/logs/mysql_upgrade.20220823-193643/unattended_upgrade.log Beginning “MariaDB...
  10. C

    Major Issues Lately with MariaDB Upgrades and Updates via WHM

    After going through 2 days of hell in the last few months, I am sharing my thoughts here: 1) I no longer trust anything to do with WHM's ability to run any type of upgrade or update on MariaDB databases. Within the last few months I've had 2 major crashed database incidents due to: a) a more...
  11. E

    cPanel support for MariaDB 10.2

    According to the following: https://docs.cpanel.net/whm/sql-services/mysql-or-mariadb-upgrade/ it says that cPanel supports MariaDB version 10.2, however during the UPCP process the repository can not be found (returns a 404 error). Browsing through other threads, we saw issues with version...
  12. grayloon

    Move MariaDB

    I currently have a web server running cPanel . Sites on that server use a remote database server running MariaDB 10.2 on CentOS 7.9. Due to a dwindling number of sites we host, I'd like to combine servers by moving MariaDB to my cPanel web server. I see there are already some MySQL Community 5.7...
  13. Steve Kemp

    Yum Maria update fails

    I have just notied on one of our servers that we are getting an error when running Yum Update: if i temporarily disable the repo yum completes but anyone know why this would be occuring or how to resolve?
  14. C

    MariaDB Upgrade from 10.5 to 10.6 Failed

    I tried to upgrade mysql but the upgrade failed. My upgrade steps and the error log is below. Initially my site was totally down and throwing 500 errors, and I ran this command which brough it back up: mysql_upgrade -u root -h localhost -p --verbose --force The web site seems to be fine, and I...
  15. charliecres

    error establishing a database connection after upgrade mysql to MariaDB

    Last Night I upgraded MySQL to MariaDB 10.5. Currently, i am using cloudlinux. Now I am facing an error issue" error establishing a database connection"| after per 10-20 minutes it's getting this error for 1-2 minutes. I have tried to fix this. but unable to fix this issue. so need help to...
  16. M

    MariaDB101 mirror issue

    I cannot upgrade cPanel / EasyPHP / MariaDB because of an issue with the following mirror: Repo file: /etc/yum.repos.d/MariaDB101.repo [MariaDB101] name = MariaDB101 baseurl = https://yum.mariadb.org/10.1/centos7-amd64 gpgkey=https://yum.mariadb.org/RPM-GPG-KEY-MariaDB gpgcheck=1 The update...
  17. S

    Is a mixture of both MyISAM and InnoDB table types on the same MariaDB 10.3 database 'bad'?

    Hi All, I notice that some of our MariaDB 10.3 database have a mixture of MyISAM and InnoDB table types on them. Is it inherently "bad" to have both types of table on the same database? Or doesn't/shouldn't it make any difference? If it is ill-advised, then I guess we'll look into converting...
  18. gdimi

    In Progress CPANEL-40434 - Cannot upgrade mariadb 10.0 to 10.1, repo is not found

    I am trying to update mariadb from 10.0 to 10.2 on a centos7 with cpanel/whm, but with no success. The problem seems to be that there is no yum repo anymore for mariadb 10.1 and the wizard is trying to do a step by step upgrade from 10.0 to 10.2, by first doing the 10.0 to 10.1 upgrade. The...
  19. B

    transfer from server with mariadb 10.3 to server with mysql 8.0

    When try transfer from a server with Mariadb10.3 to Mysql 8.0 transfer in some databases got error and do not work. However, when do a fullbackup and a restore work always well. Now i need transfer a large site(more then 200G) and transfer is better option (site not stop). Anyone know why in...