Results 1 to 4 of 4
  1. #1
    Join Date
    Jul 2011
    Posts
    1

    Unanswered: MySql Event scheduler should be ON Permanently

    Hi,
    I want, event scheduler to be ON always. In the net I found the solution(Procedure).

    As they told, to write event_scheduler=on somewhere under the [mysqld] section in the default mysql config file, usually /etc/my.cnf

    First of all I didn't get the file my.conf in my machine(searched the whole machine). After search the whole machine I got my.conf.bak, my.cnf.old and one more file My (File Type is SpeedDial)

    So I have added the code (event_scheduler=on) in my.conf.bak file. And I have restarted the Mysql service also.
    But still the Event_scheduler is OFF.

    Thanks in advance

  2. #2
    Join Date
    Sep 2009
    Location
    San Sebastian, Spain
    Posts
    880
    Are you on Windows or Linux? And what version of MySQL are you running?
    Ronan Cashell
    Certified Oracle DBA/Certified MySQL Expert (DBA & Cluster DBA)
    http://www.it-iss.com
    Follow me on Twitter

  3. #3
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    you may need to stop the MySQL service, then make changes to the config file, then restart the MySQL service. Not saying MySQL does, but some software does write back its configuration on closing.
    I'd rather be riding on the Tiger 800 or the Norton

  4. #4
    Join Date
    Jul 2011
    Posts
    3
    Oh, man. How many times I have found the problem to be a necessary shutdown/reboot!! And, I still scratch my head sometimes before I realize it.

    Good advice!

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •