Hi all,
I am a new user for phpMyAdmin.
Before that, I created my database in my own pc using SQLyog. I also created an event scheduler so that it can delete records which are older than 60 days automatically.
Now, i backup the whole database as sql dump and import into phpMyAdmin. However, I cant find where is that event scheduler was located.
I tried to run a query: SET GLOBAL event_scheduler = ON;
but the system returns me: #1193 - Unknown system variable 'event_scheduler'
I checked in the Server variables and settings for my database in phpMyAdmin, there are no "event scheduler" in the list.
May I know how can I solve this problem?
Thanks in advance.
Regards,
Lee
