我正在尝试将时间戳添加到带有.bat文件的mysql数据库转储文件中,但是效果不是很好。没有添加时间戳-我只是得到一个backup-.sql
文件。有小费吗?
我的档案:
@echo off
cls
echo Date format = %date%
echo dd = %date:~0,2%
echo mm = %date:~3,2%
echo yyyy = %date:~6,4%
echo.
echo Time format = %time%
echo hh = %time:~0,2%
echo mm = %time:~3,2%
echo ss = %time:~6,2%
echo.
echo Timestamp = %date:~6,4%-%date:~3,2%-%date:~0,2%-%time:~0,2%-%time:~3,2%-%time:~6,2%
pushd "C:\Program Files\MySQL\MySQL Server 5.5\bin"
mysqldump --user=root --password=***** leaverequest>c:\backup\backup-%timestamp%.sql
快速编辑应解决此问题:
@echo off
cls
echo Date format = %date%
echo dd = %date:~0,2%
echo mm = %date:~3,2%
echo yyyy = %date:~6,4%
echo.
echo Time format = %time%
echo hh = %time:~0,2%
echo mm = %time:~3,2%
echo ss = %time:~6,2%
echo.
set timestamp=%date:~6,4%-%date:~3,2%-%date:~0,2%-%time:~0,2%-%time:~3,2%-%time:~6,2%
pushd "C:\Program Files\MySQL\MySQL Server 5.5\bin"
mysqldump --user=root --password=***** leaverequest>"c:\backup\backup-%timestamp%.sql"
本文收集自互联网,转载请注明来源。
如有侵权,请联系 [email protected] 删除。
我来说两句