C:\Program Files\MySQL\MySQL Workbench 8.0 CE>mysqldump -u root -p eoffice_db documents >d:/backup_filename.sql
@echo off
:: Configuration
set DB_USER=root
set DB_PASS=12345
set DB_NAME=eoffice_DB
set BACKUP_DIR=C:\eoffice_DB\documents
:: 1. SET YOUR TABLE NAME HERE
:: Leave blank for full DB, or type a single table (e.g., users)
set TABLE_NAME=documents
:: Get Date Format safely (YYYYMMDD) regardless of Windows regional settings
for /f "tokens=2 delims==" %%i in ('wmic os get localdatetime /value') do set LDT=%%i
set BACKUP_DATE=%LDT:~0,4%%LDT:~4,2%%LDT:~6,2%
:: Adjust file name based on whether a table is specified
if "%TABLE_NAME%"=="" (
set BACKUP_FILE=%BACKUP_DIR%\%DB_NAME%_%BACKUP_DATE%.sql
) else (
set BACKUP_FILE=%BACKUP_DIR%\%DB_NAME%_%TABLE_NAME%_%BACKUP_DATE%.sql
)
:: Ensure target directory exists
if not exist "%BACKUP_DIR%" mkdir "%BACKUP_DIR%"
:: Execute mysqldump
"C:\Program Files\MySQL\MySQL Workbench 8.0 CE\mysqldump.exe" -u%DB_USER% -p%DB_PASS% %DB_NAME% %TABLE_NAME% > "%BACKUP_FILE%"
:: Optional: Delete files older than 30 days
forfiles /p "%BACKUP_DIR%" /s /m *.sql /d -30 /c "cmd /c del @path"
