[winterwolf]

Win XP x64
JDK 7 x64
MySQL 5 пробовали и х64 и х32 - одно и то же получается
сборка Emu 4664
все ставится прекрасно, если на х32 виндах
а на х64 виндах при запуске database_installer.bat выдает вот что


По моему, у Emu содержимое батника изменилось сильно...
Пробовали переставить батник со старой сборки=) тоже не помогло.
Посоветуйте как это поправить?

[klin]

Сталкивался я похожей проблемой только связаной с явой. тоесть серв не видел яву. попробуй прописать путь к мускулу .

Мой Компьютер -> Свойства -> дополнительно -> переменные среды -> Системные переменные -> PATH -> Редактировать
ставишь точку с запятой в конце и дописываешь путь к папке (примерно так C:\Program Files\MySQL\MySQL Server 5.0\bin)
может поможет. попробуй.

[winterwolf]

Сделала, не помогло.
Содержание батника:



@echo off
color 17
title L2Emu Project: Database Installer
echo.
echo.
echo ** [ L2EMU PROJECT INTERACTIVE DATABASE INSTALLER ]**
echo.
echo.
echo.
set workdir="%cd%"
:loadVars
if not exist vars.txt goto createVars
ren vars.txt *.bat
call vars.bat
ren vars.bat *.txt
cls
goto start
:createVars
echo ** [ MYSQL SERVER SETUP ] **
echo.
echo DIGIT YOUR MYSQL BIN PATH (PATH TO YOUR MYSQL SERVER BIN FOLDER)
echo.
set /P mysqlBinPath="MYSQL PATH : "
echo.
echo LOGIN SERVER SETTINGS
echo --------------------
set /P lsuser="USER (DEFAULT: 'Root'): "
echo.
set /P lspass="PASS (WILL BE SHOW AND SAVED AS CLEAR TEXT): "
echo.
set /P lsdb="DATABASE (DEFAULT:'L2Emu_DB'): "
echo.
set /P lshost="HOST (DEFAULT: 'LOCALHOST'): "
echo.
echo.
echo GAMESERVER SETTINGS
echo -------------------
set /P gsuser="USER (DEFAULT: 'Root'): "
echo.
set /P gspass="PASS (WILL BE SHOW AND SAVED AS CLEAR TEXT): "
echo.
set /P gsdb="DATABASE (DEFAULT:'L2Emu_DB'): "
echo.
set /P gshost="HOST (DEFAULT: 'LOCALHOST'): "
echo.
echo @set mysqlPath="%mysqlBinPath%\mysql"> vars.txt
echo @set mysqlBinPath="%mysqlBinPath%">> vars.txt
echo @set mysqldumpPath="%mysqlBinPath%\mysqldump">> vars.txt
echo @set lsuser=%lsuser%>> vars.txt
echo @set lspass=%lspass%>> vars.txt
echo @set lsdb=%lsdb%>> vars.txt
echo @set lshost=%lshost%>> vars.txt
echo @set gsuser=%gsuser%>> vars.txt
echo @set gspass=%gspass%>> vars.txt
echo @set gsdb=%gsdb%>> vars.txt
echo @set gshost=%gshost%>> vars.txt
echo.
echo CONFIGURATION COMPLETED, PRESS ANY KEY TO CONTINUE
echo.
:asksetup
set lsetupprompt=x
echo.
echo ** [ L2EMU PROJECT INTERACTIVE DATABASE INSTALLER ] **
echo.
echo OPTIONS: (P) PROCEED INSTALL.
echo.
echo (N) QUIT PROGRAM.
echo.
echo (S) BACK TO MYSQL SETUP.
echo.
echo.
set /p setupprompt=DO YOU WANT TO PROCEED INSTALL ?
echo.
echo.
echo.
if /i %setupprompt%==P goto setupinstall
if /i %lsetupprompt%==N goto end
if /i %setupprompt%==S goto createVars
goto asksetup
:setupinstall
pause> nul
goto loadVars
:start
REM ==============================================
echo.
echo.
echo.
:asksetup
set lsetupprompt=x
echo ** [ L2EMU PROJECT INTERACTIVE DATABASE INSTALLER ]**
echo.
echo.
echo OPTIONS:
echo.
echo (P) PROCEED INSTALL.
echo.
echo (Q) QUIT PROGRAM.
echo.
echo (B) BACK TO MYSQL SETUP.
echo.
set /p setupprompt=DO YOU WANT TO PROCEED INSTALL ?
echo.
echo.
echo.
if /i %setupprompt%==P goto setupinstall
if /i %lsetupprompt%==Q goto end
if /i %setupprompt%==B goto createVars
goto asksetup
:setupinstall
echo.
echo **[ L2EMU PROJECT INTERACTIVE DATABASE INSTALLER ] **
echo ** [ LOGINSERVER DATABASE ] **
echo.
echo.
echo.
echo.
echo LOADING...
echo.
%mysqldumpPath% --add-drop-table -h %lshost% -u %lsuser% --password=%lspass% %lsdb% > loginserver_backup.sql
echo PLEASE SELECT YOUR INSTALL TYPE :
echo.
echo OPTIONS:
echo.
echo FULL INSTALL (F) FOR A COMPLETE LOGINSERVER INSTALL.
echo.
echo UPGRADE INSTALL (U) FOR A LOGINSERVER UPGRADE INSTALL.
echo.
echo SKIP (S) TO SKIP LOGINSERVER DATABASE INSTALL.
echo.
echo QUIT (Q) TO EXIT PROGRAM.
echo.
echo.
:asklogin
set loginprompt=x
set /p loginprompt=WHAT'S YOUR CHOICE ?
echo.
if /i %loginprompt%==F goto logininstall
if /i %loginprompt%==U goto loginupgrade
if /i %loginprompt%==S goto gsbackup
if /i %loginprompt%==Q goto end
goto asklogin
:logininstall
echo OPERATION IN PROGRESS...
%mysqlPath% -h %lshost% -u %lsuser% --password=%lspass% -D %lsdb% < login_install.sql
echo.
:loginupgrade
echo OPERATION IN PROGRESS...
%mysqlPath% -h %gshost% -u %lsuser% --password=%lspass% -D %lsdb% < ../sql/user_database/account_data.sql
%mysqlPath% -h %lshost% -u %lsuser% --password=%lspass% -D %lsdb% < ../sql/user_database/accounts.sql
%mysqlPath% -h %lshost% -u %lsuser% --password=%lspass% -D %lsdb% < ../sql/user_database/gameservers.sql
echo.
echo LOGINSERVER DATABASE INSTALL COMPLETED !
echo.
echo.
echo.
echo.
echo.
:gsbackup
echo ** L2EMU PROJECT INTERACTIVE DATABASE INSTALLER **
echo ** [GAMESERVER DATABASE] **
echo.
echo.
echo LOADING...
%mysqldumpPath% --add-drop-table -h %gshost% -u %gsuser% --password=%gspass% %gsdb% > gameserver_backup.sql
echo.
echo.
echo PLEASE SELECT YOUR INSTALL TYPE :
echo.
echo OPTIONS:
echo.
echo FULL INSTALL (F) FOR A COMPLETE GAMESERVER INSTALL.
echo.
echo UPGRADE INSTALL (U) FOR A GAMESERVER UPGRADE INSTALL.
echo.
echo SKIP (S) TO SKIP GAMESERVER DATABASE INSTALL.
echo.
echo QUIT (Q) TO EXIT THIS PROGRAM.
echo.
echo.
:asktype
set installtype=x
set /p installtype=WHAT'S YOUR CHOICE ?
echo.
echo.
if /i %installtype%==F goto fullinstall
if /i %installtype%==U goto upgradeinstall
if /i %installtype%==S goto additional_features_setup
if /i %installtype%==Q goto end
goto asktype

