mysql 备份脚本

@echo off
:: 删除之前已经备份的文件
del D:/mysqldb_bak/bar_*.sql
:: 切换到MYSQL Bin目录
d:
cd  D:/Program Files/MySQL/MySQL Server 8.0/bin
:: MySQL备份文件名，根据年月日生成  
set filename=bar_%date:~0,4%%date:~5,2%%date:~8,2%%time:~0,2%.sql
:: MySQL 用户名 
set USERNAME=bar
:: MySQL 密码 
set PASSWORD=password
:: 要备份的数据库名称
set DATABASE=bar
::
mysqldump.exe -u%USERNAME% -p%PASSWORD% --default-character-set=utf8 bar> D:/mysqldb_bak/%filename%



@echo on