A-A+
mysql 数据库备份、压缩、ftp上传脚本
给大家介绍一个mysql的自动备份、压缩、ftp上传脚本;
环境,需要安装7zip。ftp可用。
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 |
@echo off set "Ymd=%date:~,4%%date:~5,2%%date:~8,2%" set ftpfile=D:backupputfile.ftp md "D:backup%ymd%" "D:Program FilesMySQLMySQL Server 5.5binmysqldump.exe" --opt --default-character-set=utf8 test -uroot -p123456 > D:backup%Ymd%esou4.sql "C:Program Files7-Zip7z.exe" a D:backup%ymd%.zip D:backup%ymd% rem ftp-address 是你的ftp地址 echo open ftp-address > "%ftpfile%" rem username 是你的ftp用户名 echo username >> "%ftpfile%" rem password 是你ftp 密码 echo password >> "%ftpfile%" echo bin >> "%ftpfile%" echo cd mysql-backup/test >> "%ftpfile%" echo put D:backup%ymd%.zip >> "%ftpfile%" echo bye >> "%ftpfile%" ftp -s:%ftpfile% del %ftpfile% del D:backup%ymd%.zip pause |