Please whitelist cPanel in your adblocker so that you’re able to see our version release promotions, thanks!

The Community Forums

Interact with an entire community of cPanel & WHM users!

SOLVED Backups missing mysql files

Discussion in 'Data Protection' started by rinkleton, Oct 3, 2017.

  1. rinkleton

    rinkleton Well-Known Member

    Joined:
    Jul 16, 2015
    Messages:
    97
    Likes Received:
    3
    Trophy Points:
    8
    Location:
    Cleveland
    cPanel Access Level:
    Root Administrator
    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?
     
    #1 rinkleton, Oct 3, 2017
  2. cPanelMichael

    cPanelMichael Technical Support Community Manager Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    46,400
    Likes Received:
    2,049
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Twitter:
    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.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #2 cPanelMichael, Oct 3, 2017
  3. rinkleton

    rinkleton Well-Known Member

    Joined:
    Jul 16, 2015
    Messages:
    97
    Likes Received:
    3
    Trophy Points:
    8
    Location:
    Cleveland
    cPanel Access Level:
    Root Administrator
    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?
     
    #3 rinkleton, Oct 3, 2017
  4. cPanelMichael

    cPanelMichael Technical Support Community Manager Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    46,400
    Likes Received:
    2,049
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Twitter:
    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:

    Code:
    mysql -V
grep mysql-version /var/cpanel/cpanel.config
rpm -qa|grep MySQL
rpm -qa|grep MariaDB
    Thank you.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #4 cPanelMichael, Oct 4, 2017
  5. rinkleton

    rinkleton Well-Known Member

    Joined:
    Jul 16, 2015
    Messages:
    97
    Likes Received:
    3
    Trophy Points:
    8
    Location:
    Cleveland
    cPanel Access Level:
    Root Administrator
    mysql -V
    Code:
    mysql  Ver 15.1 Distrib 10.1.28-MariaDB, for Linux (x86_64) using readline 5.1
    grep mysql-version /var/cpanel/cpanel.config
    Code:
    mysql-version=10.1
    rpm -qa|grep MySQL
    Code:
    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
    Code:
    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
     

    Attached Files:

    #5 rinkleton, Oct 4, 2017
  6. cPanelMichael

    cPanelMichael Technical Support Community Manager Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    46,400
    Likes Received:
    2,049
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Twitter:
    Hello,

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

    Thank you.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #6 cPanelMichael, Oct 4, 2017
  7. rinkleton

    rinkleton Well-Known Member

    Joined:
    Jul 16, 2015
    Messages:
    97
    Likes Received:
    3
    Trophy Points:
    8
    Location:
    Cleveland
    cPanel Access Level:
    Root Administrator
    All set. ID 8924647
     
    #7 rinkleton, Oct 5, 2017
  8. GoZen

    GoZen Member

    Joined:
    May 30, 2012
    Messages:
    11
    Likes Received:
    0
    Trophy Points:
    51
    Location:
    Atlanta GA
    cPanel Access Level:
    DataCenter Provider
    Twitter:
    Having similar issue, waiting to see the outcome of this and act accordingly.
     
    #8 GoZen, Oct 5, 2017
  9. rinkleton

    rinkleton Well-Known Member

    Joined:
    Jul 16, 2015
    Messages:
    97
    Likes Received:
    3
    Trophy Points:
    8
    Location:
    Cleveland
    cPanel Access Level:
    Root Administrator
    This issue has been resolve for me. In my case it was a bad directive in the /etc/my.cnf [mysqldump] section.
     
    #9 rinkleton, Oct 6, 2017
    cPanelMichael likes this.
  10. cPanelMichael

    cPanelMichael Technical Support Community Manager Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    46,400
    Likes Received:
    2,049
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Twitter:
    Hello,

    I'm happy to see the issue is now solved. Thank you for updating us with the outcome.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #10 cPanelMichael, Oct 6, 2017
(You must log in or sign up to post here.)
Loading...
Similar Threads - Backups missing mysql
  1. grabyourhosting

    About cPanel Version 80 Restore backups from a remote destination via FTP transport in WHM

    grabyourhosting, Mar 24, 2019 at 7:16 PM, in forum: Data Protection
    Replies:
    1
    Views:
    56
    cPanelMichael
    Mar 25, 2019 at 2:24 PM
  2. Luana Premoli

    What is Account Backups Section?

    Luana Premoli, Mar 22, 2019 at 7:24 AM, in forum: Data Protection
    Replies:
    3
    Views:
    48
    Infopro
    Mar 22, 2019 at 10:49 AM
  3. SamAdu

    Backup creating two sets of backups

    SamAdu, Mar 17, 2019, in forum: Data Protection
    Replies:
    5
    Views:
    115
    cPanelMichael
    Mar 20, 2019 at 12:46 PM
  4. raudabaugh

    Pruning of backups from failed transports

    raudabaugh, Mar 12, 2019, in forum: Data Protection
    Replies:
    7
    Views:
    187
    cPanelLauren
    Mar 21, 2019 at 11:45 AM
  5. abnet

    More Granular Backups

    abnet, Mar 6, 2019, in forum: Data Protection
    Replies:
    2
    Views:
    125
    cPanelLauren
    Mar 6, 2019

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Accept Learn More...
    Dismiss Notice