The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

SQL database will not repair itself via cPanel

Discussion in 'Database Discussions' started by aurorasweden, Aug 23, 2016.

  1. aurorasweden

    aurorasweden Registered

    Joined:
    Aug 23, 2016
    Messages:
    1
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    Stockholm, Sweden
    cPanel Access Level:
    Website Owner
    Hello Michael, greets from Sweden.
    We have two issues that may be related.
    A few days ago i noticed automated epost stating altered RPMs found.
    (c-panel-perl-522-munin-1.4.7-6.cp1156 Status missing)
    I was advised to execute :
    "/usr/local/cpanel/scripts/check_cpanel_rpms --fix"
    I have root access, but not the necessary system level knowledge to know how/where to paste that simple command string.

    Far more importaint, SQL appears to be corrupt:

    SQL_error.png

    I WAS able to execute the abobe https link, but then received the following message:
    a fatal error.png
    error-logg.PNG

    I apologise for taking your time for what is probably a mundane bug, but i could not locate this exact problem in this thread, and the matter is very critical for our data recovery business website.

    /Tony
     
  2. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,678
    Likes Received:
    649
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    Hello,

    I suggest restarting MySQL with the following command to make sure it's running properly:

    Code:
    /scripts/restartsrv_mysql
    Then, once it's restarted, review the MySQL error log to see if you notice any specific error messages with a command such as:

    Code:
    tail -f /var/lib/mysql/$hostname.err
    Thank you.
     
Loading...

Share This Page