Backups missing mysql files

rinkleton

• October 03, 2017 09:10

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

  • October 03, 2017 15:15

  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.

  0
• 

  rinkleton

  • October 03, 2017 15:45

  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?

  0
• 

  cPanelMichael

  • October 04, 2017 18:52

  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.

  0
• 

  rinkleton

  • October 04, 2017 20:33

  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
  

  0
• 

  cPanelMichael

  • October 04, 2017 20:52

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

  0
• 

  rinkleton

  • October 05, 2017 13:07

  All set. ID 8924647

  0
• 

  GoZen

  • October 05, 2017 13:17

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

  0
• 

  rinkleton

  • October 06, 2017 16:36

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

  0
• 

  cPanelMichael

  • October 06, 2017 16:40

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

  0

Please sign in to leave a comment.