Window自动备份Mysql数据库

@echo off
for /f "tokens=1-3 delims=/ " %%a in ('date/t') do (
    set year=%%a
    set month=%%b
    set day=%%c
)
for /f "tokens=1-3 delims=: " %%a in ('time /t') do (
  set tm=%%a-%%b
)
set backuptime=%year%-%month%-%day%_%tm%

set backupfile=数据库备份文件存放目录\%backuptime%.sql
set mysqldumpexe="C:\Program Files\MySQL\MySQL Server 8.0\bin\mysqldump.exe"
set mysqluser=root
set mysqlpassword=root
set databasename=备份的数据库

%mysqldumpexe% -u %mysqluser% -p%mysqlpassword% %databasename% --skip-extended-insert > %backupfile%

# mysqldumpexe= 注意查看你自己的Mysql装在哪，默认在这个目录
# --skip-extended-insert 导出的数据是一条一条的INSERT语句