From the course: Learning phpMyAdmin

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Scheduling events

Scheduling events

From the course: Learning phpMyAdmin

Start my 1-month free trial

Scheduling events

“

- MySQL has an event scheduler that runs database operations automatically, either on a one off basis or at regular intervals. You can run a simple query to find out whether the event scheduler is enabled. I'm going to run this in my local installation of phpMyAdmin, but you should run this on your remote server if you want to schedule events there. So I'm going to go to the SQL tab and then the query that I want is, show variables like, and then in quotes event_scheduler. And just run that by clicking Go. And here is the result. Event_scheduler and the value is off. If the value is off like this, you won't be able to schedule events unless you can log into your server with superuser privileges. If the value is disabled you won't be able to run events even with superuser privileges. In either case, you should contact your hosting company or server administrator to ask for the even scheduler to be turned on. Even though the event scheduler is turned off in my local version of…

Contents