LCKB
Cash minutes - Printable Version

+- LCKB (https://lckb.dev/forum)
+-- Forum: ** OLD LCKB DATABASE ** (https://lckb.dev/forum/forumdisplay.php?fid=109)
+--- Forum: Guides & Help Section (https://lckb.dev/forum/forumdisplay.php?fid=193)
+---- Forum: Help & Support (https://lckb.dev/forum/forumdisplay.php?fid=157)
+----- Forum: General Support (https://lckb.dev/forum/forumdisplay.php?fid=203)
+------ Forum: Solved topics (https://lckb.dev/forum/forumdisplay.php?fid=159)
+------ Thread: Cash minutes (/showthread.php?tid=4387)

Pages: 1 2 3


- Wizatek - 01-13-2015

You have to make sure tje event scheduler is running.




- camaro2683 - 01-13-2015

Hi wizatek thank you for ur help can u please tell me how i can start up the even scheduler and make it run?




- Wizatek - 01-13-2015

2


- camaro2683 - 01-13-2015

once the scheduler gets enabled does the server need rebooted?




- Wizatek - 01-13-2015


You can enable it on 2 ways.

1 via a query, that will only run until the server is rebooted.

1 via my.cnf but that requires the server to restart.

 

So if you run the query, and add it to my.cnf without restarting yet, then you are set




- DamonA - 01-13-2015


Example:
Open Navicat

Open newproject_db_auth

Press F6 (for console)
Insert Query 
Press Enter
finished




- Assasin - 01-13-2015


Simle thx Wiza :-)

 

First 

mysql> SET GLOBAL event_scheduler = ON;

End

service mysqld restart




- camaro2683 - 01-13-2015


@Assassin Do we do these in putty or do it in navicat mysql?

 

Simle thx Wiza :-)

 

First 

mysql> SET GLOBAL event_scheduler = ON;

End

service mysqld restart




- WorldOfWars - 01-13-2015

first navicat, second putty




- Assasin - 01-13-2015


@Assassin Do we do these in putty or do it in navicat mysql?

TuT

http://youtu.be/CYWvQXsW3LM