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!

Backup through WHM fails at mysqlcheck

Discussion in 'Data Protection' started by T1531, Jul 13, 2019.

  1. T1531

    T1531 Member

    Joined:
    Feb 20, 2019
    Messages:
    12
    Likes Received:
    2
    Trophy Points:
    3
    Location:
    USA
    cPanel Access Level:
    Website Owner
    Every time I try to run backup in WHM, either through the nightly automated schedule or manually, it fails when it starts using mysqldump. So I ran mysqlcheck to see if anything is wrong with the database and that's where I found that mysqlcheck will crash MySQL every time. Once the check gets to a big table, the check stops and MySQL restarts itself. I know it's not something wrong with the particular table because the table it stops on is not always the same and I can also use CHECK TABLE on it in phpMyAdmin and it shows that it's fine.

    Backing up was working fine until recently. My database is a little over 20 GB and the VPS plan I have with my host has 6 GB of dedicated RAM. After looking at it for a while they got back to me and said I will need to upgrade my plan with them because I need more RAM for this to work. Does this sound right or could there be another solution without spending more money?
     
  2. cPanelMichael

    cPanelMichael Technical Support Community Manager Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    47,588
    Likes Received:
    2,182
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Twitter:
    Hello @T1531,

    Could you open a support ticket so we can take a closer look at the affected server? You can post the ticket number here once it's opened and I'll link this thread to it.

    Thank you.
     
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