How to regularly back up mysql using bat scripts in Windows

Not all MySQL instances run in Linux, but routine backup is also required in windows. The following is an example of automated backup using the bat script.

Rem

Rem C: The Program FilesWinRAR must be placed under the path to call the rar cli tool.

Rem

Redirect rem to the working directory

F:

Cd f: DBBAK

Rem setting variable: Backup File Name

SET BAK_FILE = MY_DBBAK _ % date :~ 0,-4%. SQL

Rem setting variable: Log File Name

SET LOG_FILE = MY_DBBAK.log

Rem record log

Echo "% date %" % LOG_FILE %

Rem starts backup

Mysqldump -- default-character-set = utf8-hlocalhost-uroot-R -- triggers -- single-transaction-B mydb> % BAK_FILE %

Rem compressed backup file

Rar a packet bak_file).rar % BAK_FILE %

Rem Delete source file

Del/F % BAK_FILE %

Echo "% date %" % LOG_FILE %

Echo "" "% LOG_FILE %

After the script is deployed, add the "scheduled task" project to the system.