Script backup MySQL completo

[admsistenet]

@echo off

REM === CONFIGURAZIONE ===
set MYSQL_USER=root
set MYSQL_PASSWORD=tuapassword
set MYSQL_PATH="C:\Program Files\MySQL\MySQL Server 8.0\bin"
set BACKUP_DIR=C:\backup_mysql

REM === DATA FORMATO YYYYMMDD ===
for /f "tokens=2 delims==" %%I in ('wmic os get localdatetime /value') do set datetime=%%I
set DATA=%datetime:~0,8%

REM === CREA CARTELLA SE NON ESISTE ===
if not exist %BACKUP_DIR% (
mkdir %BACKUP_DIR%
)

REM === FILE BACKUP ===
set FILE=%BACKUP_DIR%\backup_%DATA%.sql

echo Inizio backup...

%MYSQL_PATH%\mysqldump.exe -u %MYSQL_USER% -p%MYSQL_PASSWORD% --all-databases > "%FILE%"

echo Backup completato: %FILE%

pause