:fullinstall
echo OPERATION IN PROGRESS...
echo.
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < full_install.sql

:upgradeinstall
echo OPERATION IN PROGRESS...
echo.
echo INSTALLING SERVER DATABASE
echo.
echo.
echo ARMOR PROCESSING...
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/server_database/armor.sql
echo ARMOR SETS PROCESSING...
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/server_database/armorsets.sql
echo AUTO CHAT PROCESSING...
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/server_database/auto_chat.sql
echo AUTO CHAT TEXT PROCESSING...
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/server_database/auto_chat_text.sql
echo BUFF TEMPLATES PROCESSING...
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/server_database/buff_templates.sql
echo CASTLE DOOR PROCESSING...
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/server_database/castle_door.sql
echo CASTLE SIEGE GUARDS PROCESSING...
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/server_database/castle_siege_guards.sql
echo CHARACTER TEMPLATES PROCESSING...
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/server_database/char_templates.sql
echo CLASS LIST PROCESSING...
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/server_database/class_list.sql
echo DROPLIST PROCESSING...
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/server_database/droplist.sql
echo ENCHANT SKILL TREES PROCESSING...
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/server_database/enchant_skill_trees.sql
echo ETC ITEM PROCESSING...
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/server_database/etcitem.sql
echo FISH PROCESSING...
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/server_database/fish.sql
echo FISHING SKILL TREE PROCESSING...
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/server_database/fishing_skill_trees.sql
echo FORTRESS DOORS PROCESSING...
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/server_database/fort_door.sql
echo FORTRESS SIEGE GUARDS PROCESSING...
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/server_database/fort_siege_guards.sql
echo FORTRESS SPAWN LIST PROCESSING...
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/server_database/fort_spawnlist.sql
echo FOUR SEPULCHERS SPAWNLIST PROCESSING...
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/server_database/four_sepulchers_spawnlist.sql
echo GRAND BOSS SPAWNLIST PROCESSING...
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/server_database/grandboss_spawnlist.sql
echo HENNA PROCESSING...
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/server_database/henna.sql
echo HENNA TREES PROCESSING...
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/server_database/henna_trees.sql
echo LAST IMPERIAL TOMB SPAWNLIST PROCESSING...
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/server_database/lastimperialtomb_spawnlist.sql
echo LVL UP GAIN PROCESSING...
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/server_database/lvlupgain.sql
echo MERCHANT BUYLISTS PROCESSING...
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/server_database/merchant_buylists.sql
echo MERCHANT SHOP IDS PROCESSING...
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/server_database/merchant_shopids.sql
echo MERCHANT PROCESSING...
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/server_database/merchants.sql
echo MINIONS PROCESSING...
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/server_database/minions.sql
echo NPC PROCESSING...
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/server_database/npc.sql
echo NPCS SKILLS PROCESSING...
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/server_database/npcskills.sql
echo PET STATS PROCESSING...
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/server_database/pets_stats.sql
echo PLEDGE SKILL TREES PROCESSING...
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/server_database/pledge_skill_trees.sql
echo RAID BOSS SPAWNLIST PROCESSING...
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/server_database/raidboss_spawnlist.sql
echo RANDOM SPAWN PROCESSING...
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/server_database/random_spawn.sql
echo RANDOM SPAWN LOC PROCESSING...
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/server_database/random_spawn_loc.sql
echo SKILL LEARN PROCESSING...
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/server_database/skill_learn.sql
echo SKILL SPEELBOOKS PROCESSING...
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/server_database/skill_spellbooks.sql
echo SKILL TREE PROCESSING...
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/server_database/skill_trees.sql
echo SPAWNLIST PROCESSING...
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/server_database/spawnlist.sql
echo TELEPORT PROCESSING...
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/server_database/teleport.sql
echo TRANSFORMATION SKILL TREES PROCESSING...
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/server_database/transform_skill_trees.sql
echo VAN HALTER SPAWNLIST PROCESSING...
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/server_database/vanhalter_spawnlist.sql
echo WALKER ROUTES PROCESSING...
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/server_database/walker_routes.sql
echo WEAPON PROCESSING...
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/server_database/weapon.sql
echo.
echo.
echo INSTALLING USER DATABASE
echo.
echo.
echo ACCESS LEVELS PROCESSING...
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/user_database/access_levels.sql
echo ADMIN COMMAND ACCESS RIGHTS PROCESSING...
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/user_database/admin_command_access_rights.sql
echo AUCTION PROCESSING...
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/user_database/auction.sql
echo AUCTION BID PROCESSING...
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/user_database/auction_bid.sql
echo AUCTION WATCH PROCESSING...
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/user_database/auction_watch.sql
echo AUGMENTATIONS PROCESSING...
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/user_database/augmentations.sql
echo AUTO ANNOUNCEMENTS PROCESSING...
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/user_database/auto_announcements.sql
echo CASTLE PROCESSING...
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/user_database/castle.sql
echo CASTLE DOOR UPGRADE PROCESSING...
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/user_database/castle_doorupgrade.sql
echo CASTLE FUNCTIONS PROCESSING...
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/user_database/castle_functions.sql
echo CASTLE MANOR PROCURE PROCESSING...
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/user_database/castle_manor_procure.sql
echo CASTLE MANOR PRODUCTION PROCESSING...
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/user_database/castle_manor_production.sql
echo CHARACTER FRIENDS PROCESSING...
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/user_database/character_friends.sql
echo CHARACTER HENNA PROCESSING...
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/user_database/character_hennas.sql
echo CHARACTER MACRO PROCESSING...
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/user_database/character_macroses.sql
echo CHARACTER QUEST PROCESSING...
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/user_database/character_quests.sql
echo CHARACTER QUEST ITEMS PROCESSING...
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/user_database/character_quests_item.sql
echo CHARACTER RAID POINTS PROCESSING...
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/user_database/character_raidpoints.sql
echo CHARACTER RECIPEBOOK PROCESSING...
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/user_database/character_recipebook.sql
echo CHARACTER RECOMMENDS PROCESSING...
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/user_database/character_recommends.sql
echo CHARACTER SHORTCUT PROCESSING...
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/user_database/character_shortcuts.sql
echo CHARACTER SKILL PROCESSING...
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/user_database/character_skills.sql
echo CHARACTER SKILL SAVE PROCESSING...
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/user_database/character_skills_save.sql
echo CHARACTER STATS PROCESSING...
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/user_database/character_stats.sql
echo CHARACTER SUBCLASS PROCESSING...
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/user_database/character_subclasses.sql
echo CHARACTER PROCESSING...
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/user_database/characters.sql
echo CLAN DATA PROCESSING...
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/user_database/clan_data.sql
echo CLAN HALL PROCESSING...
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/user_database/clanhall.sql
echo CLAN PRIVILEGIES BY RANK PROCESSING...
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/user_database/clan_privs.sql
echo CLAN SKILLS PROCESSING...
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/user_database/clan_skills.sql
echo CLAN SUB PRIVILEGIES PROCESSING...
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/user_database/clan_subpledges.sql
echo CLAN WAR PROCESSING...
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/user_database/clan_wars.sql
echo CLAN HALL FUNCTIONS PROCESSING...
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/user_database/clanhall_functions.sql
echo COUPLES PROCESSING...
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/user_database/couples.sql
echo CURSED WEAPONS PROCESSING...
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/user_database/cursed_weapons.sql
echo FORTRESS PROCESSING...
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/user_database/fort.sql
echo FORTRESS DOORS UPGRADE PROCESSING...
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/user_database/fort_doorupgrade.sql
echo FORTRESS FUNCTIONS PROCESSING...
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/user_database/fort_functions.sql
echo FORTRESS SIEGE CLANS PROCESSING...
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/user_database/fortsiege_clans.sql
echo FORUMS PROCESSING...
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/user_database/forums.sql
echo GAMES PROCESSING...
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/user_database/games.sql
echo GLOBAL TASKS PROCESSING...
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/user_database/global_tasks.sql
echo GM AUDIT PROCESSING...
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/user_database/gm_audit.sql
echo GRAND BOSS INTERVAL LIST PROCESSING...
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/user_database/grandboss_intervallist.sql
echo HEROES PROCESSING...
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/user_database/heroes.sql
echo ITEMS PROCESSING...
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/user_database/items.sql
echo ITEMS ON GROUND PROCESSING...
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/user_database/items_on_ground.sql
echo OBJECT RESTRICTIONS PROCESSING...
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/user_database/obj_restrictions.sql
echo OLYMPIAD NOBLES PROCESSING...
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/user_database/olympiad_nobles.sql
echo PETITION PROCESSING...
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/user_database/petitions.sql
echo PET PROCESSING...
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/user_database/pets.sql
echo POST PROCESSING...
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/user_database/posts.sql
echo QUEST GLOBAL DATA PROCESSING...
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/user_database/quest_global_data.sql
echo RECORD PROCESSING...
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/user_database/record.sql
echo SEVEN SIGNS PROCESSING...
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/user_database/seven_signs.sql
echo SEVEN SIGNS FESTIVAL PROCESSING...
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/user_database/seven_signs_festival.sql
echo SEVEN SIGNS STATUS PROCESSING...
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/user_database/seven_signs_status.sql
echo SIEGE CLANS PROCESSING...
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/user_database/siege_clans.sql
echo TOPIC PROCESSING...
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/user_database/topic.sql
echo.
echo.
echo INSTALLING MODS DATABASE...
echo.
echo CTF PROCESSING...
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/mods/ctf.sql
echo CTF TEAMS PROCESSING...
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/mods/ctf_teams.sql
echo DEATH MATCH EVENT PROCESSING...
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/mods/dm.sql
echo JAIL SPAWNLIST PROCESSING...
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/mods/jail_spawnlist.sql
echo TVT PROCESSING...
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/mods/tvt.sql
echo TVT TEAMS PROCESSING...
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/mods/tvt_teams.sql
echo VIP EVENT PROCESSING...
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/mods/vipinfo.sql
echo.
echo.
echo INSTALLING CUSTOM DATABASE...
echo.
echo CHARACTERS CUSTOM DATA PROCESSING...
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/custom/characters_custom_data.sql
echo CUSTOM ARMOR PROCESSING...
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/custom/custom_armor.sql
echo CUSTOM ARMOR SETS PROCESSING...
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/custom/custom_armorsets.sql
echo CUSTOM DROP LIST PROCESSING...
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/custom/custom_droplist.sql
echo CUSTOM ETCITEM PROCESSING...
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/custom/custom_etcitem.sql
echo CUSTOM MERCHANT BUYLISTS PROCESSING...
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/custom/custom_merchant_buylists.sql
echo CUSTOM MERCHANT SHOP IDS PROCESSING...
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/custom/custom_merchant_shopids.sql
echo CUSTOM NPC PROCESSING...
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/custom/custom_npc.sql
echo CUSTOM NPC SKILLS PROCESSING...
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/custom/custom_npcskills.sql
echo CUSTOM SPAWNLIST PROCESSING...
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/custom/custom_spawnlist.sql
echo CUSTOM TELEPORTS PROCESSING...
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/custom/custom_teleports.sql
echo CUSTOM WEAPON PROCESSING...
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/custom/custom_weapon.sql
echo NPC BUFFER PROCESSING...
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/custom/npc_buffer.sql
echo.
echo.
echo FORCED UPDATES PROCESSING...
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/server_database/forced_updates.sql
echo.
echo.
echo.
echo GAMESERVER TABLES INSTALL COMPLETED !
echo.
echo.
echo ** GAMESERVER DATABASE UPDATER **
echo.
echo.
echo.
echo THIS PROGRAM WILL RUN ALL DATABASE UPDATES NEEDED FOR YOUR GAMESERVER.
echo.
echo.
echo IMPORTANT: USE THIS TOOL ONLY IF YOU UPGRADE FROM AN OLDER VERSION,
echo IF YOU JUST MADE A FRESH INSTALL THEN YOU DON'T NEED TO RUN THIS UPDATER.
echo.
echo.
echo WARNING: WHILE YOU ARE RUNNING THE UPDATER, YOU MAY GET ERRORS.
echo THIS IS CAUSED DUE TO OLDER UPDATE FILES, JUST IGNORE THEM.
echo MOST OF THEM SHOULD BE DUPLICATE ERRROR ON LINE 1.
echo.
echo.
echo SELECT: YES (Y) TO RUN AND INSTALL ALL DB UPDATES FOR GS.
echo.
echo QUIT (Q) TO CLOSE THIS PROGRAM.
echo.
:askupdate
set updateprompt=x
set /p installtype=UPDATE your database: (y) yes or (n) no?
if /i %installtype%==y goto updatedb
if /i %installtype%==n goto end
goto askupdate

