Upgrade wizard does not seem to detect manually-created mysql-5.1 instances

[Philip Stoev]

Here is what I did:

1. Installed mysql-5.1 from MSI in a non-default directory and skipped the config wizard. So, mysql-5.1 binaries were installed, but no service.

2. In an elevated command promt, ran mysql --install to install a service. Then started the service by using the Control Panel, specifying --skip-grant-tables and --datadir. Service runs and accepts queries.

3. Ran mariadb-5.1 MSI. Installer completed succesfully but no option to run the upgrade wizard was provided. Manually starting the wizard .exe reports "there is no service that can be upgraded", even though a MySQL service does exist, even if does not have a my.ini or registry entries outside of those managed by the service manager.

bzr version-info:

revision-id: <email address hidden>
date: 2011-02-08 13:07:31 +0100
build-date: 2011-02-10 11:35:49 +0200
revno: 2943
branch-nick: maria-5.2-windows-packaging-upgrade

host: windows 7, 32bit

[Vladislav Vaintroub (wlad-montyprogram)]

Philip, can you run
  sc qc <servicename>
from command line and post the results here?

MySQL (or Maria) would actually start as service ( communicate with service control manager ) only in 2 cases , when service definition is either
<path\to\mysqld.exe> --defaults-file=<path\to\my.ini> <servicename>
or
<path\to\mysqld.exe> <servicename>

[Vladislav Vaintroub (wlad-montyprogram)]

Tried as described, confirm that service comes up if start parameters are set.

Still, closing as "invalid", since it appears to be too obscure (accepting objections though :)

Service startup parameters are not persistent in service control manager, that is one can manage to start a service once this way, but not automatically after reboot.