Friends, do you know how to create a backup plan in Navicat for MySQL? Today I will explain the tutorial on creating a backup plan in Navicat for MySQL. If you are interested, come and take a look with me. I hope it can help you.
Step 1: Set up scheduled batch processing job
Example of setting up a scheduled batch job
As shown in the picture above, select the database to be backed up in the [General] navigation bar on the left, then click the [Save] button and give it a nice name, such as back. After saving this batch job, you can set a scheduled task for it.
Step 2: Set up scheduled tasks
In the view window of the batch job, after clicking the [Set Scheduled Task] option button, a dialog box will pop up. All the time settings we need to plan are completed in this view. Click the [New] button to create a new plan, and select the execution period of the plan from the drop-down list of [Planned Task]: daily/weekly/monthly, etc.
Set scheduled tasks in the view window of the batch job
The following is a screenshot of each week as an example:
Example of setting up weekly scheduled tasks
After setting the plan execution time, click the "Apply" button to browse, and finally click the "OK" button to complete the setting.
As long as we do a good job in database backup management, we don’t have to worry about database failures. Of course, even if the backup work is foolproof, we don’t want problems with the database.
The above is the tutorial for creating a backup plan for Navicat for MySQL brought to you by the editor.All the content, I hope it can help everyone.
