win-MySQL备份之mysqldump脚本

脚本 1
@echo off
: 根据当前日期输出文件（不推荐，重复运行就覆盖了）
set date=%date:~0,4%%date:~5,2%%date:~8,2%
set dbA=db12306
set user=user12306
set passwd=pwd12306
set mysqldump=D:\mysql5.7\server\bin\mysqldump
set host=127.0.0.1
set path=D:\mysqlbackup

 %mysqldump% -u%user% -p%passwd%  -h%host%  --single-transaction  %dbA%  > %path%\%dbA%-bak%date%.sql

echo    --------------The end -------------------
cd C:\Windows\System32
ping -n 3 127.1>NUL

exit

********************************************************************************************************************************

脚本 2 
 @echo off

: ------------ 获取当前时间格式-精确到秒 ----------------
set time_first="%time:~0,1%"
if %time_first%==" " (
	set date_time=%date:~0,4%%date:~5,2%%date:~8,2%_0%time:~1,1%%time:~3,2%%time:~6,2%
)else ( 
	set date_time=%date:~0,4%%date:~5,2%%date:~8,2%_%time:~0,2%%time:~3,2%%time:~6,2%
)

: ------------ time_first 变量判断时间第一个字符是否为空格，0-09的时候会出现，需要在前面加上0

echo  %date_time%

set dbA=db12306
set user=user12306
set passwd=pwd12306
set mysqldump=D:\mysql5.7\server\bin\mysqldump
set host=127.0.0.1
set path=D:\mysqlbackup

 

%mysqldump% -u%user% -p%passwd%  -h%host%  --single-transaction  %dbA%  > %path%\%dbA%-bak%date_time%.sql

 echo    --------------The end -------------------
 cd C:\Windows\System32
ping -n 3 127.1>NUL
exit