:updatedb
echo UPDATING DATABASE...
echo.
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/maintenance/maintenance_17_05_2007.sql
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/maintenance/maintenance_18_05_2008.sql
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/maintenance/maintenance_19_05_2008.sql
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/maintenance/maintenance_20_05_2008.sql
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/maintenance/maintenance_21_05_2008.sql
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/maintenance/maintenance_22_05_2008.sql
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/maintenance/maintenance_23_05_2008.sql
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/maintenance/maintenance_24_05_2008.sql
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/maintenance/maintenance_25_05_2008.sql
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/maintenance/maintenance_26_05_2008.sql
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/maintenance/maintenance_27_05_2008.sql
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/maintenance/maintenance_28_05_2008.sql
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/maintenance/maintenance_29_05_2008.sql
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/maintenance/maintenance_30_05_2008.sql
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/maintenance/maintenance_31_05_2008.sql
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/maintenance/maintenance_01_06_2008.sql
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/maintenance/maintenance_02_06_2008.sql
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/maintenance/maintenance_03_06_2008.sql
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/maintenance/maintenance_04_06_2008.sql
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/maintenance/maintenance_05_06_2008.sql
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/maintenance/maintenance_06_06_2008.sql
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/maintenance/maintenance_07_06_2008.sql
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/maintenance/maintenance_08_06_2008.sql
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/maintenance/maintenance_09_06_2008.sql
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/maintenance/maintenance_10_06_2008.sql
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/maintenance/maintenance_11_06_2008.sql
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/maintenance/maintenance_12_06_2008.sql
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/maintenance/maintenance_13_06_2008.sql
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/maintenance/maintenance_14_06_2008.sql
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/maintenance/maintenance_18_06_2008.sql
%mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% < ../sql/maintenance/maintenance_21_06_2008.sql
REM ALWAYS ON LAST FILE SQL ENGINE RAID BOSS
:end
echo UPDATE COMPLETED !
echo.
echo IF YOU GOT DUPLICATE ERRORS ON LINE 1 IT MEANS YOUR DB IS ALREADY UPDATED.
echo JUST IGNORE THESE ERRORS.
:end
echo.
echo INTERACTIVE DATABASE INSTALLER COMPLETED !
echo.
echo.
echo CONTACTS : http://www.l2emu.net/
echo.
echo.
echo POWERED BY L2EMU PROJECT DEVELOPMENT TEAM.
echo COPYRIGHT 2005-2008 - ALL RIGHTS RESERVED.
echo.
echo Patch by RAYAN.
echo.
pause



