NavicatForMySQL remote automatic database backup method

NavicatForMySQL remote automatic database backup method. If you need it, please refer to it.

Navicat For MySQL remote automatic database backup method. If you need it, please refer to it.

Start the navicat software and use "Link" to connect to the mysql database. Ensure that the firewall can pass through

Then, enter a "connection name". Enter "host name/ip". Enter the ip address of the server where the mysql database is located. The user name and password are the root and password of the mysql database, usually xinwei.

　　

In this way, the "connection name" shortcut of the database can be listed on the left. After double-clicking, all the databases in mysql can be listed, which is equivalent to the "show databases" command. 172 .. 16.20.69:

　　

Click to select the database to be backed up, and then click the last scheduled task to be translated as a scheduled task ".

　　

Click Create Batch Processing Task

　　

In the new window that appears, double-click "Backup [database name]" in the available task. In the "select Task" box below, the selected "Backup [database name]" is the Backup database. Compared to the wakawaka Database

　　

Click "save" and enter a file name, such as chuxuefeng-wakawaka.

　　

Return to the Navicat for MySQL window and open the "Project Task" of the hl2 library ". You will see an additional chuxuefeng-wakawaka in the project task. Right-click chuxuefeng-wakawaka and select "Set Project Task ".

　　

Select the "Plan" page in the new window to create a new plan. In the advanced options, you can select duplicate tasks.

　　

Enable the advanced option to set the number of backup times per hour. You can set the maximum duration to 9999 hours, which can be set to backup every 3 hours per day. In fact, you can set the backup time to 0: 00 every day. The specific time interval depends on your server.

　　

After the scheduled task is set. The system requires you to enter the administrator password for the windows host.

Now, the database with scheduled tasks is automatically backed up once every specified period of time. The names of automatic backup files are sorted by time and backed up by the name you set. If you want to recover the backup ,! You can restore data by time.

　　

To recover data, double-click the backup file and click Start to restore the data.

For example:

　　

▲Backup recovery prompt

　　

▲Recovery process prompt