Today, after a database drop-in event, I immediately feel it is important to back up the database regularly.
But it's too much trouble to make a manual backup every day, so I think it's time to use scheduled tasks for automatic daily backups.
Found that Navicat comes with a backup can also be directly scheduled tasks, thieves convenient. The method below.
Open the Navicat client, and after you connect to MySQL, double-click the database you want to back up on the left. Tap Schedule, and then tap New batch job.
Now on the left, select the database you want to back up, then double-click on the available tasks on the right, and it will go to the list below, representing the task you chose.
Click Save, Pop up a naming dialog, give the task a name, and click "OK".
Click "Set up" to schedule the task.
This is set to back up the database every morning at nine O ' Day from December 4, 2017. If you want to increase the backup frequency, or set a backup deadline, click Advanced.
Finally, enter your computer password and you're done.
Use NAVICAT for automatic database backup