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
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
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
Okay, with the good help I was getting, and looking at the all clues MySQL
was giving me, like "Table 'mysql.host' doesn't exist" and "Can't find file:
'./mysql/host.frm'", I concluded that the 4.1.9 installation conflicts with
the default 4.0.18 installation. For instance, 4.0.18 expects files
On Wednesday, January 19, 2005 9:14 PM Michael Stassen wrote:
Details should be in the .err file in the data directory
Here's the contents of the file:
050119 17:30:02 mysqld started
050119 17:30:02 [Warning] Setting lower_case_table_names=2 because file
system
for /usr/local/m
Details should be in the .err file in the data directory
(/usr/local/mysql/data/whitestar.alpha.net.err, in your case).
Michael
Alex Majora wrote:
Additionally, this is what I get when I try to launch mysqld manually:
$ sudo ./bin/mysqld_safe &
[1] 2058
Starting mysqld daemon with databases from
Alex Majora wrote:
Michael Stassen wrote:
That doesn't appear to be mysql.
Now that I look closely, that must be a database for RMDB. Sorry I got
the two confused.
Are you sure mysqld is running? You got a shutdown message right
before this.
Apparently, it's not running, as there is no mysqld p
Additionally, this is what I get when I try to launch mysqld manually:
$ sudo ./bin/mysqld_safe &
[1] 2058
Starting mysqld daemon with databases from /usr/local/mysql/data
STOPPING server from pid file
/usr/local/mysql/data/whitestar.alpha.net.pid
050119 17:13:12 mysqld ended
Is there a way t
The postmaster is a Postgres daemon, and pg_shadow is the user table for
postgres.
Clint
From: Michael Stassen <[EMAIL PROTECTED]>
To: Alex Majora <[EMAIL PROTECTED]>
CC: mysql@lists.mysql.com
Subject: Re: mysql.sock file exists, but still cannot connect to server
Date: Wed, 19 Jan 2
Michael Stassen wrote:
That doesn't appear to be mysql.
Now that I look closely, that must be a database for RMDB. Sorry I got the
two confused.
Are you sure mysqld is running? You got a shutdown message right before
this.
Apparently, it's not running, as there is no mysqld process running in t
Alex Majora wrote:
I've upgraded to mysql 4.1.9 on Mac OS X 10.3.7, but now things won't
start up.
In the console I get these messages:
The database cluster will be initialized with locale C.
creating directory /var/db/RemoteManagement/RMDB/rmdb.data... ok
creating directory /var/db/RemoteMana
I've upgraded to mysql 4.1.9 on Mac OS X 10.3.7, but now things won't start
up.
In the console I get these messages:
The database cluster will be initialized with locale C.
creating directory /var/db/RemoteManagement/RMDB/rmdb.data... ok
creating directory /var/db/RemoteManagement/RMDB/rmdb.da
usr/local/mysql/data
> 3. The /var/log/mysqld.log file says
> mysqld started
> Warning: asked for...
> Can't start server: bind on unix socket - permission denied
> Do you already have another mysqld server running on socket
> /var/lib/mysql/mysql.sock?
> Abo
ocket - permission denied
Do you already have another mysqld server running on socket
/var/lib/mysql/mysql.sock?
Aborting
4. But I don't have any /var/lib/mysql/mysql.sock file at all.
So now I'm stuck. It looks like mysqld is still confused about the old install
or is looking for a ph
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
gets automatically cleaned up.
However the restart is undesirable in embedded linux.
Is there any means to delete the mysql.sock file in the same session.
Thanks and Regards,
Prakash Karanth
Systems Engineer
Embedded and Internet Access Soln
Wipro Technologies,
Tower 6, 3rd Floor, Electronic City
Hi,
I have redhat linux 7.1 server and I have downloaded the
binary version of mysql 3.23.52 and I have installed the same version on
other servers and it was all fine but on this server I am getting the
following
error
[root@abacusweb mysql]# bin/safe_mysqld &
[1] 21278
[root@abacusweb mysql]#
rting mysqld daemon with databases from
/var/lib/mysql/mysql
v> 020504 11:22:19 mysqld ended
v> This does not create the mysql.sock file.
v> This error logs tell me that --
v> 020503 14:24:19 mysqld started
v> 020503 14:24:20 Can't start server : Bind on unix socket: Perm
:19 mysqld ended
This does not create the mysql.sock file.
This error logs tell me that --
020503 14:24:19 mysqld started
020503 14:24:20 Can't start server : Bind on unix socket: Permission denied
020503 14:24:20 Do you already have another mysqld server running on socket:
/var/lib/mysql/my
Hello all,
I am working with the replication of mysql with selected db.
While i was trying to do that suddenly slave machine's mysql.sock file was
deleted.
So i am not able to enter into mysql.
May i know whether there is any other way to get it(mysql.sock) back as i
restarted mysql
nis [mailto:[EMAIL PROTECTED]]
>Sent: Wednesday, May 23, 2001 3:37 PM
>To: Angerer, Chad; [EMAIL PROTECTED]
>Subject: RE: mysql.sock file
>
>
>At 05:48 PM 05/22/2001, Angerer, Chad wrote:
> >Dennis,
> >
> >do a find / -name mysql.sock 2>/dev/null to find exactly
At 05:48 PM 05/22/2001, Angerer, Chad wrote:
>Dennis,
>
>do a find / -name mysql.sock 2>/dev/null to find exactly where mysql puts
>this file.. My rpm install put it in
>/var/lib/mysql/mysql.sock
>
>Find where your mysql.sock file is and make a symbolic on it pointing to
&
I faced the same problem and I solved it by creating a link under tmp called
mysqld.sock pointing to my mysql.sock
let me know if it helped
Siomara
>From: Dennis <[EMAIL PROTECTED]>
>To: [EMAIL PROTECTED]
>Subject: mysql.sock file
>Date: Tue, 22 May 2001 16:56:19 -0400
&
Dennis,
do a find / -name mysql.sock 2>/dev/null to find exactly where mysql puts
this file.. My rpm install put it in
/var/lib/mysql/mysql.sock
Find where your mysql.sock file is and make a symbolic on it pointing to
/tmp/mysql.sock
ln -s /var/lib/mysql/mysql.sock /tmp/mysql.sock
Also ch
We have a client program that fails trying to access tmp/mysql.sock on
open. It seems that newer servers either dont create the tmp file or store
it somewhere else.
What can be done to make the existing binary work with both older and newer
servers? Is there a my.cnf setting? And also, why has
25 matches
Mail list logo
