Shulou(Shulou.com)05/31 Report--

Editor to share with you the method of navicat setting regular backup, I believe that most people do not know much about it, so share this article for your reference, I hope you can learn a lot after reading this article, let's go to know it!

The specific steps are as follows:

1. Click backup-> create a backup

2. Object selection; you can select the table to be backed up or not, select all by default; then click Save; enter the file name; note that the pop-up box will not disappear, this is a backup task has been generated

3. Click Plan-> New batch Plan

4. Double-click the plan to be selected, and the plan of your choice will appear in the distribution of the selected task. At this time, the plan has been generated and there is no prompt.

5. Click the object to return-- > Click the task to be performed-- > set the scheduled task.

6. Select a plan-- > create a new plan. I'm here because I already have a plan that doesn't show-- > Click on App-- > enter your computer password.

7. Regular backup

There is an advanced option on the new plan page, select Advanced; check the repetitive task, set how often to execute, duration, and finally click apply.

8. Backup file storage location; select your backup database under servers, and then select the data source to enter it. You can see that the generated file ends with psc. You can choose to extract sql in navicat to convert psc files into sql files.

9. Backup, restore and convert sql files

Click backup, there is a backup restore and extract sql to see the name will understand

The above is all the contents of this article "how to set up scheduled backups in navicat". Thank you for reading! I believe we all have a certain understanding, hope to share the content to help you, if you want to learn more knowledge, welcome to follow the industry information channel!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.