
@echo off
setlocal

REM === CONFIGURATION ===
set SSH_USER=reinhard
set SSH_HOST=your.remote.host
set LOCAL_PORT=3307
set REMOTE_PORT=3306
set MYSQL_USER=dbuser
set MYSQL_DB=your_database
set MYSQL_SCRIPT=your_script.sql

REM === STEP 1: Start SSH Tunnel ===
echo Starting SSH tunnel...
start "" ssh -N -L %LOCAL_PORT%:localhost:%REMOTE_PORT% %SSH_USER%@%SSH_HOST%

REM === STEP 2: Wait for tunnel to stabilize ===
timeout /t 5 >nul

REM === STEP 3: Run MySQL Script ===
echo Running MySQL script...
mysql -h 127.0.0.1 -P %LOCAL_PORT% -u %MYSQL_USER% -p < %MYSQL_SCRIPT%

REM === STEP 4: Close Tunnel Manually or via TaskKill (optional) ===
REM You can manually close the tunnel or automate it like this:
REM taskkill /f /im ssh.exe

echo Done.
endlocal
pause
