Mysql connection problem

[Newsgroup_User]

Surprise, surprise! As I started phpmyadmin I got the error message
(#2003): "Can't connect to MySQL server on 'localhost' (10061)". In the
administration panel (xp, sp2) I looked for the mysql service which
didn't run. So I tried to start the service manually and got an error
1067: "The service could not be started".

I have absolutely no idea why that happened. Phpmyadmin and mysql are
running for at least one year without any problem. What could I do?

(phpMyAdmin 2.6.0-pl3, mysql server 4.1, windows xp pro, sp2).

Regards
Carl

[Newsgroup_User]

Well, I've found the following errors in the windows administation panel:

1) path\MySQL\MySQL Server 4.1\bin\mysqld-nt: Can't find file:
'host.MYI' (errno: 2)

2) Fatal error: Can't open privilege tables: File '.\mysql\host.MYD' not
found (Errcode: 2)

What can I do?

Regards
Carl

[Newsgroup_User]

Would be nice if someone had an idea :)

I've tried to run Mysql server instance configuration, but in vain.
The result:

prepare configuration - ok
write configuration file - ok
restart service - no

The service could not be started. Error: 0

Desparately - remove and install new?

Carl

[Newsgroup_User]

carl wrote:
> Would be nice if someone had an idea :)

host.MYI is an index file in the main mysql database.
host.MYD is the relatated data file in the main mysql database.

It looks as though your main privileges table is corrupted. You can
attempt to repair it with myisamchk:

http://dev.mysql.com/doc/refman/4.1/en/myisamchk.html

If that fails, try using mysqldump to back up your data, and reinstall.

http://dev.mysql.com/doc/refman/4.1/en/mysqldump.html

--
David Powers
Author, "Foundation PHP for Dreamweaver 8" (friends of ED)
Author, "Foundation PHP 5 for Flash" (friends of ED)
http://foundationphp.com/

[Newsgroup_User]

The myisamchk failed, so I reinstalled and followed the steps you've
described in "PHP for DW 8". That worked great, so everything is ok.
Thank you!

Carl

[Newsgroup_User]

carl wrote:
> The myisamchk failed, so I reinstalled and followed the steps you've
> described in "PHP for DW 8". That worked great, so everything is ok.
> Thank you!

Pity that you couldn't recover the original mysql table, but I'm glad
everything worked out in the end.

--
David Powers
Author, "Foundation PHP for Dreamweaver 8" (friends of ED)
Author, "Foundation PHP 5 for Flash" (friends of ED)
http://foundationphp.com/