Вот мой конфиг (setup.bat):
@echo off
REM ######################################## DB path
REM ### MYSQL 4.1 ###
REM set mysqlBinPath=C:Program FilesMySQLMySQL Server 4.1bin
REM ### MYSQL 5.0 ###
set mysqlBinPath=C:Program FilesMySQLMySQL Server 5.0bin
REM ######################################## DB
set user=root
set pass=root
set DBname=l2jdb
set DBHost=localhost
REM ########################################
set mysqldumpPath="%mysqlBinPath%mysqldump"
set mysqlPath="%mysqlBinPath%mysql"
if not exist backup (
mkdir backup
)
REM ######################################## :main_menu
:main_menu
cls
echo.L2J Fortress Setup
echo.
echo.### Main Menu ###
echo.
echo.(1) Full install DB
echo.(2) Upgrade DB
echo.(3) Backup DB
echo.(4) Restore DB
echo.(q) Quit
echo.
set button=x
set /p button=What do you want ?:
if /i %button%==1 goto full_install_menu
if /i %button%==2 goto upgrade_menu
if /i %button%==3 goto backup_menu
if /i %button%==4 goto restore_menu
if /i %button%==q goto end
goto main_menu
REM ######################################## :full_install_menu
:full_install_menu
cls
echo.L2J Fortress Setup
echo.
echo.### Full Install Menu ###
echo.
echo.(1) Chronicles 1
echo.(3) Chronicles 3
echo.(m) Main menu
echo.(q) Quit
echo.
set button=x
set /p button=Select Chronicles ?:
if /i %button%==1 goto full_install_c1
if /i %button%==3 goto full_install_c3
if /i %button%==m goto main_menu
if /i %button%==q goto end
goto full_install_menu
REM ######################################## :upgrade_menu
:upgrade_menu
cls
echo.L2J Fortress Setup
echo.
echo.### Upgrade Menu ###
echo.
echo.(1) Chronicles 1
echo.(3) Chronicles 3
echo.(m) Main menu
echo.(q) Quit
echo.
set button=x
set /p button=Select Chronicles ?:
if /i %button%==1 goto upgrade_c1
if /i %button%==3 goto upgrade_c3
if /i %button%==m goto main_menu
if /i %button%==q goto end
goto upgrade_menu
REM ######################################## :backup_menu
:backup_menu
cls
echo.L2J Fortress Setup
echo.
echo.### Backup Menu ###
echo.
echo.(1) Full backup
echo.(2) General tables backup only
echo.(m) Main menu
echo.(q) Quit
echo.
set button=x
set /p button=Select backup type ?:
if /i %button%==1 goto full_backup
if /i %button%==2 goto not_working_now
if /i %button%==m goto setup
if /i %button%==q goto end
goto backup_menu
REM ######################################## :restore_menu
:restore_menu
cls
echo.List all files in dir "/backup" !
echo.
dir backup /B /P
echo.
echo.L2J Fortress Setup
echo.
echo.### Restore Menu ###
echo.
echo.Enter a full filename do you want to restore to the database !
echo.(m) Main menu
echo.(q) Quit
echo.
set filename=x
set /p filename=Enter filename ?:
if /i %filename%==m goto main_menu
if /i %filename%==q goto end
if /i %filename%==%filename% goto restore_DB
goto restore_menu
REM ######################################## :full_install_c1
:full_install_c1
set ctime=%TIME:~0,2%
if "%ctime:~0,1%" == " " (
set ctime=0%ctime:~1,1%
)
set ctime=%ctime%'%TIME:~3,2%'%TIME:~6,2%
echo.
echo Making a full backup into %DATE%-%ctime%_backup_full.sql
echo.
%mysqldumpPath% -add-drop-table -h %DBHost% -u %user% -password=%pass% %DBname% > backup/%DATE%-%ctime%_backup_full.sql
echo.
echo.Deleting general tables !!!
echo.
%mysqlPath% -h %DBHost% -u %user% -password=%pass% -D %DBname% < full_install.sql
echo.
echo.Installing general tables !!!
echo.
%mysqlPath% -h %DBHost% -u %user% -password=%pass% -D %DBname% < common/accounts.sql
%mysqlPath% -h %DBHost% -u %user% -password=%pass% -D %DBname% < common/character_friends.sql
%mysqlPath% -h %DBHost% -u %user% -password=%pass% -D %DBname% < common/character_hennas.sql
%mysqlPath% -h %DBHost% -u %user% -password=%pass% -D %DBname% < common/character_macroses.sql
%mysqlPath% -h %DBHost% -u %user% -password=%pass% -D %DBname% < common/character_quests.sql
%mysqlPath% -h %DBHost% -u %user% -password=%pass% -D %DBname% < common/character_recipebook.sql
%mysqlPath% -h %DBHost% -u %user% -password=%pass% -D %DBname% < common/character_shortcuts.sql
%mysqlPath% -h %DBHost% -u %user% -password=%pass% -D %DBname% < common/character_skills.sql
%mysqlPath% -h %DBHost% -u %user% -password=%pass% -D %DBname% < common/character_skills_save.sql
%mysqlPath% -h %DBHost% -u %user% -password=%pass% -D %DBname% < common/characters.sql
%mysqlPath% -h %DBHost% -u %user% -password=%pass% -D %DBname% < common/clan_data.sql
%mysqlPath% -h %DBHost% -u %user% -password=%pass% -D %DBname% < common/clan_wars.sql
%mysqlPath% -h %DBHost% -u %user% -password=%pass% -D %DBname% < common/items.sql
%mysqlPath% -h %DBHost% -u %user% -password=%pass% -D %DBname% < common/pets.sql
%mysqlPath% -h %DBHost% -u %user% -password=%pass% -D %DBname% < common/seven_signs.sql
%mysqlPath% -h %DBHost% -u %user% -password=%pass% -D %DBname% < common/seven_signs_festival.sql
%mysqlPath% -h %DBHost% -u %user% -password=%pass% -D %DBname% < common/siege_clans.sql
%mysqlPath% -h %DBHost% -u %user% -password=%pass% -D %DBname% < common/killcount.sql
goto upgrade_c1
REM ######################################## :full_install_c3
:full_install_c3
set ctime=%TIME:~0,2%
if "%ctime:~0,1%" == " " (
set ctime=0%ctime:~1,1%
)
set ctime=%ctime%'%TIME:~3,2%'%TIME:~6,2%
echo.
echo Making a full backup into %DATE%-%ctime%_backup_full.sql
echo.
%mysqldumpPath% -add-drop-table -h %DBHost% -u %user% -password=%pass% %DBname% > backup/%DATE%-%ctime%_backup_full.sql
echo.
echo.Deleting general tables !!!
echo.
%mysqlPath% -h %DBHost% -u %user% -password=%pass% -D %DBname% < full_install.sql
echo.
echo.Installing general tables !!!
echo.
%mysqlPath% -h %DBHost% -u %user% -password=%pass% -D %DBname% < common/accounts.sql
%mysqlPath% -h %DBHost% -u %user% -password=%pass% -D %DBname% < common/character_friends.sql
%mysqlPath% -h %DBHost% -u %user% -password=%pass% -D %DBname% < common/character_hennas.sql
%mysqlPath% -h %DBHost% -u %user% -password=%pass% -D %DBname% < common/character_macroses.sql
%mysqlPath% -h %DBHost% -u %user% -password=%pass% -D %DBname% < common/character_quests.sql
%mysqlPath% -h %DBHost% -u %user% -password=%pass% -D %DBname% < common/character_recipebook.sql
%mysqlPath% -h %DBHost% -u %user% -password=%pass% -D %DBname% < common/character_shortcuts.sql
%mysqlPath% -h %DBHost% -u %user% -password=%pass% -D %DBname% < common/character_skills.sql
%mysqlPath% -h %DBHost% -u %user% -password=%pass% -D %DBname% < common/character_skills_save.sql
%mysqlPath% -h %DBHost% -u %user% -password=%pass% -D %DBname% < common/characters.sql
%mysqlPath% -h %DBHost% -u %user% -password=%pass% -D %DBname% < common/clan_data.sql
%mysqlPath% -h %DBHost% -u %user% -password=%pass% -D %DBname% < common/clan_wars.sql
%mysqlPath% -h %DBHost% -u %user% -password=%pass% -D %DBname% < common/items.sql
%mysqlPath% -h %DBHost% -u %user% -password=%pass% -D %DBname% < common/pets.sql
%mysqlPath% -h %DBHost% -u %user% -password=%pass% -D %DBnam…
Дальше »»»