15 messages in com.mysql.lists.win32Re: MySQL won't start as a service in...
FromSent OnAttachments
Jonathan Sachs02 Jul 2001 09:09 
Jonathan Sachs02 Jul 2001 10:02 
Jonathan Sachs02 Jul 2001 12:49 
Xavier de GELIS02 Jul 2001 13:23 
Jonathan Sachs02 Jul 2001 13:40 
Xavier de GELIS02 Jul 2001 14:05 
Luc Van der Veken03 Jul 2001 00:16 
Sinisa Milivojevic03 Jul 2001 04:00 
Gerald R. Jensen03 Jul 2001 04:41 
Miguel Angel Solórzano03 Jul 2001 07:06 
Gerald Jensen03 Jul 2001 08:11 
Kristean Heisler03 Jul 2001 08:36 
Miguel Angel Solórzano03 Jul 2001 08:48 
Jonathan Sachs04 Jul 2001 12:08 
Joel Nelson04 Jul 2001 13:08 
Subject:Re: MySQL won't start as a service in Windows 2000
From:Gerald R. Jensen (gjen@autodatasys.com)
Date:07/03/2001 04:41:21 AM
List:com.mysql.lists.win32

If the sample shown is correct (basedir = E:\Program Files\mySQL), the slashes are wrong. Use /, not \.

You may also want to quote the path since it has spaces in it (basedir = "E:/Program Files/mySQL"). I haven't tested this with MySQL, but that works with other M$ Windoze applications.

Gerald Jensen

Jonathan Sachs wrote:

I recently installed MySQL v3.23.38-nt under Windows 2000 and set it up to run as a service. It worked at first, then it stopped. When I try to start it manually, I get the message "Cannot start the MySql service on the Local Computer. Error 1067: The process terminated unexpectedly."

I don't know what made it stop, but I can't get it to work again. It still runs fine as a standalone process, though.

MySQL's base directory is E:\Program Files\mySQL. The data directory is D:\Program Files\mySQL\data. There's also a data directory in the base directory, though, so MySQL should run without a data directory specified explicitly (and does, standalone).

I've read through this list's archives, and the only relevant advice I found (repeated many times) was that my base directory is incorrectly specified in C:\my.cnf. I've examined it many times, though, and I can't see anything wrong with it:

[mysqld] port=3306 . . . basedir = E:\Program Files\mySQL

I've also tried every variation I could think of (double backslashes, double backslashes in quotes, forward slashes, etc) without luck.

Can anyone tell me what is wrong, or at least suggest what to look for? I'm completely stuck. I've even tried reinstalling MySQL and reinstalling the service definition, without luck.

HI!

Either use slashes or double backslashes in any path string.

Regards,