SOLVED Backups missing mysql files

[rinkleton]

My backup setting is set to "Per Account and Entire MySQL Directory" and I just extracted a backup. But the only file in /mysql is openfileslimit. WHM 66.0.23. I am using MariaDB, but didn't think that would cause this issue. Any ideas?

 

[cPanelMichael]

Hello,

Do you notice any error messages for this account in the most recent backup log within the /usr/local/cpanel/logs/cpbackup/ directory?

Thank you.

 

[rinkleton]

Yep:
[2017-10-03 02:09:25 -0400] The “Mysql” failed with an error: Invalid MySQL version: “” at /usr/local/cpanel/Cpanel/MysqlUtils/Version.pm line 40.

How to resolve?

 

[cPanelMichael]

Hello,

Can you let us know the contents of the /etc/my.cnf file on this system? Also, please post the output from the following commands:

mysql -V
grep mysql-version /var/cpanel/cpanel.config
rpm -qa|grep MySQL
rpm -qa|grep MariaDB

Thank you.

 

[rinkleton]

mysql -V

mysql  Ver 15.1 Distrib 10.1.28-MariaDB, for Linux (x86_64) using readline 5.1

grep mysql-version /var/cpanel/cpanel.config

mysql-version=10.1

rpm -qa|grep MySQL

alt-python27-MySQL-percona5.6-1.2.5-1.el7.cloudlinux.2.x86_64
alt-python27-MySQL-mysql5.0-1.2.5-1.el7.cloudlinux.2.x86_64
alt-python27-MySQL-mysql5.5-1.2.5-1.el7.cloudlinux.2.x86_64
alt-python27-MySQL-mysql5.1-1.2.5-1.el7.cloudlinux.2.x86_64
compat-MySQL50-shared-5.0.96-4.cp1136.x86_64
alt-python27-MySQL-common-1.2.5-1.el7.cloudlinux.2.x86_64
alt-python27-MySQL-percona5.5-1.2.5-1.el7.cloudlinux.2.x86_64
alt-python27-MySQL-mariadb10-1.2.5-1.el7.cloudlinux.2.x86_64
cpanel-perl-524-MySQL-Diff-0.50-1.cp1162.x86_64
alt-python27-MySQL-mysql5.6-1.2.5-1.el7.cloudlinux.2.x86_64
alt-python27-MySQL-mysql5.7-1.2.5-1.el7.cloudlinux.2.x86_64
compat-MySQL51-shared-5.1.73-1.cp1150.x86_64
alt-python27-MySQL-mariadb101-1.2.5-1.el7.cloudlinux.2.x86_64
alt-python27-MySQL-meta-1-2.el7.x86_64

rpm -qa|grep MariaDB

MariaDB-server-10.1.28-1.el7.centos.x86_64
MariaDB-client-10.1.28-1.el7.centos.x86_64
MariaDB-shared-10.1.28-1.el7.centos.x86_64
MariaDB-common-10.1.28-1.el7.centos.x86_64
MariaDB-devel-10.1.28-1.el7.centos.x86_64

 

[cPanelMichael]

Hello,

Could you open a support ticket using the link in my signature so we can take a closer look?

Thank you.

 

[rinkleton]

All set. ID 8924647

 

[GoZen]

Having similar issue, waiting to see the outcome of this and act accordingly.

 

[rinkleton]

This issue has been resolve for me. In my case it was a bad directive in the /etc/my.cnf [mysqldump] section.

 

[cPanelMichael]

Hello,

I'm happy to see the issue is now solved. Thank you for updating us with the outcome.