最近接手了个win2003的服务器，需要做个mysql的备份
@echooffsethour=%time:~0,2%
if%hour:~0,1%== sethour=0%hour:~1,1%
setmin=%time:~3,2%
if%min:~0,1%== setmin=0%min:~1,1%
setsecs=%time:~6,2%
if%secs:~0,1%== setsecs=0%secs:~1,1%
setymd=%date:~,4%%date:~5,2%%date:~8,2%
setm=%date:~5,2%
setd=%date:~8,2%
settime=%hour%%min%
mysqldump-u[username]-p[dbpwd][dbname]>d:/tmp/[dbname]_%ymd%%time%.sql
7zaad:/db_bak/%m%/%d%/[dbname]_%ymd%%time%.7zd:/tmp/[dbname]_%ymd%%time%.sql
deld:/tmp/[dbname]_%ymd%%time%.sql
@echoon
用7z压缩可以更省空间（需先将对应的7za.exe拖至system32下 或以完整路径调用等），相对于tar.gz只占其75%左右的空间
winserver的计划任务在控制面板
附linux的
user=[dbuser]
pwd=[dbpwd]port=3306db=[dbname]day=`date+%y%m%d%h%m`
ym=`date+%y%m`d=`date+%d`/usr/bin/mysqldump  -u$user-p$pwd-p$port  -b$db>>/tmp/${db}_$day.sql
mkdir-p/mysqldata/$ym/$d/
7zaa/mysqldata/$ym/$d/${db}_$day.7z  /tmp/${db}_$day.sql
rm-f/tmp/${db}_$day.sql