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 not restarting up...

Discussion in 'General Discussion' started by JohnH, Aug 8, 2002.

  1. JohnH

    JohnH Member

    Joined:
    Jun 28, 2002
    Messages:
    14
    Likes Received:
    0
    Trophy Points:
    1
    Just restored a database (copying FRM, MYD, MYI files) and the script it was using said that the blahblah table from the database was read only... so I chmodded all the FRM MYD MYI files thinking when it copied over, the permissions didn't follow over...

    now im getting the following message through whm when I try to restart MySQL:
    [quote:edef86acfc]mysql did not return a status report[/quote:edef86acfc]

    anyone have any tips how I can get mysql back up?

    Thanks for any help
     
  2. JohnH

    JohnH Member

    Joined:
    Jun 28, 2002
    Messages:
    14
    Likes Received:
    0
    Trophy Points:
    1
    I'm looking at the logs and seeing the following over and over:

    Number of processes running now: 0
    020808 01:12:41 mysqld restarted
    020808 01:12:41 mysqld restarted
    020808 1:12:41 Can't start server : Bind on unix socket: Permission denied
    020808 1:12:41 Do you already have another mysqld server running on socket: /var/lib/mysql/mysql.sock ?
    020808 1:12:41 Aborting

    020808 1:12:41 /usr/sbin/mysqld: Shutdown Complete

    020808 01:12:41 mysqld ended
    020808 01:12:41 mysqld ended


    020808 01:12:42 mysqld started
    020808 1:12:42 Can't start server : Bind on unix socket: Permission denied
    020808 1:12:42 Do you already have another mysqld server running on socket: /var/lib/mysql/mysql.sock ?
    020808 1:12:42 Aborting

    020808 1:12:42 /usr/sbin/mysqld: Shutdown Complete

    020808 01:12:42 mysqld ended
    020808 01:12:42 mysqld ended
     
  3. JohnH

    JohnH Member

    Joined:
    Jun 28, 2002
    Messages:
    14
    Likes Received:
    0
    Trophy Points:
    1
    k - got mysql back started but another problem...

    [quote:38546e3f8d]Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock'[/quote:38546e3f8d]

    I get that error when I try to access PHPMyAdmin and scripts that utilize mysql can't connect to mysql

    arg...
     
  4. JohnH

    JohnH Member

    Joined:
    Jun 28, 2002
    Messages:
    14
    Likes Received:
    0
    Trophy Points:
    1
    arg... again... I'm losing too much sleep over this... haha

    anyways, I fixed it through the usual try this and try that... search on google, search on this forum method...

    again, was a owner/permission problem... I guess when I tried to move some database files over... I messed up the owner and permissions somehow...

    this is the second time I've done this... posted a problem and within some time fix it on my own... LOL

    sorry about that

    thanks again
     
Loading...

Share This Page