O'Reilly logo

MySQL Management and Administration with Navicat by Gokhan Ozar

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Using Navicat’s event designer for MySQL

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required