Windows下mysql备份脚本
设置备份出来的脚本名示例:mysqlbk_20200910_153000.sql
@echo off
set "Ymd=%date:~,4%%date:~5,2%%date:~8,2%"
if /i %time:~0,2% lss 10 set hh=0%time:~1,1%
if /i %time:~0,2% geq 10 set hh=%time:~0,2%
set mn=%time:~3,2%
set ss=%time:~6,2%
set date=%yy%%mm%%dd%
set time=%hh%%mn%%ss%
C:/xampp/mysql/bin/mysqldump --opt -u root --password=abcdABCD123@#$ mysqldbname > D:/db_backup/mysqlbk_%Ymd%_%time%.sql
@echo on