BAT（备份mysql及打包rar）
set "Y=%date:~,4%" set "m=%date:~5,2%" set "d=%date:~8,2%" md "D:\mysql_bak\%Y%\%m%" "D:\AppServ\MySQL\bin\mysqldump.exe" --defaults-file="D:\appserv\mysql\mysqldump-user.ini" -uroot test > D:\mysql_bak\%Y%\%m%\test_%Y%%m%%d%.sql copy D:\mysql_bak\%Y%\%m%\test_%Y%%m%%d%.sql D:\AppServ\www\auto_backup_bat\mysql_test.sql start C:\"Program Files"\WinRAR\WinRAR.exe a D:\AppServ\www\auto_backup_bat\web_test.rar_bz D:\AppServ\www
.HTACCESS（限制指定后缀文件，只能指定IP访问）
<Files ~ ".(sql|rar_bz)$"> order deny,allow deny from all allow from 10.64.200.17 allow from 10.64.8.200 </Files>
BAT（远程下载）
set "Y=%date:~,4%"
set "m=%date:~5,2%"
set "d=%date:~8,2%"
md "F:\Auto_download\%Y%\%m%\%d%"
powershell (new-object System.Net.WebClient).DownloadFile('http://10.64.8.100/auto_backup_bat/mysql_test.sql','F:\Auto_download\%Y%\%m%\%d%\test.sql')
powershell (new-object System.Net.WebClient).DownloadFile('http://10.64.8.100/auto_backup_bat/web_test.rar_bz','F:\Auto_download\%Y%\%m%\%d%\test.rar')以上就是mysql备份及rar打包相关关键配置代码的详细内容，更多关于mysql备份及rar打包相关关键配置代码的资料请关注九品源码其它相关文章！