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!

Database backup missing with no indication

Discussion in 'Data Protection' started by bsich, Jan 23, 2015.

  1. bsich

    bsich Member

    Joined:
    Mar 18, 2009
    Messages:
    13
    Likes Received:
    0
    Trophy Points:
    51
    I had a mysql issue in one of my databases. The normal backup ran and gave no indication in the confirmation email. The only indication was a few lines in the detailed file,
    Code:
    Got error: 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) when trying to connect
    I needed to recover the database and found it empty. When a database is not dumped it should give some type of error which can easily be seen.
     
  2. cPanelMichael

    cPanelMichael Technical Support Community Manager
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    44,731
    Likes Received:
    1,883
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Twitter:
    Hello :)

    Could you elaborate on which backup method was used to backup the database? Are you referring to the automatic backups configured in WHM?

    Thank you.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  3. bsich

    bsich Member

    Joined:
    Mar 18, 2009
    Messages:
    13
    Likes Received:
    0
    Trophy Points:
    51
    Yes the automatic backup in WHM. It sends a daily email which lists issues while backing up. If a database is not backed up it may identify it the the attached detail file, but there is no indication in the body of the email. If there is no indication of a problem why would I review over 200K of backup details each day.
     
  4. cPanelMichael

    cPanelMichael Technical Support Community Manager
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    44,731
    Likes Received:
    1,883
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Twitter:
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
Loading...

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.
    Dismiss Notice