Lost Mysql, unable to fix

993ti

Verified User
Joined
May 4, 2007
Messages
89
Yesterday i updated mysql to 5.0.45 with custombuild and now i lost mysql.sock.
My.cnf has been edited to point to the correct location but the file is not on the system.
I tried locate mysql.sock and find / -name mysql.sock but nothing found.

Needless to say that mysql can't be started now :(
It's Debian 3.1 btw.
I hope someone can help me out since there are quite a few sites down now :(
Thanks in advance.
 

smtalk

Administrator
Staff member
Joined
Aug 22, 2006
Messages
8,347
Location
LT, EU
Hello,

PM me your server details and I'll find the problem.
 

smtalk

Administrator
Staff member
Joined
Aug 22, 2006
Messages
8,347
Location
LT, EU
It's working fine now "chown -R mysql:mysql /home/mysql" fixed the problem.
 

993ti

Verified User
Joined
May 4, 2007
Messages
89
Awesome, thanks!
The sites couldn't connect but rebooting the server fixed that part.
Wiring donation to my Paypal ;)
 

993ti

Verified User
Joined
May 4, 2007
Messages
89
One small question though.
I noticed that my forum is loading topics very slow now.
I checked phpmyadmin, and it says that mysql 5.0.45 is running but when i do ./build versions with custombuild it says that 5.0.32 is installed and that an update is available (5.0.45).
Unable to use ./build mysql to update since it shows the error again (using the fix Smtalk posted fixed that one again ;) ).
So, how do i check exactly what version is running and if needed, how to update?
 

993ti

Verified User
Joined
May 4, 2007
Messages
89
Could it also be that it's looking for the wrong pid?
I noticed 2 pids in /usr/local/mysql/data and i think it has the wrong one (not sure).
 
Top