mysql cant be started

Anon

Starting mysql results in the ff. error:

Could not start Mysql service on \itc08.
Error 1067: The process terminated unexpectedly.

What should I do?

mithril

What OS are you running on? If it's WinNT/Win2K and you've intalled MySQL somewhere other tahn c:\mysql, you need to specify your installation path with the basedir directive in my.cnf. my.cnf must be saved on the c:\ root. It's also a good idea to specifiy your data directory (usually ./data to the installation directory) in my.cnf. HTH.

Cheers,

Geoff A. Virgo

Anon

mr. virgo
thank you for replying my message.
i am using mysql on winnt. this problem occur when my computer crashed. before chasing, mysql was ok.

ardin

mithril

Ardin,

Sounds like you're suffering from corrupted tables. This can happen on Win32 if MySQL isn't shutdown properly. Try making a back-up copy of your data directory, un-installing MySQL, re-installing MySQL and copying your back-up data directory into the new installation. If MySQL still doesn't start, you've found your problem.

If that is the problem, it's most likely that the mysql table itself was corrupted. You may be able to recover the rest of your tables, but you'll have to recreate all your user accounts and their permissions. HTH.

Geoff A. Virgo