Bug #60914 Service Problem

• Submitted: 19 Apr 2011 1:15
• Modified: 22 Apr 2011 0:10
• Reporter: Patrick Reber
• Status: Closed
• Category: MySQL Server: Installing
• Severity: S1 (Critical)
• Version: 51
• OS: Windows
• CPU Architecture: Any

[19 Apr 2011 1:15] Patrick Reber

Description:
Hi i have a problem-.-

After a reinstall of Mysql (Latest Version)
im used the Command "sc delete mysql51" ([SC] DeleteService SUCCESS)

BUT Start Service doesnt work-.-

now comes "Could not start the Service MySql51"  without "error:0"

Pls help

How to repeat:
1

[19 Apr 2011 3:25] Valeriy Kravchuk

What exact version, 5.1.x, do you use? Why do you run "sc delete" and then try to start service without creating it?

[19 Apr 2011 10:08] Patrick Reber

As I already wrote it had reinstalled
and how one could see from sc delete I had previously installed Mysql51
After the reinstall of mysql I also uninstalled the old service which was so successfully removed, according to CMD
Where had I not made ​​it up in the new installation of MySQL after an error had indeed would be (Could not start the service Mysql51 Error: 0)
BUT even though I have uninstalled the old service is still (Could not start the service Mysql51) but without error: 0 Why?

sry for my Bad english

[19 Apr 2011 12:01] MySQL Verification Team

Could you please print here the output of:

sc qc MySql51

Thanks.

[19 Apr 2011 17:47] Patrick Reber

Here:

http://i55.tinypic.com/10ndrw3.png

[19 Apr 2011 19:22] MySQL Verification Team

Thank you for the feedback. Using the Control Panel be sure the service is actually stopped, then open a command prompt as administrator, change to the MySQL \bin directory and issue:

mysqld --defaults-file="C:\Program Files\MySQL\MySQL Server 5.5\my.ini" --standalone --console

print here eventual error messages. Thanks in advance.

[20 Apr 2011 12:24] Patrick Reber

Hi Thanks for Help

Here:

http://i55.tinypic.com/98hoxe.png

i Hope this Helps

[21 Apr 2011 18:40] Patrick Reber

Hello?

[21 Apr 2011 19:29] MySQL Verification Team

According the message error you're using a my.ini file with different InnoDB files specification than those were created in the \data directory. You have 2 options to fix that issue:

- If you don't have data to preserve then go to the data directory and delete all
  the InnoDB files (del ib*) and start the service to create news ones according  the size specified in the my.ini file.

- Use the correct my.ini file.

[21 Apr 2011 22:22] Patrick Reber

Thanks for the Help

now The Service Starts :)

ty

[22 Apr 2011 0:10] MySQL Verification Team

Thank you for the feedback.