@echo off
For /f "tokens=2-4 delims=/ " %%a in ('date /t') do (set mydate=%%c-%%a-%%b)
For /f "tokens=1-2 delims=/:" %%a in ("%TIME%") do (set mytime=%%a%%b)
SET backupdir=C:\Users\ravi.kumar\Documents\dumps
SET mysqluername=root
SET mysqlpassword=Rk@12345
SET database=my_test_db
C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqldump.exe -uroot -pPASSWORD %database% > %backupdir%\%database%_%mydate%_%mytime%_.sql
For /f "tokens=2-4 delims=/ " %%a in ('date /t') do (set mydate=%%c-%%a-%%b)
For /f "tokens=1-2 delims=/:" %%a in ("%TIME%") do (set mytime=%%a%%b)
SET backupdir=C:\Users\ravi.kumar\Documents\dumps
SET mysqluername=root
SET mysqlpassword=Rk@12345
SET database=my_test_db
C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqldump.exe -uroot -pPASSWORD %database% > %backupdir%\%database%_%mydate%_%mytime%_.sql
No comments:
Post a Comment