bobhsieh
2009-07-14, 04:22 PM
因為工作上需要幫使用者備份dbf/mdb ..,
只想要簡單利用批次檔加上winrar/7zip等可以使用指令(不用gui)自動備份,
參考網路各種資料,依據年月日時分秒作為檔名...
再加上小弟一點點的修改,
經測試可以符合需求,
如今分享出來給大家,
@echo off
cls
rem 取得日期、時間
rem setting environment variables with todoy's date values
for /f "tokens=1-4 delims=-/ " %%i in ('date /t') do (
set year=%%i
set month=%%j
set day=%%k
)
for /f "tokens=1-3 delims=:" %%i in ('time /t') do (
set hour=%%i
set minute=%%j
)
for /f "tokens=1 delims= " %%i in ("%hour%") do (
set hour=%%i
)
for /f "tokens=1-4 delims=: " %%a in ("%time%") do (
set h=%%a
set m=%%b
set s=%%c
)
rem 轉換成民國年
set /a yy=1911
set /a ww=%year%-%yy%
for /f "tokens=1-4 delims=. " %%x in ("%s%") do (
set ss=%%x
)
set dt=0%ww%%month%%day%-%h%.%m%.%ss%
title 資料備份中...0%dt%
rem title 資料備份中...0%ww%%month%%day%-%h%.%m%.%ss%
rem 使用7z加壓縮
"%programfiles%\7-zip\7z" a DB-"%dt%".zip C:\WinFnd\db >nul
if %errorlevel% == 0 goto yes > nul
if %errorlevel% == 1 goto 11 > nul
:yes
echo ==================================================================
echo 資料備份OK
echo ==================================================================
goto end
:11
echo ==================================================================
echo 資料備份有問題。
echo ==================================================================
goto end
:end
pause
@echo off
只想要簡單利用批次檔加上winrar/7zip等可以使用指令(不用gui)自動備份,
參考網路各種資料,依據年月日時分秒作為檔名...
再加上小弟一點點的修改,
經測試可以符合需求,
如今分享出來給大家,
@echo off
cls
rem 取得日期、時間
rem setting environment variables with todoy's date values
for /f "tokens=1-4 delims=-/ " %%i in ('date /t') do (
set year=%%i
set month=%%j
set day=%%k
)
for /f "tokens=1-3 delims=:" %%i in ('time /t') do (
set hour=%%i
set minute=%%j
)
for /f "tokens=1 delims= " %%i in ("%hour%") do (
set hour=%%i
)
for /f "tokens=1-4 delims=: " %%a in ("%time%") do (
set h=%%a
set m=%%b
set s=%%c
)
rem 轉換成民國年
set /a yy=1911
set /a ww=%year%-%yy%
for /f "tokens=1-4 delims=. " %%x in ("%s%") do (
set ss=%%x
)
set dt=0%ww%%month%%day%-%h%.%m%.%ss%
title 資料備份中...0%dt%
rem title 資料備份中...0%ww%%month%%day%-%h%.%m%.%ss%
rem 使用7z加壓縮
"%programfiles%\7-zip\7z" a DB-"%dt%".zip C:\WinFnd\db >nul
if %errorlevel% == 0 goto yes > nul
if %errorlevel% == 1 goto 11 > nul
:yes
echo ==================================================================
echo 資料備份OK
echo ==================================================================
goto end
:11
echo ==================================================================
echo 資料備份有問題。
echo ==================================================================
goto end
:end
pause
@echo off