Navicat for MySQL regularly backs up database and data recovery, navicatmysql

Navicat for MySQL regularly backs up database and data recovery, navicatmysql

Database modification or deletion may result in data errors or even database crashes. Effective regular backup can effectively protect the database. This article mainly describes Navicat for MySQL's timed backup database and data recovery functions, as well as the ability to regularly play movies and other settings, and hope to help you. If there are errors or deficiencies in this article, also, haihan ~
 

I. Set scheduled tasks to regularly back up databases

Scheduled tasksIt is to let the computer execute the specified action within the specified time. These actions can be a program or a batch, but at least they can run! In fact, it is more common that you double-click an object at that time.

1. First, create the database hcpmanage and table information to record the ticket information.

 

2. Click "task"-> "create batch job", as shown in.

 

3. In the displayed dialog box, double-click the available task "Backup hcpmanage" and select the task. Click "save" and set it to "20170418bf ".

4. the backup file will appear in the scheduler list, as shown in.

 

5. Click 20170418bf to set the scheduled task, as shown in.

6. In the pop-up plan, set the daily backup operation at, as shown in.

 

7. Click "application". In the pop-up "Set account information", enter the boot password and click "OK.

The common settings are as follows, including task scheduling, idle time, and power management.

 

8. The database performs regular backup at every day. The backup file is in the "Windows/System32/Tasks" task path, as shown in.

 

The path for the other psc file to be backed up is Navicat \ MySQL \ servers \ test \ hcpmanage (connection-database ).

 

Note: When you enter the boot password, the system will often report "an error occurs when the task scheduler tries to set the task account information", as shown in. For the solution, see section 3.

 

 

2. database recovery

Assume that the database has been destroyed and the table information has been deleted, and now the database needs to be restored through alignment.

1. Click "backup"-> "Restore backup", as shown in.

 

2. It will pop up by default to find the corresponding database and select the psc file, as shown in.

 

3. "Restore backup" is displayed, and the backup file is created at. Click "start.

4. Then, the data is restored successfully and the "Information log" is displayed, as shown in.

 

5. Data is restored successfully. Other methods are similar.

 

 

Iii. troubleshooting of Task Scheduler errors

 

An error is always reported when you enter the user name or password, especially when the password is empty, as shown in the following figure. How can this error be solved?

1. In "service" (cmd command services. msc), "Task Scheduler" needs to be started.

2. In "local policy" (command gpedit. msc in cmd) "Security Options", you must Disable"Account: A local account with an empty password can only log on to the console ". Disable, as shown in. Source: http://blog.csdn.net/eastmount/article/details/70239244