Hello, Thankyou for your quick response. When I start getting this error, the mysql crashes, any application which I try to start which uses mysql backend, says mysql.sock error could not connect . ----------------- DBI connect('database=search;host=localhost','web',...) failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (61) at (eval 2) line 1 -------------- When i try to restart the mysql server nothing happens and the only option that remains is to reboot the entire system. Everything works fine then for a few days and again the same error.
Birju Shah --------------------- ----- Original Message ----- From: "Daniel Kasak" <[EMAIL PROTECTED]> To: "Birju Shah" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Monday, January 12, 2004 2:13 PM Subject: Re: Mysql Socket Error > Birju Shah wrote: > > >Hello Friends, > > > >We are using free bsd, mysql 4.0.15. We are using this system since more than a year now. We have a autoresponder script which has mysql database. Since a month or so we are noticing that mysql gives the mysql.sock error and the only option which remains is to reboot the entire system. > > > >This error didnt happen before, the same scripts are running, we havent changed anything in the scripts. The mysql gives the socket error sometimes in 3 days sometimes in 7-8 days. > > > >What can be causing this error and what is the solution. > > > >Sorry to bother you. > > > >Birju Shah > > > > > Another mysql.sock error! > Firstly, when you start getting the error, what's happening to MySQL? Do > you access it in any other way, or only though the script which works > via the socket? Can you connect to MySQL with the command-line client, > or with MySQLCC? > Maybe MySQL is crashing and this is the reason which you can't connect > through the socket. What do the mysql logs say? Maybe examine / post them. > > -- > Daniel Kasak > IT Developer > NUS Consulting Group > Level 5, 77 Pacific Highway > North Sydney, NSW, Australia 2060 > T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989 > email: [EMAIL PROTECTED] > website: http://www.nusconsulting.com.au > > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]