Advertisement
Guest User

Untitled

a guest
Oct 25th, 2016
79
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.37 KB | None | 0 0
  1. set SQL="c:\Program Files\MySQL\MySQL Server 5.1\bin\mysqldump.exe"
  2.  
  3. set DATABASE_NAME=name
  4. set DATABASE_USER=user
  5. set DATABASE_PASSWORD=pass
  6.  
  7. echo off
  8. cls
  9.  
  10. echo 'Dumping database to backup/%DATABASE_NAME%_%date:~-4,4%%date:~-10,2%%date:~-7,2%.sql'
  11.  
  12. %SQL% -u %DATABASE_USER% -p%DATABASE_PASSWORD% %DATABASE_NAME% > backup/%DATABASE_NAME%_%date:~-4,4%%date:~-10,2%%date:~-7,2%.sql
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement