mysql error

[Zinzara]

I've been having crashing all day. Visited my Cpanel only to discover my mysql database was not even listed there... have no idea what happened. I had my VPS rebooted which brought the forum back up online.

Since then I continue to get this message

"mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: Can't
connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
/home/xxxx/public_html/forum/includes/class_core.php on line 311"

How do I fix this? I'm a newb.

--------------- Added 1236881858 at 1236881858 ---------------

... and this one:

Invalid SQL:

SELECT forum.forumid, lastpost, lastposter, lastthread, lastthreadid, lasticonid,
threadcount, replycount, lastpostid, lastprefixid

FROM forum AS forum;

MySQL Error : MySQL server has gone away
Error Number : 2006

[GTAce]

It looks to me like you either can't connect to the database or the database is not responding...if the database is not listed in cPanel, then that's a pretty good indicator that your database vanished. Is it still missing? Have you contacted your host about this?

[Lynne]

Here are some pages on each of those errors. They are both server problems that you may need to contact your host to fix.

MySQL Server has gone away:

This is a server issue. See this: http://www.vbulletin.com/docs/html/troubleshoot_mysql_goneaway and this: http://www.vbulletin.com/forum/showthread.php?s=&postid=310265#post310265


MySQL can't connect (through socket):

See this page for the causes of this error: http://www.vbulletin.com/docs/html/cantconnect

[Zinzara]

Well, I can "see" my DB in my VPS WHM, but not in Cpanel. My forum is operational though, but with errors I have listed above.

Can I use SQL services to repair my database using my WHM?

[Lynne]

Nowhere in the errors does it say the database needs to be repaired. That is not what the errors are about at all. You should not perform a 'repair' on a database that does not need to be repaired.

[Videx]

Those are both very common errors on a shared server. They just mean the server is overloaded. VPS is supposed to be a lot less 'shared'. You can try contacting your host, but don't get your hopes up. As a last resort, try to get them to move you to a different server.