@echo off
REM ============================================================
REM 搴风編鏃ヨ鏁版嵁鍚屾鑴氭湰
REM 鐢ㄦ硶: sync_to_remote.bat
REM ============================================================

echo ========================================
echo 搴风編鏃ヨ鏁版嵁鍚屾鍒拌繙绋嬫湇鍔″櫒
echo ========================================

REM 閰嶇疆
set REMOTE_HOST=192.168.16.251
set REMOTE_USER=root
set REMOTE_DIR=/tmp
set SQL_FILE=sync_kmdiary_full.sql
set LOCAL_PATH=D:\workspace\cfc\scripts\%SQL_FILE%

if not exist "%LOCAL_PATH%" (
    echo 閿欒: SQL鏂囦欢涓嶅瓨鍦?%LOCAL_PATH%
    pause
    exit /b 1
)

echo.
echo [1/3] 涓婁紶SQL鏂囦欢鍒拌繙绋嬫湇鍔″櫒...
scp "%LOCAL_PATH%" %REMOTE_USER%@%REMOTE_HOST%:%REMOTE_DIR%/
if %errorlevel% neq 0 (
    echo 閿欒: 涓婁紶澶辫触
    pause
    exit /b 1
)
echo 涓婁紶瀹屾垚

echo.
echo [2/3] 鍦ㄨ繙绋嬫湇鍔″櫒鎵цSQL...
ssh %REMOTE_USER%@%REMOTE_HOST% "mysql -u zxyj -pzxyj@123 zxyj < %REMOTE_DIR%/%SQL_FILE%"
if %errorlevel% neq 0 (
    echo 閿欒: 鎵ц澶辫触
    pause
    exit /b 1
)
echo 鎵ц瀹屾垚

echo.
echo [3/3] 娓呯悊杩滅▼涓存椂鏂囦欢...
ssh %REMOTE_USER%@%REMOTE_HOST% "rm -f %REMOTE_DIR%/%SQL_FILE%"
echo 娓呯悊瀹屾垚

echo.
echo ========================================
echo 鍚屾瀹屾垚锛?echo ========================================
pause