Bug #24080 Commandline --event-scheduler=1 rejected
Submitted: 8 Nov 2006 10:06 Modified: 8 Nov 2006 12:35
Reporter: Christian Starka Email Updates:
Status: Not a Bug Impact on me:
None 
Category:MySQL Server Severity:S2 (Serious)
Version:5.1.12 beta OS:Windows (Win2003Server)
Assigned to: CPU Architecture:Any

[8 Nov 2006 10:06] Christian Starka
Description:
I tried to install the service with the startargument --event-scheduler=1, but did not succeed. As soon as i add this startargument, the service can't be installed.

Alternatively i tried to active the event-scheduler in the option-file, but also without success. It is still set to 2 - suspended.

How to repeat:
mysqld-max-nt --install RSIMySQL --defaults-file=F:\MySQL\data\RSIMySQL.ini --event-scheduler=1

=> [ERROR] mysqld-max-nt: unknown option '--install'
[8 Nov 2006 12:35] MySQL Verification Team
Thank you for taking the time to write to us, but this is not a bug. Please double-check the documentation available at http://dev.mysql.com/doc/ and the instructions on
how to report a bug at http://bugs.mysql.com/how-to-report.php

http://dev.mysql.com/doc/refman/5.1/en/windows-start-service.html

"it is possible to use a single option other than --defaults-file, but this is discouraged. --defaults-file is more flexible because it enables you to specify multiple startup options for the server by placing them in the named option file."

C:\dbs\5.1\bin>mysqld-nt --install mysql2 --event-scheduler=1
Service successfully installed.

C:\dbs\5.1\bin>copy c:\mysql\my.ini c:\
        1 arquivo(s) copiado(s).

C:\dbs\5.1\bin>net start mysql2
O serviço de mysql2 está sendo iniciado.
O serviço de mysql2 foi iniciado com êxito.

C:\dbs\5.1\bin>mysql -uroot
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 2
Server version: 5.1.12-beta-community-nt MySQL Community Server (GPL)

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> show variables like "%event";
Empty set (0.00 sec)

mysql> show variables like "%event%";
+-----------------+-------+
| Variable_name   | Value |
+-----------------+-------+
| event_scheduler | ON    |
+-----------------+-------+
1 row in set (0.00 sec)

According the package you have installed see bug:
http://bugs.mysql.com/bug.php?id=24022
Thanks in advance.