01月19, 2016

批处理备份数据库

@echo off
set /a tm1=%time:~0,2%*1
if %tm1% LSS 10 set tm1=0%tm1%

@echo 生成数据备份文件标题
set title=%date:~0,4%年%date:~5,2%月%date:~8,2%日%tm1%时%time:~3,2%分%time:~6,2%秒.sql

@echo ============================开始导出数据=========================

D:\wamp\bin\mysql\mysql5.6.17\bin\mysqldump.exe -uroot -p123456 dbname > %title%

@echo ============================导出数据结束=========================


本文链接:https://lxyit.com/article/show/96.html

-- EOF --