As of Version 5.1.6, the Event Scheduler feature of MySQL was introduced, which lets you design scheduled tasks. An event in MySQL is a scheduled task consisting of one or more SQL statements to be executed at certain intervals, beginning, and ending at specific dates and time.
In this section, I’ll show you how to create a scheduled event that will back up our employee table, which will recur at specific intervals. As a prerequisite, we need to make sure that MySQL’s global event scheduler is active (which is disabled by default).
For this, select Console from the Tools menu in Navicat’s main window to get a command-line access to the MySQL server, as shown in the following screenshot:
While in the localhost ...