bat备份mysql 数据库

@echo on

rem 跳转mysql的bin目录

cd C:\wamp\bin\mysql\mysql5.7.24\bin  
echo 当前路径:%cd%
rem 输出格式20191129
set dirname=%date:~0,4%%date:~5,2%%date:~8,2%

set year=%date:~0,4%
set month=%date:~5,2%
set day=%date:~8,2%

set backdir=C:\Users\user\Desktop\%dirname%
if exist %backdir%   ( 
	echo 存文件在
) else (
echo 文件夹不存在,创建文件夹%dirname%
md %backdir% 
 )

cd C:\wamp\bin\mysql\mysql5.7.24\bin 
rem  设置密码后不需要按回车
:mysqldump  -u root --password=  --default-character-set=gb2312 test danwei > C:\Users\user\Desktop\%dirname%\danwei.sql 

:主菜单
set /P psn=请输入数字(1备份数据库,0退出):
if /I "%psn%"=="1" goto 备份
if /I "%psn%"=="0" goto 退出

:返回
goto 主菜单


:备份
cls
mysqldump -u root --password= --default-character-set=gb2312 --where="updates like '%year%-%month%-%%'" test danwei >  C:\Users\user\Desktop\%dirname%\news1.sql
goto 主菜单


:退出
exit

pause