Navicat for MySQL Offsite automatic backup Database method

Start Navicat software, use "link" to connect MySQL database, before use, please ensure that the firewall can pass

Then pop up, random up a "connection name"; enter "host name/IP" Here, fill in the MySQL database server IP address, username password for the MySQL database root and password, under normal circumstances for Xinwei.

　　

So the left side can list the database "Connection name" shortcut, double click can list this mysql inside all the database, equivalent to "Show Databases" command. As shown in Fig. 172. 16.20.69 this:

　　

Click to select the database you want to back up, and then point to the last "scheduled task" translation as "Project task." As shown in figure:

　　

Click Create Batch Processing Task

　　

In the new window that pops up, double-click the backup database name "in the available task, and in the Select Tasks box below, the selected backup database name" is the backup library. such as the Wakawaka database in the diagram

　　

Click "Save" and enter a filename like Chuxuefeng-wakawaka.

　　

Return to the Navicat for MySQL window and open the HL2 Library's "Project task." You'll see a Chuxuefeng-wakawaka in the project, right click on the Chuxuefeng-wakawaka, and select "Set up a project task."

　　

Select the Schedule page in the new window to create a new plan. In advanced options, you can check for duplicate tasks.

　　

Open Advanced options, you can set the backup time every hour, duration can choose the maximum 9,999 hours, can be set up every 3 hours a day to back up. In fact, you can usually set the 0:00 backup every day on the line. The specific time interval depends on your server situation.

　　

After you set up the scheduled task. The system will require you to enter the administrator password for the Windows local computer.

Now the database of the scheduled task is automatically backed up every once in a while, and the file name of the automatic backup is sorted by time, and the names are backed up according to the name you set. If you need to restore the backup, you can recover the data by time.

　　

If you need to recover the data, double-click the backup file and click "Start" to recover the data.

The following figure:

　　

▲ Backup Recovery Tips

　　

▲ Tips for Recovery procedures