Can't connect to local MySQL server through socket

[♥Biancoblu]

I've had this error on my site, on and off, for the last few months, without my changing anything. I confirm that I do not use persistent connections, and that my username and pw are correct, as well as my configure files.

 

I have spoken to host at length about it, they say this error happens during server restarts and that it typically goes unnoticed as it lasts for just seconds. Last time though it lasted for 20 minutes during which time my site was down.

 

I wonder if someone has an idea on what to do to possibly fix it?

 

Any advice welcome.

 

[26-Aug-2011 08:39:31] PHP Warning: 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) in /home/username/public_html/includes/functions/database.php on line 19

[germ]

The problem is the hosting service not the code.

 

Switch hosts.

[Xpajun]

I've just had the same problem with my hosts, Isa - they offered me a new server - I said I would take them up on it if the problem persisted after the last downtime of 1.5 hours while they sorted it.

 

 

The problem switching hosts or server is the downtime involved - about 2 days to change hosts - 15 minutes to change server - if, of course, everything goes well

[♥Biancoblu]

Thanks for the replies I appreciate it.

 

A while back host suggested I move to a VPS plan so that they could tweak the MySQL service on the server to suite my needs, but I refused.

 

About a month ago they migrated everyone to new servers which are supposed to be better performing with better hardware, updated operating system etc, so I was hoping that would fix the issue but it didn't, in fact it's worse :(

 

This morning I posted a support ticket to which nobody has replied yet when they usually reply very quickly, perhaps they don't know how to fix the error? :D