mysql 远程dump_本地dump备份mysql,ftp到远程windows服务器

@echo off

::backup the sqlserver db

md "e:\mybackup\data%date:~0,10%"

net stop MSSQLserver

copy D:\ap.web\data e:\mybackup\data%date:~0,10%

net start MSSQLserver

::backup the mysql db

"C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqldump" --opt -uroot -pyuxun@80 dn2 > e:\mybackup\data%date:~0,10%"\%date:~0,10%_dn2.sql

"c:\Program Files\WinRAR\Rar.exe" a -k -r -s -m1 e:\mybackup\data%date:~0,10%.rar e:\mybackup\data%date:~0,10%

::pasue

::wait press any key to continue

::ready to delete

:: transfer the file to server via ftp

echo open 192.168.x.22>e:\ftp.txt

echo user backup>>e:\ftp.txt  #用户

echo **>>e:\ftp.txt          #密码

echo bin>>e:\ftp.txt     #二进制

echo cd hy>>e:\ftp.txt  #服务端目录

echo put e:\mybackup\data%date:~0,10%.rar>>e:\ftp.txt

echo bye>>e:\ftp.txt

ftp -n -s:e:\ftp.txt

::pause

::clean the tmp files

del e:\ftp.txt

del e:\data%date:~0,10%.rar