Bug #47023 Cannot run MySQL service: error 1067 occurs.

• Submitted: 31 Aug 2009 15:07
• Modified: 31 Aug 2009 15:16
• Reporter: Alexey Minaev
• Status: Duplicate
• Category: MySQL Server
• Severity: S2 (Serious)
• Version: 5.0.85
• OS: Windows
• CPU Architecture: Any

[31 Aug 2009 15:07] Alexey Minaev

Description:
I downloaded and unpacked the latest version of MySQL 5.0 (mysql-noinstall-5.0.85-win32.zip). 
Copied my-small.ini to my.ini.
Created a service for MySQL running the following command: 
mysqld.exe --install testservice --defaults-file="D:\Programs\mysql-5.0.85-win32\my.ini"

I tried to run the service, but it didn't started showing the error:  "Error 1067: The process terminated unexpectedly"

In the directory "D:\Programs\mysql-5.0.85-win32\data" no files with the *.err extencion appeared, so it's impossible to understand the reason of the error. 
In the System Events Log the error with Event Id = 7034 appeared.

The same actions didn't lead to any errors with the previous MySQL versions (for example, I tried with MySQL 5.0.67).

I have OS: Windows XP Proffesional SP3

How to repeat:
1)Unzip mysql-noinstall-5.0.85-win32.zip.
2)Execute mysqld.exe --install testservice --defaults-file="D:\Programs\mysql-5.0.85-win32\my-small.ini".
3)Try to start "testservice" (Control pane -> Administration -> Services).

Suggested fix:
No ideas

[31 Aug 2009 15:16] Valeriy Kravchuk

This is a duplicate of regression bug #46917.

[31 Aug 2009 15:18] Peter Laursen

I think you should try to set the /datadir in my.ini.
I think it will look for /datadir in the all users 'AppData' folder, but a 'no-install' build will have /datadir distributed as a subfolder under installation folder.

My 2 cents!

Peter
(not a mysql person)

[31 Aug 2009 15:19] Peter Laursen

ok ... Valeriy was 2 secs faster this time!