{"id":477,"date":"2014-06-08T14:40:57","date_gmt":"2014-06-08T14:40:57","guid":{"rendered":"http:\/\/localhost\/__sites\/3d_blog\/?p=477"},"modified":"2014-06-08T14:49:49","modified_gmt":"2014-06-08T14:49:49","slug":"mysql-event_scheduler-after-server-restart","status":"publish","type":"post","link":"https:\/\/blog.silverterra.net\/?p=477","title":{"rendered":"mysql event_scheduler after server restart"},"content":{"rendered":"<blockquote><p>Goal: to avoid the event_scheduler stopped after server restart<\/p><\/blockquote>\n<p>As I realized the events scheduler never working after my server restarted. The why is in the <strong>my.ini<\/strong> file.<br \/>\nFind the <strong>[mysqld]<\/strong> section and put the following line <strong>event_scheduler=ON<\/strong> like this. <\/p>\n<pre data-enlighter-language=\"sql\" class=\"EnlighterJSRAW\" data-enlighter-highlight=\"4\">\r\n...\r\n# The MySQL server\r\n[mysqld]\r\nevent_scheduler=ON\r\n...\r\n<\/pre>\n<p>So when the server restarted the event scheduler will be alive again.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Goal: to avoid the event_scheduler stopped after server restart As I realized the events scheduler never working after my server restarted. The why is in the my.ini file. Find the [mysqld] section and put the following line event_scheduler=ON like this. So when the server restarted the event scheduler will be alive again.<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[9],"tags":[],"class_list":["post-477","post","type-post","status-publish","format-standard","hentry","category-mysql"],"_links":{"self":[{"href":"https:\/\/blog.silverterra.net\/index.php?rest_route=\/wp\/v2\/posts\/477","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.silverterra.net\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.silverterra.net\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.silverterra.net\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.silverterra.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=477"}],"version-history":[{"count":6,"href":"https:\/\/blog.silverterra.net\/index.php?rest_route=\/wp\/v2\/posts\/477\/revisions"}],"predecessor-version":[{"id":483,"href":"https:\/\/blog.silverterra.net\/index.php?rest_route=\/wp\/v2\/posts\/477\/revisions\/483"}],"wp:attachment":[{"href":"https:\/\/blog.silverterra.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=477"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.silverterra.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=477"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.silverterra.net\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=477"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}