mysql异地备份批处理_Widnows批处理异地备份数据

@echo off

@title Mysql+fileBckup

set files=D:\backup\%date:~0,10%.rar

set userdb="root"

set pwddb="123456"

set filepath="D:\wwwroot"

set ftpfile="C:\ftp.txt"

set ftpname=ftpuser

set ftppwd=ftpuser

set ftpfiles="%date:~0,10%.rar "

set ftpdomian="42.51.153.157"

set rarpath="C:\Program Files\WINRAR"

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

@echo 开始backup Mysql

md "D:\backup\%Ymd%.mysq l"

"D:\phpStudy\MySQL\bin\mysqldump.exe" --opt -Q -uroot -p123456 --default-character-set=utf8 discuz > "D:\backup\%Ymd%.mysql\discuz.sql"

"D:\phpStudy\MySQL\bin\mysqldump.exe" --opt -Q -uroot -p123456 --default-character-set=utf8 dede > "D:\backup\%Ymd%.mysql\dede.sql"

"D:\phpStudy\MySQL\bin\mysqldump.exe" --opt -Q -u root -p123456 --default-character-set=utf8 weixin > "D:\backup\%Ymd%.mysql\weixin.sql"

@echo 开始压缩文件

C:

cd C:\Program Files\WINRAR

RAR.EXE a -r -y %files% %Ymd% %filespath% D:\wwwroot

@echo 写入文件ftp

@echo %ftpname%>%ftpfile%

@echo %ftppwd%>>%ftpfile%

@echo put %files% %ftpfiles%>>%ftpfile%

@echo bye>>%ftpfile%

@echo 上传%files%.rar文件

ftp -s:%ftpfile% 42.51.153.157

cd C:\Documents and Settings\Administrator\桌面

echo %date% 备份成功

pause

C:\ftp.txt 内容

ftpuser

123456

put D:\backup\%date:~0,10%.rar

bye