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.

mysql failed @ Thu Aug 26 17:42:09 2010. A restart was attempted automagically.

Discussion in 'Database Discussions' started by phantom_277, Aug 26, 2010.

  1. phantom_277

    phantom_277 Registered

    Joined:
    Aug 26, 2010
    Messages:
    4
    Likes Received:
    0
    Trophy Points:
    1
    i just setup my own vps with WHM , and i receive this message all the time.

    can anyone here help me ?


    this is the full message:

    mysql failed @ Thu Aug 26 17:42:09 2010. A restart was attempted automagically.Service Check Method: [check command] Cmd Service Check Raw Output: mysql has failed


    I WANT A QUICK REPLY PLZ
     
  2. konrath

    konrath Well-Known Member

    Joined:
    May 3, 2005
    Messages:
    367
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    Brasil
    The mysql is down ?

    Try in ssh

    /scripts/restartsrv mysql


    Konrath
     
  3. phantom_277

    phantom_277 Registered

    Joined:
    Aug 26, 2010
    Messages:
    4
    Likes Received:
    0
    Trophy Points:
    1
    i tried it but not working

    thanks anyway

    anymore help ?
     
  4. konrath

    konrath Well-Known Member

    Joined:
    May 3, 2005
    Messages:
    367
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    Brasil
    The mysql is running fine now ?

    If mysql is down again, try remove the log file

    in

    /var/log/mysqld.log

    or

    /var/lib/mysql/server.yourserver.com.err


    And after this, restart the mysql again

    The log file will be recreated.

    The log file corrupted, can break the mysql

    Konrath
     
  5. konrath

    konrath Well-Known Member

    Joined:
    May 3, 2005
    Messages:
    367
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    Brasil
    Verify if the partition var have space too.

    If dont have space, then the mysql dont start

    Konrath
     
  6. konrath

    konrath Well-Known Member

    Joined:
    May 3, 2005
    Messages:
    367
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    Brasil
    If necessary, you can get space

    cd var
    cd cpanel

    rm bandwidth -rf

    After this

    /scripts/restartsrv mysql ( 2 or 3 times )

    then, recreate the bandwidth folder

    mkdir bandwidth

    Konrath
     
  7. phantom_277

    phantom_277 Registered

    Joined:
    Aug 26, 2010
    Messages:
    4
    Likes Received:
    0
    Trophy Points:
    1
    still mysql failing

    what can i do now guyz ?
     
  8. phantom_277

    phantom_277 Registered

    Joined:
    Aug 26, 2010
    Messages:
    4
    Likes Received:
    0
    Trophy Points:
    1
    still mysql failing? i cant even add databases

    still mysql failing? i cant even add databases
     
  9. cPanelJared

    cPanelJared Technical Analyst
    Staff Member

    Joined:
    Feb 25, 2010
    Messages:
    1,842
    Likes Received:
    18
    Trophy Points:
    38
    Location:
    Houston, TX
    cPanel Access Level:
    Root Administrator
    Please submit a ticket

    If MySQL is down and you cannot restart it, please submit a support request, and we will be happy to investigate the cause. In this case, it would be more efficient for us to look directly than to speculate as to possible causes in a forum thread.

    I want to caution you strongly against deleting anything, including MySQL logs or data in /var/cpanel/bandwidth, unless you are certain that a lack of disk space is the cause of the problem. You can check available disk space by using the following command:

    Code:
    # df -h
    If there is plenty of disk space, please submit a support request. This will be the most expeditious way for us to help you with the failed MYSQL.
     
  10. B12Org

    B12Org Well-Known Member

    Joined:
    Jul 15, 2003
    Messages:
    692
    Likes Received:
    1
    Trophy Points:
    18
    Location:
    Seattle Washington
    cPanel Access Level:
    Root Administrator
    Did you check the log file to see if it tells you why it cant start?
     
Loading...

Share This Page