Use Navicat to regularly back up MySQL databases and create reports and send messages automatically

Database backup is becoming more and more important today because of the high speed development of modern computers, programmers tend to neglect backup data because they don't pay attention to it, which leads to the loss of data, which results in very serious consequences. Scheduled backup is undoubtedly the best way to solve the backup, this article mainly uses Navicat to get back to the database and create related scheduled tasks.

(i) Use Navicat to automatically back up the database:

1, Open the Navicat client, connect to MySQL, double-click the database you want to back up on the left. Click on "Schedule" and click "New batch Job" as specific.

650) this.width=650; "Src=" Http://s4.51cto.com/wyfs02/M00/8B/5E/wKiom1hKeOPhrHlnAAE34KFKaMA475.png-wh_500x0-wm_3 -wmp_4-s_2192875794.png "title=" 1.png "alt=" Wkiom1hkeophrhlnaae34kfkama475.png-wh_50 "/>

2, Double click on the available tasks above, it will go to the following list, also means that you chose this task

650) this.width=650; "Src=" Http://s1.51cto.com/wyfs02/M00/8B/5A/wKioL1hKehDQlpqiAAIjypMTYEU529.png-wh_500x0-wm_3 -wmp_4-s_2964861491.png "title=" 2.png "alt=" Wkiol1hkehdqlpqiaaijypmtyeu529.png-wh_50 "/>

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

650) this.width=650; "Src=" Http://s1.51cto.com/wyfs02/M01/8B/5A/wKioL1hKernzEzvyAAHaLRCrArI050.png-wh_500x0-wm_3 -wmp_4-s_275069078.png "title=" 3.png "alt=" Wkiol1hkernzezvyaahalrcrari050.png-wh_50 "/>

4, click " set up Scheduled Tasks", click on the Schedule tab, define the time of day around four o'clock in the morning backup can also create more than one scheduled task, etc., determine after entering the local administrator's user name and password, automatic backup settings completed.

650) this.width=650; "Src=" Http://s4.51cto.com/wyfs02/M01/8B/5E/wKiom1hKe-DTP-kjAAFmhr9Ba6w213.png-wh_500x0-wm_3 -wmp_4-s_1962787776.png "title=" 5.png "alt=" Wkiom1hke-dtp-kjaafmhr9ba6w213.png-wh_50 "/>

650) this.width=650; "Src=" Http://s4.51cto.com/wyfs02/M01/8B/5E/wKiom1hKfCzSArPBAACDeZXUr5k635.png-wh_500x0-wm_3 -wmp_4-s_2475944065.png "title=" 6.png "alt=" Wkiom1hkfczsarpbaacdezxur5k635.png-wh_50 "/>

5, to send their own mailbox backup information related configuration

650) this.width=650; "Src=" Http://s2.51cto.com/wyfs02/M02/8B/5E/wKiom1hKfpHijalgAAHOmuxHt3w056.png-wh_500x0-wm_3 -wmp_4-s_2603797315.png "title=" Qq20161209174920.png "alt=" Wkiom1hkfphijalgaahomuxht3w056.png-wh_50 "/>

6, click Start, and the backup of the database you just created is left to perform the backup operation.

650) this.width=650; "Src=" Http://s3.51cto.com/wyfs02/M02/8B/5A/wKioL1hKfxST-YnAAAFl9kUzpIM575.png-wh_500x0-wm_3 -wmp_4-s_3495863315.png "title=" 7.png "alt=" Wkiol1hkfxst-ynaaafl9kuzpim575.png-wh_50 "/>

This is done by using Navicat to automatically back up the database.

(ii) Use NAVICAT to create a report and automatically send attachments to the specified mailbox.

1, select the appropriate database, select the report, and create a new report.

650) this.width=650; "Src=" Http://s1.51cto.com/wyfs02/M02/8B/5E/wKiom1hKgjOCiawCAAFqt9zctgI840.png-wh_500x0-wm_3 -wmp_4-s_178632656.png "title=" 8.png "alt=" Wkiom1hkgjociawcaafqt9zctgi840.png-wh_50 "/>

