mysql error: could not start the service mysql on local computer error 193: oxc1

Question

I was going thru the charset change to utf8 on my local MySQL(5.1) databases, had done some changes only via phpmyadmin to the dbs and straight to my.ini - file. When I booted my pc (win xp pro sp 3), MySQL server is not starting up at all and I can't figure out why. I changed the ini-file back as it was, but no. If I'd re-install the whole thing, do they existing dbs remain just fine (I think so) and after the install they're good to go?

Any clues what could be causing it and what you think about the re-install?

All the help mostly appreciated, my first post here, hope this forum is alive! :)

-jazz

Answer 1

Its probably something broken in your config file - you did back up the original before you made the changes?

Try starting the program directly with the --debug option.

e.g. in a DOS box:

> "c:\Program Files\MySQL Server\bin\mysqld -- debug"

And check the output and logs.

C.