0

For some reason my MySQL can't connect any more. I'm running three WordPress sites and I need to save the tables. That's what I really really really really care about.

Here is the problem:

root@dev:/var/log/mysql# mysql ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)

The same error is displayed when logging in with phpMyAdmin..

All of the websites display this error:

Error establishing a database connection

5
  • Where is this hosted?
    – njk
    Aug 31, 2012 at 23:34
  • 1
    Have you tried restarting MySQL? You might have just run out of sockets because of a DDOS attack. Aug 31, 2012 at 23:34
  • At linode in NJ Aug 31, 2012 at 23:34
  • mysql server is down... database files should not be deleted, if they are deleted or corrupted check binlogs, you can recover db from binlogs if enabled
    – Hawili
    Aug 31, 2012 at 23:34
  • 2
    Shut down your web server, and try restarting MySQL server. Probably everything is fine. If not, aren't you glad you take daily backups? Aug 31, 2012 at 23:35

1 Answer 1

7

mysql is not running - why don't you try starting it

And of course none of this should be a real issue because you have regular backups right?

3
  • What if he isn't an admin?
    – njk
    Aug 31, 2012 at 23:36
  • I think the answer to that is obvious Aug 31, 2012 at 23:37
  • linode's business grants ssh access to customers. If the original questioner isn't an admin, he surely has a colleague who is.
    – O. Jones
    Aug 31, 2012 at 23:39

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .