Advertisement
Guest User

Untitled

a guest
Nov 1st, 2016
113
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.00 KB | None | 0 0
  1. @echo off
  2.  
  3. set dbUser=Aqui vale nombre del usuario de la base de datos
  4. set dbPassword=Aquí va el password de la base de datos
  5. set dbname=Aquí va el nombre de la base de datos
  6.  
  7. ::La carpeta donde se guardaran los respaldos
  8. set backupDir="C:\Users\adminapp.APP-DATABASES\Desktop\respaldos\dbs"
  9.  
  10. ::La ruta donde esta el mysqldump
  11. set mysqldump="C:\web\mysql\bin\mysqldump.exe"
  12.  
  13. SETLOCAL ENABLEEXTENSIONS
  14. FOR %%A IN (%Date%) DO (
  15. FOR /F "tokens=1-3 delims=/-" %%B in ("%%~A") DO (
  16. set 'today'=%%D%%B%%C
  17. )
  18. )
  19.  
  20. for /f "tokens=1-4 delims=:,.-/ " %%i in ('echo %time%') do (
  21. set 'hh'=%%i
  22. set 'mm'=%%j
  23. set 'ss'=%%k
  24. set 'ff'=%%l)
  25.  
  26. ENDLOCAL & SET Today=%'today'%& SET v_Hour=%'hh'%& SET v_Minute=%'mm'%& SET v_Second=%'ss'%& SET v_Fraction=%'ff'%
  27.  
  28. set timestring=%V_Hour%_%V_Minute%_%v_Second%
  29.  
  30. %mysqldump% --host="localhost" --password=%dbPassword% --user=%dbUser% --routines %dbname% > %backupDir%\%Today%_%timestring%_NOMBREDELARCHIVODERESPALDO.sql
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement