mysql 备份 压缩 ssh 上传

@echo off

set "Ymd=%date:~0,4%%date:~5,2%%date:~8,2%"

echo  >> run.log
echo %Ymd%================================= >> run.log

forfiles /p "D:\bakdb" /m db1_*.* -d -30 /c "cmd /c del /f @path" >> run.log

echo ******  MySQL backup start     ******** >> run.log
D:\mysql-5.7.16-winx64\bin\mysqldump --opt --single-transaction=TRUE --user=root --password=abc123^-^= --host=127.0.0.1 --protocol=tcp --port=3306 --default-character-set=utf8  --routines "db1" > D:\bakdb\db1_%Ymd%.sql
echo ******  MySQL backup completed ******** >> run.log

ping 127.0.0.1 -n 2 > nul

echo ******  zip start     ******** >> run.log
"C:\Program Files\7-Zip\7z.exe" a db1_%Ymd%.zip db1_%Ymd%.sql >> run.log
echo ******  zip completed ******** >> run.log

ping 127.0.0.1 -n 2 > nul

del db1_%Ymd%.sql >> run.log

echo ******  scp start      ******** >> run.log
"C:\Program Files\PuTTY\pscp.exe" -l root -pw abc135 -P 5252 db1_%Ymd%.zip 119.119.119.*:/data/bak/ >> run.log
echo ******  scp completed  ******** >> run.log

@echo on