Set up automatic MySQL database backup

MySQL implementation database is automatically backed up in Windows, as required by the project. After data query and attempt, there are two ways to obtain the method:

1. Use a task schedule that comes with Windows, and then schedule a script to perform a database backup.

2. Navicat The backup of the configuration database using the MySQL management tool

Here, because the second method is relatively simple and practical, I will briefly describe the second method (because it is simple).

Tools:

Navicat for MySQL

MySQL 5.5

Steps:

1. Open the Navicat client, connect to MySQL, double-click the database you want to back up on the left. Tap Schedule, and then tap New batch job.

.

2. Double click on the available tasks above, it will go to the following list, on behalf of you chose this task.

.

3, click Save, Pop up a naming dialog box, give the task a name, click "OK".

.                      

4. Click "Set up" to schedule the task.

.                       

5. Pop Up the dialog box, select "Schedule", and then click "New".

.                    

6. This is set to back up the database at nine a.m. every morning from January 24, 2014 onwards. If you want to increase the backup frequency, or set a backup deadline, click Advanced.

.                 

7, advanced options can be more granular backup settings, such as this is set in 24 hours every 2 hours to back up once. In addition to the previous basic setup, the task plan is: from January 24, 2014 onwards, every 2 hours every nine o'clock, backup every day, the daily backup lasts 24 hours.

.                           

8. Finally, enter your computer password and you are done.

Set up automatic MySQL database backup