windowds下备份MySQL(mysqldump)

@echo off
set backup_date=%date:~0,4%%date:~5,2%%date:~8,2%
set db_name=db_test01 db_test02 db_test03
for %%i in (%db_name%) do (mysqldump -h localhost -uroot -pmysql -P13306 %%i --default-character-set=utf8 --set-gtid-purged=OFF --skip-tz-utc --skip-disable-keys --skip-add-locks --single-transaction --master-data=2 >D:\mysqlbak\%%i_%backup_date%bak.sql)
pause