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

This article will explain in detail how to use Navicat to plan tasks to back up mysql database. The editor thinks it is very practical, so I share it with you as a reference. I hope you can get something after reading this article.

As shown in the figure, together with the system database, there are a total of 12 databases. Now let's introduce how to back up all these 12 databases:

Click "Plan"-> "New batch Job"

There is a backup action of "Backup Server Localhost MySQL 5.6" by default. Then double-click it, and it is added to the following schedule queue:

Then click "Save", pop up the dialog box to set the file name, and enter the name of the plan.

After saving, set scheduled tasks on the taskbar becomes available.

Click "set scheduled tasks" and the dialog box for settings pops up. Now the password is set under the "Task" tab, which is the login password of the computer where the database is located.

Then set the schedule run time, under the "schedule" tab, click "New", and then set the specific running frequency and time point.

After setting up, and after the plan has been run, take a look at the effect of the backup. The location of the backed up files is:

"my documents"-> "Navicat"-> "MySQL"-> "servers"-> "Localhost MySQL 5.6". There are 12 folders corresponding to the data.

Take the sampledb folder as an example, which generates a 140529110822.psc file that contains the data of the library. Later can be used to restore, restore the steps will not be introduced, a very simple operation.

* * *

The above backup method is the backup of the entire database system, of course, you can also specify a database for backup, the operation is the same.

If you log in to the computer that does not need a password, if there is an error in the following 0x80070005, follow the solution below. If your computer has a password, it is in the

When setting the password here, it should be the same as the password of the computer where the library is located.

#

Question 2:

Prompt when the creation schedule task is complete: "A new task has been created, but may not run because account information cannot be set. The specified error is: 0x80070005: access denied. Try using the tasks browse button to locate the application."

Specified error: 0x80070005: access denied, the main reasons are as follows.

1. If you use a blank password when logging in to Windows (that is, the password of the current user is an empty password, or the user you specified is an empty password), you should change the "account: local accounts with blank passwords only allow console login" in the group policy to "disable". For specific steps, please find the following order.

Open the start menu on the taskbar, then click, run, enter gpedit.msc and enter enter to open the Group Policy Editor, then expand "computer configuration-> windows Settings-> Security Settings-> Local Policy-> Security options" on the left, and then find in the box on the right: "account: local accounts with blank passwords are only allowed to log on to the console" to "disable".

2, may not have enough permissions or are prohibited, the specific action is to open the start to run-> enter gpedit.msc to open the Group Policy Editor.

* check whether there are corresponding names for several items that users are prohibited from accessing in the user rights assignment of the group policy!

* Select computer configuration-> windows Settings-> Security Settings-> Local Policy-> user Rights assignment double-click to access this computer from the network to add the required user name to the list.

* Select computer configuration-> Windows Settings-> Security Settings-> Local Policy-> double-click the domain controller on the right side of the security option: allow server operators to schedule tasks and open and enable them.

There are many reasons for this failure, the most easy to think of is the lack of system management rights, the most likely to be ignored is the security policy, or do not know which functions in the security policy are related to access control. One of the items "denying access to this computer from the network" is worth noting.

Some friends add Everyone when setting the security policy of "deny access to this computer from the network". Although this increases the security level, it inadvertently brings trouble to the configuration of the scheduled task, especially when changing the password in the properties of the scheduled task.

This is the end of this article on "how to use Navicat to plan tasks to back up mysql database". I hope the above content can be of some help to you, so that you can learn more knowledge. if you think the article is good, please share it out for more people to see.

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.