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

Improve this question
5
  • Where is this hosted? Commented 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. Commented Aug 31, 2012 at 23:34
  • At linode in NJ Commented 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 Commented 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? Commented Aug 31, 2012 at 23:35

1 Answer 1

Reset to default
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?

Improve this answer
3
  • What if he isn't an admin? Commented Aug 31, 2012 at 23:36
  • I think the answer to that is obvious Commented 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. Commented Aug 31, 2012 at 23:39

You must log in to answer this question.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.