что там не так? параметры базы, пароль и т.д. выставлены.
немного смущает строчка
set workdir="%cd%"

[HellBound]

Моё предположение ниже
@echo off
color 17
title L2Emu Project: Database Installer
echo.
echo.
echo ** [ L2EMU PROJECT INTERACTIVE DATABASE INSTALLER ]**
echo.
echo.
echo.
set workdir="%cd%"
:loadVars
if not exist vars.txt goto createVars
ren vars.txt *.bat
call vars.bat
ren vars.bat *.txt
cls
goto start
:createVars
echo ** [ MYSQL SERVER SETUP ] **
echo.
echo DIGIT YOUR MYSQL BIN PATH (PATH TO YOUR MYSQL SERVER BIN FOLDER)
echo.
set /P mysqlBinPath="MYSQL PATH :C:\Program Files\MySQL\MySQL Server 6.0\bin" это путь к мускулу
echo.
echo LOGIN SERVER SETTINGS
echo --------------------
set /P lsuser="USER (DEFAULT: 'Root'):Root" - пользователь
echo.
set /P lspass="PASS (WILL BE SHOW AND SAVED AS CLEAR TEXT):123456789" пасс
echo.
set /P lsdb="DATABASE (DEFAULT:'L2Emu_DB'):твоя база "
echo.
set /P lshost="HOST (DEFAULT: 'LOCALHOST'): тут локалхост"
echo.
echo.
echo GAMESERVER SETTINGS
echo -------------------
set /P gsuser="USER (DEFAULT: 'Root'): Root "
echo.
set /P gspass="PASS (WILL BE SHOW AND SAVED AS CLEAR TEXT): твой пароль "
echo.
set /P gsdb="DATABASE (DEFAULT:'L2Emu_DB'): твоя база "
echo.
set /P gshost="HOST (DEFAULT: 'LOCALHOST'):локалхост "
echo.

