备份wamp数据信息并删除特定日期之前的数据

@echo off
echo.
echo MySQL数据库备份
set del_date_back=15
set all_data_back_value=1
set haoya_bin_path="C:\Program Files\HaoZip\"
set mysql_bin_path="C:\wamp\bin\mysql\mysql5.5.24\bin\"
set mysql_data_path="C:\wamp\bin\mysql\mysql5.5.24\data\"
::set apache_bin_path="C:\wamp\bin\apache\apache2.2.22\bin\"
set apache_data_path="C:\wamp\"
set data_back_path="C:\dtsbc_data_back\"
set del_file_path="C:\wamp\www\dtsbc\Admin\Runtime\"
set Ymd="%date:~,4%%date:~5,2%%date:~8,2%"
set /a t=100+%time:~,2%
set bakFileNameTail=_BAK_%date:~,4%%date:~5,2%%date:~8,2%_%t:~1%%time:~3,2%%time:~6,2%
echo *****************************
echo.
echo 今天是： %date%_%time%
echo 好压执行路径为： %haoya_bin_path%
echo mysql执行路径为： %mysql_bin_path%
echo mysql数据路径为： %mysql_data_path%
::echo apache执行路径为： %apache_bin_path%
echo apache数据路径为： %apache_data_path%
echo.
echo *****************************
:: HaoZipC a -tzip 20161221.zip config\*
::set mysql_bin_path = "C:\wamp\bin\mysql\mysql5.5.24\bin"
::set apache_bin_path = "C:\wamp\bin\apache\apache2.2.22\bin"
::set haoya_bin_path = "C:\Program Files\HaoZip"
::创建备份的数据的目录

md %data_back_path%%Ymd%
%mysql_bin_path%\mysqldump -u root --default-character-set=utf8 --databases dtsbc > %data_back_path%%Ymd%\dtsbc_%bakFileNameTail%.sql
%mysql_bin_path%\mysqldump -u root --default-character-set=utf8 --databases mysql > %data_back_path%%Ymd%\mysql_%bakFileNameTail%.sql
%mysql_bin_path%\mysqldump -u root --default-character-set=utf8 --databases bbsdata > %data_back_path%%Ymd%\bbsdata_%bakFileNameTail%.sql
net stop wampapache
net stop wampmysqld
rd/s/q %del_file_path%

%haoya_bin_path%HaoZipC a -tzip %data_back_path%%Ymd%\dtsbc_mysql_%Ymd%.zip %mysql_data_path%dtsbc\*
%haoya_bin_path%HaoZipC a -tzip %data_back_path%%Ymd%\bbs_mysql_%Ymd%.zip %mysql_data_path%bbs\*
%haoya_bin_path%HaoZipC a -tzip %data_back_path%%Ymd%\mysql_mysql_%Ymd%.zip %mysql_data_path%mysql\*
%haoya_bin_path%HaoZipC a -tzip %data_back_path%%Ymd%\dtsbc_php_%Ymd%.zip %apache_data_path%dtsbc\*
%haoya_bin_path%HaoZipC a -tzip %data_back_path%%Ymd%\bbs_php_%Ymd%.zip %apache_data_path%bbs\*

if  %date:~9,1% equ %all_data_back_value% ( %haoya_bin_path%HaoZipC a -tzip %data_back_path%%Ymd%\wamp_%Ymd%.zip %apache_data_path%*)
::cmd
net start wampapache
net start wampmysqld
::set/a n=5
set/a y=%date:~,4%,m=1%date:~5,2%-100,d=1%date:~8,2%-100
set/a d-=%del_date_back%
if %d% gtr 0 goto :ok
:ov
set/a "md=31-!(m-5)-!(m-7)-!(m-10)-!(m-12)-!(m-3)*(3-!(y&3))"
set/a d+=md,m-=1
if %m% equ 0 set/a m=12,y-=1
if %d% leq 0 goto :ov
:ok
set/a md=m*100+d+10000
set back_data_value="%y%%md:~1%"
echo %del_date_back%天前的日期为：%back_data_value%
cd %data_back_path%

set /a data_back_value_int=%back_data_value%+0
echo %data_back_value_int%
::单条语句执行的时候需要的是一个% 在批处理中的话，需要两个%%
for /F %%i in ('dir  %data_back_path% /a:d /b') do (if %%i lss %data_back_value_int% ( rd/s/q %%i ))
::for /F %%i in ('dir  %data_back_path% /a:d /b') do (  if %%i lss %data_back_value_int% ( echo %%i ) else ( echo "google" )  )
echo.:P

echo MySQL数据库备份完成，请进行检查。。。

echo.:P
echo.
//pause
::pause

转载于:https://my.oschina.net/u/1403503/blog/812634