Recreating the mysql.sock file

Alan Williamson

looking through all the forums and newsgroups it would appear that
mysql.sock is definitely one for the Top10 of all time problems.
However, i have yet to see an answer that properly addresses it.

I have a production system, that is running away with no problems.
However every so often the command line 'mysql' seems to be unable to
connect to the main server running. It complains it can't find the
file.

Now here is the rub; the file is there; it has the correct
permissions. Now before any smart-a**e says to restart MySQL server,
i can't. Its a production site and therefore i don't wish to restart
it.

So the question is, how does one recreate this file on a live system?
And second question is why does it lose the file in the first place?

Any help anyone can point would be appreciated.

thank you,

a

Jul 19 '05 #1

Subscribe Post Reply

4106

Aggro

Alan Williamson wrote:

And second question is why does it lose the file in the first place?

It _shouldn't_ be destroyed by itself. So could it be that some other
program is deleting/rewriting it? Is it possible to setup the socket
file for safer place if it isn't there yet. If I remember correctly,
there have been problems, when socket file is located in /tmp/ folder,
which is cheduled to be cleared automaticly.

So atleast make sure that the folder where your socket file is, is not
cleared automaticly.

Jul 19 '05 #2

Aggro

Alan Williamson wrote:

And second question is why does it lose the file in the first place?

Jul 19 '05 #3

by: JL | last post by:

Platform: Linux Red Hat RHEL 3 (and red hat 9) Installed MySQL from source. As a matter of fact, installed all LAMPS from source, and the mysql socket file was arranged in a place other than...

Perl

mysql.sock

by: Oliver Etzel - GoodnGo.COM | last post by:

Hello all, after Installing mysql I started the mysql daemon.. The I tried to log in to my mysql database and got the message could not find mysql.sock in /tmp. In the mysql-configuration...

MySQL Database

Question again : mysql.sock

by: Oliver Etzel - GoodnGo.COM | last post by:

Hello all, after Installing mysql I started the mysql daemon.. The I tried to log in to my mysql database and got the message could not find mysql.sock in /tmp. In the mysql-configuration...

MySQL Database

mysql.sock again

by: Oliver Etzel - GoodnGo.COM | last post by:

Hello all, after Installing mysql I started the mysql daemon.. Then I tried to log in to my mysql database and got the message could not find mysql.sock in /tmp. In the mysql-configuration...

MySQL Database

Recreating the mysql.sock file

by: Alan Williamson | last post by:

looking through all the forums and newsgroups it would appear that mysql.sock is definitely one for the Top10 of all time problems. However, i have yet to see an answer that properly addresses it....

MySQL Database

MySQL tips that I have come across

by: Mike Chirico | last post by:

Interesting Things to Know about MySQL Mike Chirico (mchirico@users.sourceforge.net) Copyright (GPU Free Documentation License) 2004 Last Updated: Mon Jun 7 10:37:28 EDT 2004 The latest...

MySQL Database

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)

by: jiing | last post by:

Now let me describe what I have done and my purpose: Originally, I want to user ports to install phpBB But I found that phpBB doesn't support mysql 5.x (but the ports installed mySQL 5.0.0...

MySQL Database

mysql in a startup/shutdown loop at 30 sec intervals

by: jlee | last post by:

I'm pretty much a newbie on mysql, and I need some help. I am running mysql Ver 12.22 Distrib 4.0.24, for portbld-freebsd5.4 (i386) on a server hosting an active website. The site's developer...

MySQL Database

problem with 'mysql.sock' file

by: Ben | last post by:

Hi, I installed mysql 5.0 on redhat 9.0 from source (tar). The whole procedure occured properly, i could do ./mysqld_safe. But when i want to start the client: mysql, i get :error 2002: cannot...

MySQL Database

PHP-Mysql Socket Problem

by: balavignesh | last post by:

Hello frends! I want to connect with mysql using php. In my mysql "my.cnf" file i have specified the socket for both client and server as "/usr/local/mysql/var/mysql.sock" In my "php.ini"...

PHP

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

C / C++

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

C / C++

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...

Windows Server

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...

General

AI Job Threat for Devs

by: agi2029 | last post by:

Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

Career Advice

Access Europe - Using VBA to create a class based on a table - Wed 1 May

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...

Microsoft Access / VBA

Couldn’t get equations in html when convert word .docx file to html file in C#.

by: conductexam | last post by:

I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...

C# / C Sharp

Trying to create a lan-to-lan vpn between two differents networks

by: TSSRALBI | last post by:

Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The...

Networking - Hardware / Configuration

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

Recreating the mysql.sock file

Similar topics