[PEPSI]

у меня таже ошыбка не выходит зделал как в другом варианте проблема актуальна

[Гость_Britan_*]

Проблема висит. Кто-нить дайте ответ на данный вопрос. Виста х32. Эму 4691

[Leap]

хз возможно ты неправильно прописал путь к mysql т.к. я только что сделал set mysqldumpPath="\mysqldump" и тут же выдало
""\mysqldump"" не является внутренней или внешней
командой, исполняемой программой или пакетным файлом.

WARNING: A full install (f) will destroy data in your
`accounts` and `gameserver` tables.
Choose upgrade (u) if you already have an `accounts` table but no
`gameserver` table (ie. your server is a pre LS/GS split version.)
Choose skip (s) to skip loginserver DB installation and go to
gameserver DB installation/upgrade.
LOGINSERVER DB install type: (f) full or (s) skip or (q) quit?
теперь что я хотел этим сказать) то что у тебя в файле vars.txt возможно неправильная строка

Скрытый текст

@set mysqldumpPath="G:\Program Files\MySQL\MySQL Server 6.0\bin\mysqldump"

Сообщение отредактировал Leap - 15.2.2009, 21:33

[Fallenlord17rus]

хз возможно ты неправильно прописал путь к mysql т.к. я только что сделал set mysqldumpPath="\mysqldump" и тут же выдало
""\mysqldump"" не является внутренней или внешней
командой, исполняемой программой или пакетным файлом.

WARNING: A full install (f) will destroy data in your
`accounts` and `gameserver` tables.
Choose upgrade (u) if you already have an `accounts` table but no
`gameserver` table (ie. your server is a pre LS/GS split version.)
Choose skip (s) to skip loginserver DB installation and go to
gameserver DB installation/upgrade.
LOGINSERVER DB install type: (f) full or (s) skip or (q) quit?
теперь что я хотел этим сказать) то что у тебя в файле vars.txt возможно неправильная строка

Скрытый текст

@set mysqldumpPath="G:\Program Files\MySQL\MySQL Server 6.0\bin\mysqldump"

Да тут элементарная невнимательность, у вас неправельный путь до Мускула,если же всетаки вы так и ненашли свою ошибку
вручную заливайте все таблицы.... Урок для вас будет:)