dbbackup.bat

@echo off
set bak_file=D:\data\backup\mydb_%date:~2,2%%date:~5,2%%date:~8,2%%time:~0,2%%time:~3,2%

mysqldump -h127.0.0.1 -P8010 -uroot -pPassword mydb > %bak_file%_db.sql
mysqldump -h127.0.0.1 -P8010 -uroot -pPassword -n -t -d -R allchat > %bak_file%_sp.sql

::zip
makecab /d compressiontype=mszip %bak_file%_db.sql %bak_file%_db.zip
makecab /d compressiontype=mszip %bak_file%_sp.sql %bak_file%_sp.zip

del /f /s /q %bak_file%_db.sql
del /f /s /q %bak_file%_sp.sql

deloldbak

deloldbak.bat

@echo off
title 清理IIS日志文件

:: 日志文件目录
set log_dir="D:\data\backup"

:: 保留日志天数
set bak_dat=15

:: 删除日志文件
forfiles /p %log_dir% /S /M *.zip /D -%bak_dat% /C "cmd /c echo 正在删除@relpath 文件… & echo. & del @file"

:: pause