Detailed description of Navicat remote automatic MySQL backup (image and text) _ MySQL

Source: Internet
Author: User
Tags mysql backup
Detailed description of Navicat remote automatic MySQL backup (image and text) Navicat

BitsCN.com starts the navicat software and uses "link" to connect to the mysql database. ensure that the firewall can pass before use.

Navicat For MySQL:

Http://www.bitsCN.com/database/2223.html

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

Now the recovery is complete.

BitsCN.com

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.