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

    Feb 20, 2019
    Likes Received:
    Trophy Points:
    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

    Apr 11, 2011
    Likes Received:
    Trophy Points:
    cPanel Access Level:
    Root Administrator
    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.

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