MYSQL won't start after re-boot

[Derek]

Hello

Sorry if this has been asked before but here we go any way.

I am running Mandrake Linux 9 with MYSQL 3.23.52 ( I know not the latest but
it did work).

I have been running/using the database for about 6 weeks now without a
problem. I rebooted the Linux box and now MYSQL doesn't seem to be running
and will not start. I get the following error message 'cant connect to local
mysql server through socket '/var/lib/mysql/mysql.sock' (111) when I type
the command mysql at a prompt.

All was working fine until I added a new field of type date to the table
assets in the database test. I am not sure if this caused the problem but it
seemed to go down hill after that.

Mandrake control centre reports that the MYSQL service is running.

MS Access database on my Windows PC, which did work, now reports
'[mysql][odbc 3.51 driver]cant connect to mysql server on '192.168.1.47'
(10061) .

So Mandrake control centre is telling me MYSQL is running but everything
else points to it not.

How do I find where my data is stored ?

Many thanks for any help

Derek Blakey

--

[Aggro]

Derek @ Blueyonder wrote:

I have been running/using the database for about 6 weeks now without a
problem. I rebooted the Linux box and now MYSQL doesn't seem to be running
and will not start. I get the following error message 'cant connect to local
mysql server through socket '/var/lib/mysql/mysql.sock' (111) when I type
the command mysql at a prompt.

See if this helps:
http://dev.mysql.com/doc/mysql/en/Ca...to_server.html

[Derek]

"Aggro" <sp**********@yahoo.com> wrote in message
news:va*************@read3.inet.fi...

Derek @ Blueyonder wrote:

I have been running/using the database for about 6 weeks now without a
problem. I rebooted the Linux box and now MYSQL doesn't seem to be running and will not start. I get the following error message 'cant connect to local mysql server through socket '/var/lib/mysql/mysql.sock' (111) when I type the command mysql at a prompt.

See if this helps:
http://dev.mysql.com/doc/mysql/en/Ca...to_server.html

Excellent, had a play around following the troubleshooting notes you
mentioned and sorted it. All of my data is still there.

Many thanks