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.

All MySQL databases disapeared

Discussion in 'General Discussion' started by badawi, Oct 20, 2004.

  1. badawi

    badawi Member

    Joined:
    Jan 27, 2004
    Messages:
    11
    Likes Received:
    0
    Trophy Points:
    1
    Please help me out here.

    Suddenly all the databases on this server cannot be found.
    All customers that have forums or and DB based websites are getting a message that the database cannot be found!

    I have just upgraded to the Current release yesterday, would this be the reason?

    What can I do to fix this problem?
     
  2. mramos

    mramos Member

    Joined:
    Dec 10, 2002
    Messages:
    23
    Likes Received:
    0
    Trophy Points:
    1
    Databases

    Hi

    Check if the mysql service is up! in whm > Service Status
    If is down restart

    Good luck
     
  3. hostcp3

    hostcp3 Well-Known Member

    Joined:
    Jun 18, 2002
    Messages:
    156
    Likes Received:
    0
    Trophy Points:
    16
    reset the root mysql password

    check tmp has

    mysql.sock@

    which is symlinked to


    mysql.sock -> /var/lib/mysql/mysql.sock=

    restart mysql server
     
  4. badawi

    badawi Member

    Joined:
    Jan 27, 2004
    Messages:
    11
    Likes Received:
    0
    Trophy Points:
    1
    I have restarted MySQL and it didn't help.

    It shows as up in the WHM status, however eximstats is showing down and it keeps restarting.

    HostCP3: I think it is mysql.sock as you mentioned because the error messages has the following:
    Warning: mysql_connect(): Can't connect to local MySQL server through socket '/var/tmp/mysql.sock' (2)

    Please explain to me how I can fix it (in a simple SSH orders form please)

    Thank you
     
  5. nickn

    nickn Well-Known Member
    PartnerNOC

    Joined:
    Jun 15, 2003
    Messages:
    619
    Likes Received:
    1
    Trophy Points:
    18
    Is everything still in /var/lib/mysql ?

    ls -la /var/lib/mysql
     
  6. badawi

    badawi Member

    Joined:
    Jan 27, 2004
    Messages:
    11
    Likes Received:
    0
    Trophy Points:
    1
    it seems to be back up now. I have opened a ticket and Burst seems to have fixed it.
    No reply from them yet to tell me what it was.

    Thank you guys, that is the spirit :)

    And excuse my panic attack :p
     
Loading...

Share This Page