[Mapserver-users] Re: mysql question

[pkishor_98]

--- In mapserver-users at yahoogroups.com, "fx gamoy" <fx.gamoy at m...> wrote:
> hello
> i ve unfortunately deleted the mysql.sock file so that mysql don't
work anymore
> 
> What can i do to retrieve my sock file?


doesn't it get recreated when you start MySQL? A little googling
provides the following --

============
FRed> Of course before ask to the mailling list I looked at manual (do
you have a
FRed> french version of it ?) ... and the only thing I found was
FRed> "18.6 How to protect `/tmp/mysql.sock' from being deleted"
FRed> Great but /tmp is a very special directory where all is deleted
every night
FRed> by ... ROOT ... with a rm -rf /tmp/* !!!!
FRed> so I would like create the "/tmp/mysql.sock" in an another
directory (I
FRed> have changed the safe_mysqld) but when I did it this error occured :
FRed> The error: Can't connect to local MySQL server through socket
>> '/tmp/mysql.sock' (2) at ../bin/mysql_setpermission line 65, <STDIN>
FRed> chunk 1.

FRed> So my question should be : could I create the mysql.sock in a
directory
FRed> like /usr/local/mysql/tmp instead of /tmp ?

Hi!

Which MySQL version are you using?
If you are using a recent MySQL 3.22 version, you can create the file
'/etc/my.cnf' with the following information:

[mysqld]
socket=/my-own-path/mysql.sock

[client]
socket=/my-own-path/mysql.sock

Another options is to recompile MySQL with the
--with-unix-socket-path=absolute-file-name or setting the
MYSQL_UNIX_PORT variable before starting the mysqld program and all
client programs.

You can of course also specify the socket that a client should use
with the --socket=path option (all standard MySQL programs takes this
option)

Regards,
Monty 

===========

or, just use TCPIP.

Puneet.