Advertisement
Guest User

Untitled

a guest
Jul 5th, 2017
174
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.40 KB | None | 0 0
  1. echo Starting Backup.
  2.  
  3. For /f "tokens=2-4 delims=/ " %%a in ('date /t') do (set dt=%%c-%%a-%%b)
  4.  
  5. For /f "tokens=1-4 delims=:." %%a in ('echo %time%') do (set tm=%%a%%b%%c%%d)
  6.  
  7. set database=database
  8. set username=root
  9. set password=password
  10. set file=%database%-%dt%-%tm%.sql
  11.  
  12. echo Backing up to file: %file%
  13.  
  14. mysqldump --routines -u %username% -p%password% %database% > E:\Backups\%file%
  15.  
  16. echo Backup Complete!
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement