Birju,
What messages do you get in the mysql log file? The message you're
getting from perl just says that the database is not available. Before
you try to restart mysql, have you checked to see if there are still
mysql processes running (ps -eax |grep -i mysql). Have you run myisamchk
on the tables since mysql has crashed.
walt
Birju Shah wrote:
>
> 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]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
