Can't shut down mysql server

Discussion in 'Site & Server Administration' started by justsomepoordude, Aug 14, 2006.

0
  1. #1
    Mysql is acting up, says can't find mysql.sock and when I try to stop it, it says proces id XXXXX not found???? Rebooting server doesn't help also.:confused:
     
    justsomepoordude, Aug 14, 2006 IP
  2. Important

    Important Peon

    Messages:
    87
    Likes Received:
    3
    Best Answers:
    0
    Trophy Points:
    0
    #2
    Do you have any space left on the /tmp partition? "df -h" to check...
     
    Important, Aug 14, 2006 IP
  3. justsomepoordude

    justsomepoordude Peon

    Messages:
    224
    Likes Received:
    5
    Best Answers:
    0
    Trophy Points:
    0
    #3
    Yes there's space, I restart server and still get the error. Short of reinstalling mysql I don't know what else I could do.
     
    justsomepoordude, Aug 14, 2006 IP
  4. wheel

    wheel Peon

    Messages:
    477
    Likes Received:
    19
    Best Answers:
    0
    Trophy Points:
    0
    #4
    look in your my.conf or my.cnf file (like in /etc). Inside that file should be the path to the socket file myslq.sock.

    Check the location of the file. If it's there - delete the file then restart mysql. Just be careful, sometimes the file is a link to another location.

    Occassionally I've seen the mysql.sock file get screwed up. Deleting and restarting works generally.
     
    wheel, Aug 14, 2006 IP