2, select in the new report: Data--FILE--new--Query Designer--sql--Click "Edit SQL" in the blank to paste the query statement into the SQL, figure one, figure two, figure III, figure four.

650) this.width=650; "Src=" Http://s2.51cto.com/wyfs02/M00/8B/5A/wKioL1hKhJrRBn6tAADlXbKY_Wc838.png-wh_500x0-wm_3 -wmp_4-s_2689898290.png "title=" 3.png "style=" Float:none; alt= "Wkiol1hkhjrrbn6taadlxbky_wc838.png-wh_50"/>

Figure A

650) this.width=650; "Src=" Http://s1.51cto.com/wyfs02/M00/8B/5E/wKiom1hKhJnRlTHpAAB173meXLs765.png-wh_500x0-wm_3 -wmp_4-s_30612851.png "style=" Float:none; "title=" 1.png "alt=" Wkiom1hkhjnrlthpaab173mexls765.png-wh_50 "/>

Figure II

650) this.width=650; "Src=" Http://s1.51cto.com/wyfs02/M02/8B/5A/wKioL1hKhJiDS5ZWAACkfmKfs78894.png-wh_500x0-wm_3 -wmp_4-s_781850770.png "title=" 4.png "style=" Float:none; alt= "Wkiol1hkhjids5zwaackfmkfs78894.png-wh_50"/>

Might

650) this.width=650; "Src=" Http://s2.51cto.com/wyfs02/M00/8B/5A/wKioL1hKhJnBBRIWAADe9xf2wBQ165.png-wh_500x0-wm_3 -wmp_4-s_4058365919.png "title=" 2.png "style=" Float:none; alt= "Wkiol1hkhjnbbriwaade9xf2wbq165.png-wh_50"/>

Figure Four

3, Design reports, click on the design, the data query out the top of the Lela, see

650) this.width=650; "Src=" Http://s2.51cto.com/wyfs02/M02/8B/5E/wKiom1hKhpCBFCrhAAET22SeQg8584.png-wh_500x0-wm_3 -wmp_4-s_420176064.png "title=" 5.png "alt=" Wkiom1hkhpcbfcrhaaet22seqg8584.png-wh_50 "/>

4, preview the report, click Preview and adjust the corresponding dimensions to achieve your own satisfaction and keep (Ctrl + S).

650) this.width=650; "Src=" Http://s1.51cto.com/wyfs02/M00/8B/5E/wKiom1hKhwPyZ7qHAAD_lcgQ7ZE241.png-wh_500x0-wm_3 -wmp_4-s_519588167.png "title=" 6.png "alt=" Wkiom1hkhwpyz7qhaad_lcgq7ze241.png-wh_50 "/>

5, New schedule: Plan-New batch job, see table below.

650) this.width=650; "Src=" Http://s1.51cto.com/wyfs02/M02/8B/5E/wKiom1hKimTjDZryAAHrwWltyCQ805.png-wh_500x0-wm_3 -wmp_4-s_2760744996.png "title=" 7.png "alt=" Wkiom1hkimtjdzryaahrwwltycq805.png-wh_50 "/>

6, go to the Advanced tab for the relevant settings, see.

650) this.width=650; "Src=" Http://s2.51cto.com/wyfs02/M02/8B/5B/wKioL1hKi3nieHF5AADD2r3rxc8261.png-wh_500x0-wm_3 -wmp_4-s_1050409808.png "title=" 8.png "alt=" Wkiol1hki3niehf5aadd2r3rxc8261.png-wh_50 "/>

7, open the mailbox to receive the relevant information, to use NAVICAT to create a report and send a message to complete, I hope that you are helpful.

650) this.width=650; "Src=" Http://s5.51cto.com/wyfs02/M00/8B/5B/wKioL1hKi-6TKIarAABZ6HGMiAA389.png-wh_500x0-wm_3 -wmp_4-s_1163023100.png "title=" 9.png "alt=" Wkiol1hki-6tkiaraabz6hgmiaa389.png-wh_50 "/>

This article is from the "Breght Moon" blog, make sure to keep this source http://liqingbiao.blog.51cto.com/3044896/1881314

Use Navicat to regularly back up MySQL databases and create reports and send messages automatically