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:
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

[13 Apr 2010 9:39] Peter Laursen
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.
[13 Apr 2010 9:44] Peter Laursen
corrected typo.
[14 Apr 2010 8:45] Valeriy Kravchuk
Thank you for the problem report.
[11 Aug 2010 13:40] Daniel Fischer
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.