utilitario para backup do mysql via linha de comando

dump-mysql-database.cmd

:: tanks for https://erisilva.net/backup-automatico-do-mysql/

set user="root"
set password="teste"
set backupDir="C:\bkpmysql"
set databases="financeiro218"
set host="localhost"

@echo off
:: get date
for /F "tokens=1-3 delims=/ " %%i in ('date /t') do (
set dia=%%i
set mes=%%j
set ano=%%k
)
 
:: get time
for /F "tokens=1-2 delims=:. " %%i in ('time /t') do (
set hora=%%i
set minuto=%%j
)
 
set data=%ano%-%mes%-%dia%_%hora%-%minuto%
set filename=%databases%_%data%.sql
:: switch to the "data" folder
pushd %mysqlDataDir%

 
if not exist %backupDir% (
	mkdir %backupDir%
)
 
mysqldump --host=%host% --user=%user% --password=%password% --single-transaction --add-drop-table --databases %databases% > %backupDir%/%filename%

echo done

pause()