MySQL Bugs: #52777: ini-templates don't work

Bug #52777	ini-templates don't work
Submitted:	13 Apr 2010 9:39	Modified:	11 Aug 2010 13:40
Reporter:	Peter Laursen (Basic Quality Contributor)	Email Updates:
Status:	Won't fix	Impact on me:	None
Category:	MySQL Server: Packaging	Severity:	S3 (Non-critical)
Version:	5.5.3 - any recent	OS:	Windows (any)
Assigned to:	Daniel Fischer	CPU Architecture:	Any
Tags:	qc

Description:
The MySQL server 5.5.3 will not start with the templates (my-small, my-medium etc.)  If .ini file is generated by config wizard it is OK.

How to repeat:
'promote' a template >> options file and 

C:\Documents and Settings\peter>net start mysql55
The MySQL55 service is starting.
The MySQL55 service could not be started.

A system error has occurred.

System error 1067 has occurred.

The process terminated unexpectedly.

Reason is that the installer package copies the /datadir with the `mysql` database to 'AppData'.  However if no /datadir specification in my.ini the server will try to find it in installation folder. If does not and cannot start.

Suggested fix:
Do not ship those templates with the installer or add a /datadir spec.  

It is confusing and time-wasting like it is.

corrected typo.

Thank you for the problem report.

The user is expected to read and adapt these *templates* to his specific requirements. We already provide the instance configuration tool as a means to create a configuration file visually for users who are not used to editing text files.

If we removed these files, the template that is used by the configuration tool would still (have to) remain, and would also not work if used without editing. This means that removing the templates would not fix the problem, and so we will continue to provide them as a courtesy to users who would like to bypass the configuration tool.