Back up the database with Bak file under Windows

Copy and place the following code into the TXT file.

/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*/*

@echo off
Echo.
echo MySQL Database backup

Echo *****************************
Echo.
Echo is%date% today.
Echo Time is%time%
Echo.
Echo *****************************


Set "ymd=%date:~,4%%date:~5,2%%date:~8,2%"

MD "D:\JDBC\%Ymd%"

"C:\Program files\mysql\mysql Server 5.1\bin\mysqldump"--opt-q-uroot-pabc123--default-character-set=latin1 Test > "D:\JDBC\%Ymd%\test_bak.sql"

Echo.

echo MySQL database backup complete, please check ...

Echo.
Echo.

Pause

Note Modify the file that the database bin path and database password will be backed up

Then modify the suffix to Bak file and double click to complete

You can then add a task execution plan under Windows, and the departure test

Back up the database with Bak file under Windows