Re: the mystery of the missing mysql.sock file

2009-12-15 Thread Keith Murphy
Thanks Johan. Yes, it shows the mysqld holding it open. Not suprising really I guess. I did check the cron jobs and the history file searching for something/someone who deleted it, but didn't find anything. Still, that is what it looks like happend. I will move the sock file to /var/run/mysql so it

Re: the mystery of the missing mysql.sock file

2009-12-15 Thread Johan De Meersman
Presumably someone deleted it :-) You can try an 'lsof -U |grep mysql' to see if any processes still have it open. If the mysqld process still has it open, it's probably not the server. Why do you keep it in /tmp, btw ? My guess would be that someone (or some process) decided it was time to clean

the mystery of the missing mysql.sock file

2009-12-15 Thread Keith Murphy
Take one perfectly functional production server running 5.0.77. It has been up and running under load for quite some time. I am using xtrabackup for backups and suddenly three or four days ago backup stop running. Investigation shows that the socket file '/tmp/mysql.sock' is no longer there. The m

Re: Missing mysql.sock

2003-11-10 Thread Tobias Asplund
On Sat, 8 Nov 2003, Michael Satterwhite wrote: > This has got to be a common question, but I'd really appreciate a little help. > > I recently reinstalled my Linux (SuSE 8.2). I *KNOW* I don't have a cron run > that deletes this. > > When I try to start mysql, I get the message > > "Can't connect

Re: Missing mysql.sock

2003-11-10 Thread gerald_clark
Michael Satterwhite wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 This has got to be a common question, but I'd really appreciate a little help. I recently reinstalled my Linux (SuSE 8.2). I *KNOW* I don't have a cron run that deletes this. When I try to start mysql, I get the message

Re: Missing mysql.sock

2003-11-08 Thread Jeremy Zawodny
On Sat, Nov 08, 2003 at 10:40:25PM -0600, Michael Satterwhite wrote: > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > > This has got to be a common question, but I'd really appreciate a little help. > > I recently reinstalled my Linux (SuSE 8.2). I *KNOW* I don't have a cron run > that delete

Missing mysql.sock

2003-11-08 Thread Michael Satterwhite
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 This has got to be a common question, but I'd really appreciate a little help. I recently reinstalled my Linux (SuSE 8.2). I *KNOW* I don't have a cron run that deletes this. When I try to start mysql, I get the message "Can't connect to local MySQ

Missing mysql.sock file

2003-03-01 Thread Graham Neal
Hello, I must have installed mysql incorrectly because my suse 8.0 server does not have a mysql.sock file at all. I installed mysql 3.23.48 from rpm packages I installed server bench client Max navigator shared and the required perl bench What happened. Can anyone email me a socket file? Thx --