Проблема с базой MySQL...

[Сергей_98]

Привет всем...
Тут такая тема, короче я недавно скачал сервер L2Phoenix rev 20736.
Решил посмотреть что за сборка. (2 года ей)
Ну короче вроде всё настроил и начал заливать базу для этого сервера.
Проблема в том что у меня не заливаются некоторые таблицы.
Вот конфиги и другое)

Конфиги установочника:

Свернуть ↑ @echo off
TITLE L2 Phoenix Setup
REM ######################################## Automatic updater for L2 Phoenix - Do not edit !!!
goto answer%ERRORLEVEL%
:answerTrue
set fastend=yes
goto upgrade_db
:answer0
set fastend=no

set user=root
set pass=root
set DBname=l2db
set DBHost=localhost

set Generaltables=accounts augmentations clanhall gameservers banned_ips loginserv_log character_friends character_hennas character_macroses character_quests character_recipebook character_shortcuts character_skills character_effects_save character_skills_save character_subclasses characters character_variables clanhall_bids clanhall_data clan_data clanhall_decorations_bids ally_data clan_wars items pets server_variables seven_signs seven_signs_festival siege_clans killcount dropcount craftcount game_log petitions seven_signs_status global_tasks raidboss_status manor_crop manor_seeds
set Ignore=--ignore-table=%DBname%.game_log --ignore-table=%DBname%.loginserv_log --ignore-table=%DBname%.petitions

REM ########################################
mysql.exe -h %DBHost% -u %user% --password=%pass% --execute="CREATE DATABASE IF NOT EXISTS %DBname%"
if not exist backup (
mkdir backup
)

REM ######################################## :main_menu
:main_menu
cls
echo.L2 Phoenix Setup
echo.
echo.### Main Menu ###
echo.
echo.(1) Install Login Server
echo.(2) Install Game Server
echo.(3) Upgrade DB
echo.(4) Backup DB
echo.(5) Restore DB
echo.(6) Lost data in DB
echo.(7) Install option data
echo.(q) Quit
echo.
set button=x
set /p button=What do you want ?:
if /i %button%==1 goto Install_Login_Server_menu
if /i %button%==2 goto Install_Game_Server_menu
if /i %button%==3 goto upgrade_menu
if /i %button%==4 goto backup_menu
if /i %button%==5 goto restore_menu
if /i %button%==6 goto lost_data_menu
if /i %button%==7 goto install_option_data
if /i %button%==q goto end
goto main_menu

REM ######################################## :Install_Login_Server_menu
:Install_Login_Server_menu
cls
echo.L2 Phoenix Setup
echo.
echo.### Install Login Server ###
echo.
echo.(i) Install Login Server. Warning !!! accounts, gameservers, banned_ips will be deleted !!!
echo.(m) Main menu
echo.(q) Quit
echo.
set button=x
set /p button=Your choice ?:
if /i %button%==i goto Install_Login_Server
if /i %button%==m goto main_menu
if /i %button%==q goto end
goto Install_Login_Server_menu

REM ######################################## :Install_Game_Server_menu
:Install_Game_Server_menu
cls
echo.L2 Phoenix Setup
echo.
echo.### Install Game Server ###
echo.
echo.(i) Install Game Server. Warning !!! All Game Server Database will be deleted !!!
echo.(m) Main menu
echo.(q) Quit
echo.
set button=x
set /p button=Your choice ?:
if /i %button%==i goto Install_Game_Server
if /i %button%==m goto main_menu
if /i %button%==q goto end
goto Install_Game_Server_menu

REM ######################################## :upgrade_menu
:upgrade_menu
cls
echo.L2 Phoenix Setup
echo.
echo.### Upgrade Menu ###
echo.
echo.(u) Upgrade Database
echo.(m) Main menu
echo.(q) Quit
echo.
set button=x
set /p button=Your choice ?:
if /i %button%==u goto upgrade_db
if /i %button%==m goto main_menu
if /i %button%==q goto end
goto upgrade_menu

REM ######################################## :backup_menu
:backup_menu
cls
echo.L2 Phoenix 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 general_backup
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.L2 Phoenix 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 ######################################## :lost_data_menu
:lost_data_menu
cls
echo.L2 Phoenix Setup
echo.
echo.### Lost Data Menu ###
echo.
echo.(1) Show lost data
echo.(2) Delete lost data
echo.(m) Main menu
echo.(q) Quit
echo.
set button=x
set /p button=Select backup type ?:
if /i %button%==1 goto show_lost_data
if /i %button%==2 goto delete_lost_data
if /i %button%==m goto main_menu
if /i %button%==q goto end
goto lost_data_menu

:show_lost_data
mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < tools/maintenance/lost_data_show.sql
pause
goto lost_data_menu

:delete_lost_data
mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < tools/maintenance/lost_data_del.sql
echo.
echo.All lost data deleted !!!
echo.
pause
goto lost_data_menu

REM ######################################## :install_option_data
:install_option_data
cls
echo.L2 Phoenix Setup
echo.
echo.### Install_option_data ###
echo.
echo.(1) Install TeleToGH SQL patch
echo.(m) Main menu
echo.(q) Quit
echo.
set button=x
set /p button=Your choice ?:
if /i %button%==1 goto Install_TeleToGH
if /i %button%==m goto main_menu
if /i %button%==q goto end
goto Install_TeleToGH

REM ######################################## :Install_TeleToGH
:Install_TeleToGH
echo.Installing TeleToGH SQL patch !!!
echo.
mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < optional/teletogh/patch.sql
echo.
echo.TeleToGH SQL patch Installed !!!
echo.
pause
goto main_menu

REM ######################################## :Install_Login_Server
:Install_Login_Server
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.
mysqldump.exe %Ignore% --add-drop-table -h %DBHost% -u %user% --password=%pass% %DBname% > backup/%DATE%-%ctime%_backup_full.sql
echo.
echo.Installing Login Server !!!
echo.
mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < login/accounts.sql
mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < login/gameservers.sql
mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < login/banned_ips.sql
mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < login/loginserv_log.sql
mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < login/lock.sql
echo.
echo.Login Server Installed !!!
echo.
pause
goto main_menu

REM ######################################## :Install_Game_Server
:Install_Game_Server
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.
mysqldump.exe %Ignore% --add-drop-table -h %DBHost% -u %user% --password=%pass% %DBname% > backup/%DATE%-%ctime%_backup_full.sql
echo.
echo.Installing general tables !!!
echo.
echo Loading Table: ally_data
mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < install/ally_data.sql
echo Loading Table: auction
mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < install/auction.sql
echo Loading Table: auction_bid
mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < install/auction_bid.sql
echo Loading Table: bans
mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < install/bans.sql
echo Loading Table: bonus
mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < install/bonus.sql
echo Loading Table: castle
mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < install/castle.sql
echo Loading Table: castle_manor_procure
mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < install/castle_manor_procure.sql
echo Loading Table: castle_manor_production
mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < install/castle_manor_production.sql
echo Loading Table: character_blocklist
mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < install/character_blocklist.sql
echo Loading Table: character_bookmarks
mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < install/character_bookmarks.sql
echo Loading Table: character_effects_save
mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < install/character_effects_save.sql
echo Loading Table: character_friends
mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < install/character_friends.sql
echo Loading Table: character_hennas
mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < install/character_hennas.sql
echo Loading Table: character_macroses
mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < install/character_macroses.sql
echo Loading Table: character_quests
mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < install/character_quests.sql
echo Loading Table: character_recipebook
mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < install/character_recipebook.sql
echo Loading Table: character_shortcuts
mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < install/character_shortcuts.sql
echo Loading Table: character_skills
mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < install/character_skills.sql
echo Loading Table: character_skills_save
mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < install/character_skills_save.sql
echo Loading Table: character_subclasses
mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < install/character_subclasses.sql
echo Loading Table: character_variables
mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < install/character_variables.sql
echo Loading Table: characters
mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < install/characters.sql
echo Loading Table: clan_data
mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < install/clan_data.sql
echo Loading Table: clan_notices
mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < install/clan_notices.sql
echo Loading Table: clan_privs
mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < install/clan_privs.sql
echo Loading Table: clan_skills
mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < install/clan_skills.sql
echo Loading Table: clan_subpledges
mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < install/clan_subpledges.sql
echo Loading Table: clan_wars
mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < install/clan_wars.sql
echo Loading Table: clanhall
mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < install/clanhall.sql
echo Loading Table: couples
mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < install/couples.sql
echo Loading Table: craftcount
mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < install/craftcount.sql
echo Loading Table: cursed_weapons
mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < install/cursed_weapons.sql
echo Loading Table: dropcount
mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < install/dropcount.sql
echo Loading Table: epic_boss_spawn
mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < install/epic_boss_spawn.sql
echo Loading Table: forts
mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < install/forts.sql
echo Loading Table: forums
mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < install/forums.sql
echo Loading Table: game_log
mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < install/game_log.sql
echo Loading Table: games
mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < install/games.sql
echo Loading Table: global_tasks
mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < install/global_tasks.sql
echo Loading Table: heroes
mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < install/heroes.sql
echo Loading Table: item_attributes
mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < install/item_attributes.sql
echo Loading Table: items
mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < install/items.sql
echo Loading Table: items_delayed
mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < install/items_delayed.sql
echo Loading Table: killcount
mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < install/killcount.sql
echo Loading Table: mail
mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < install/mail.sql
echo Loading Table: olympiad_nobles
mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < install/olympiad_nobles.sql
echo Loading Table: petitions
mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < install/petitions.sql
echo Loading Table: pets
mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < install/pets.sql
echo Loading Table: posts
mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < install/posts.sql
echo Loading Table: raidboss_points
mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < install/raidboss_points.sql
echo Loading Table: raidboss_status
mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < install/raidboss_status.sql
echo Loading Table: residence_functions
mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < install/residence_functions.sql
echo Loading Table: server_variables
mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < install/server_variables.sql
echo Loading Table: seven_signs
mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < install/seven_signs.sql
echo Loading Table: seven_signs_festival
mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < install/seven_signs_festival.sql
echo Loading Table: seven_signs_status
mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < install/seven_signs_status.sql
echo Loading Table: siege_clans
mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < install/siege_clans.sql
echo Loading Table: siege_doorupgrade
mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < install/siege_doorupgrade.sql
echo Loading Table: siege_guards
mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < install/siege_guards.sql
echo Loading Table: siege_territory_members
mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < install/siege_territory_members.sql
echo Loading Table: topic
mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < install/topic.sql
echo Loading Table: tournament_table
mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < install/tournament_table.sql
echo Loading Table: tournament_teams
mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < install/tournament_teams.sql
echo Loading Table: tournament_variables
mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < install/tournament_variables.sql
echo Loading Table: vote
mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < install/vote.sql

goto upgrade_db

REM ######################################## :upgrade_db
:upgrade_db
echo.
echo Upgrading tables !!!
echo.
echo Loading Table: ai_params
mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < upgrade/ai_params.sql
echo Loading Table: armor
mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < upgrade/armor.sql
echo Loading Table: armor_ex
mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < upgrade/armor_ex.sql
echo Loading Table: armorsets
mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < upgrade/armorsets.sql
echo Loading Table: auto_chat
mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < upgrade/auto_chat.sql
echo Loading Table: auto_chat_text
mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < upgrade/auto_chat_text.sql
echo Loading Table: char_templates
mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < upgrade/char_templates.sql
echo Loading Table: class_list
mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < upgrade/class_list.sql
echo Loading Table: doors
mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < upgrade/doors.sql
echo Loading Table: droplist
mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < upgrade/droplist.sql
echo Loading Table: etcitem
mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < upgrade/etcitem.sql
echo Loading Table: fish
mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < upgrade/fish.sql
echo Loading Table: fishreward
mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < upgrade/fishreward.sql
echo Loading Table: four_sepulchers_spawnlist
mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < upgrade/four_sepulchers_spawnlist.sql
echo Loading Table: henna
mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < upgrade/henna.sql
echo Loading Table: henna_trees
mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < upgrade/henna_trees.sql
echo Loading Table: lastimperialtomb_spawnlist
mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < upgrade/lastimperialtomb_spawnlist.sql
echo Loading Table: locations
mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < upgrade/locations.sql
echo Loading Table: lvlupgain
mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < upgrade/lvlupgain.sql
echo Loading Table: mapregion
mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < upgrade/mapregion.sql
echo Loading Table: merchant_areas_list
mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < upgrade/merchant_areas_list.sql
echo Loading Table: minions
mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < upgrade/minions.sql
echo Loading Table: npc
mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < upgrade/npc.sql
echo Loading Table: npcskills
mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < upgrade/npcskills.sql
echo Loading Table: pet_data
mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < upgrade/pet_data.sql
echo Loading Table: pets_skills
mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < upgrade/pets_skills.sql
echo Loading Table: random_spawn
mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < upgrade/random_spawn.sql
echo Loading Table: random_spawn_loc
mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < upgrade/random_spawn_loc.sql
echo Loading Table: recipes
mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < upgrade/recipes.sql
echo Loading Table: recitems
mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < upgrade/recitems.sql
echo Loading Table: siege_door
mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < upgrade/siege_door.sql
echo Loading Table: skills
mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < upgrade/skills.sql
echo Loading Table: skill_learn
mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < upgrade/skill_learn.sql
echo Loading Table: skill_spellbooks
mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < upgrade/skill_spellbooks.sql
echo Loading Table: skill_trees
mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < upgrade/skill_trees.sql
echo Loading Table: spawnlist
mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < upgrade/spawnlist.sql
echo Loading Table: tournament_class_list
mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < upgrade/tournament_class_list.sql
echo Loading Table: weapon
mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < upgrade/weapon.sql
echo Loading Table: weapon_ex
mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < upgrade/weapon_ex.sql
echo Loading Table: updates
mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < upgrade/updates.sql

echo.
echo.Complete !!!
echo.
if /I %fastend%==yes goto :EOF
pause
goto main_menu

REM ######################################## :full_backup
:full_backup
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.
mysqldump.exe %Ignore% --add-drop-table -h %DBHost% -u %user% --password=%pass% %DBname% > backup/%DATE%-%ctime%_backup_full.sql
goto end

REM ######################################## :general_backup
:general_backup
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 general tables backup into %DATE%-%ctime%_backup_general.sql
echo.
mysqldump.exe %Ignore% --add-drop-table -h %DBHost% -u %user% --password=%pass% %DBname% %Generaltables% > backup/%DATE%-%ctime%_backup_general.sql
goto end

REM ######################################## :restore_DB
:restore_DB
if not exist backup/%filename% (
echo.
echo.File not found !
echo.
pause
goto restore_menu
)
cls
echo.
echo.Restore from file %filename% !
echo.
pause
mysql.exe -h %DBHost% -u %user% --password=%pass% -D %DBname% < backup/%filename%
goto end

REM ######################################## :not_working_now
:not_working_now
echo.
echo Not working NOW !!!
echo.
pause
goto main_menu

REM ######################################## :end
:end

Свернуть ↑Развернуть ↓

Процесс установки Login server:

Свернуть ↑ Installing Login Server !!!

ERROR 1064 (42000) at line 3: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use n
ear 'TYPE=MyISAM' at line 6
ERROR 1064 (42000) at line 1: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use n
ear 'TYPE=MyISAM' at line 8

Login Server Installed !!!

Свернуть ↑Развернуть ↓

Процесс установки Game server:

Свернуть ↑ Installing general tables !!!

Loading Table: ally_data
ERROR 1064 (42000) at line 1: You have an error in your SQL syntax; check the ma
nual that corresponds to your MySQL server version for the right syntax to use n
ear 'TYPE=MyISAM' at line 9
Loading Table: auction
Loading Table: auction_bid
ERROR 1064 (42000) at line 1: You have an error in your SQL syntax; check the ma
nual that corresponds to your MySQL server version for the right syntax to use n
ear 'TYPE=MyISAM' at line 11
Loading Table: bans
Loading Table: bonus
Loading Table: castle
ERROR 1064 (42000) at line 1: You have an error in your SQL syntax; check the ma
nual that corresponds to your MySQL server version for the right syntax to use n
ear 'TYPE=MyISAM' at line 15
Loading Table: castle_manor_procure
Loading Table: castle_manor_production
Loading Table: character_blocklist
Loading Table: character_bookmarks
Loading Table: character_effects_save
ERROR 1064 (42000) at line 1: You have an error in your SQL syntax; check the ma
nual that corresponds to your MySQL server version for the right syntax to use n
ear 'TYPE=MyISAM' at line 11
Loading Table: character_friends
Loading Table: character_hennas
ERROR 1064 (42000) at line 1: You have an error in your SQL syntax; check the ma
nual that corresponds to your MySQL server version for the right syntax to use n
ear 'TYPE=MyISAM' at line 7
Loading Table: character_macroses
ERROR 1064 (42000) at line 1: You have an error in your SQL syntax; check the ma
nual that corresponds to your MySQL server version for the right syntax to use n
ear 'TYPE=MyISAM' at line 10
Loading Table: character_quests
ERROR 1064 (42000) at line 1: You have an error in your SQL syntax; check the ma
nual that corresponds to your MySQL server version for the right syntax to use n
ear 'TYPE=MyISAM' at line 7
Loading Table: character_recipebook
ERROR 1064 (42000) at line 1: You have an error in your SQL syntax; check the ma
nual that corresponds to your MySQL server version for the right syntax to use n
ear 'TYPE=MyISAM' at line 5
Loading Table: character_shortcuts
ERROR 1064 (42000) at line 1: You have an error in your SQL syntax; check the ma
nual that corresponds to your MySQL server version for the right syntax to use n
ear 'TYPE=MyISAM' at line 11
Loading Table: character_skills
ERROR 1064 (42000) at line 1: You have an error in your SQL syntax; check the ma
nual that corresponds to your MySQL server version for the right syntax to use n
ear 'TYPE=MyISAM' at line 8
Loading Table: character_skills_save
Loading Table: character_subclasses
ERROR 1064 (42000) at line 1: You have an error in your SQL syntax; check the ma
nual that corresponds to your MySQL server version for the right syntax to use n
ear 'TYPE=MyISAM' at line 18
Loading Table: character_variables
Loading Table: characters
ERROR 1064 (42000) at line 1: You have an error in your SQL syntax; check the ma
nual that corresponds to your MySQL server version for the right syntax to use n
ear 'TYPE=MyISAM' at line 42
Loading Table: clan_data
ERROR 1064 (42000) at line 1: You have an error in your SQL syntax; check the ma
nual that corresponds to your MySQL server version for the right syntax to use n
ear 'TYPE=MyISAM' at line 21
Loading Table: clan_notices
Loading Table: clan_privs
ERROR 1064 (42000) at line 1: You have an error in your SQL syntax; check the ma
nual that corresponds to your MySQL server version for the right syntax to use n
ear 'TYPE=MyISAM' at line 6
Loading Table: clan_skills
ERROR 1064 (42000) at line 1: You have an error in your SQL syntax; check the ma
nual that corresponds to your MySQL server version for the right syntax to use n
ear 'TYPE=MyISAM' at line 7
Loading Table: clan_subpledges
ERROR 1064 (42000) at line 1: You have an error in your SQL syntax; check the ma
nual that corresponds to your MySQL server version for the right syntax to use n
ear 'TYPE=MyISAM' at line 7
Loading Table: clan_wars
ERROR 1064 (42000) at line 1: You have an error in your SQL syntax; check the ma
nual that corresponds to your MySQL server version for the right syntax to use n
ear 'TYPE=MyISAM' at line 4
Loading Table: clanhall
Loading Table: couples
Loading Table: craftcount
Loading Table: cursed_weapons
Loading Table: dropcount
Loading Table: epic_boss_spawn
Loading Table: forts
Loading Table: forums
ERROR 1064 (42000) at line 1: You have an error in your SQL syntax; check the ma
nual that corresponds to your MySQL server version for the right syntax to use n
ear 'TYPE=MyISAM' at line 11
Loading Table: game_log
Loading Table: games
ERROR 1064 (42000) at line 1: You have an error in your SQL syntax; check the ma
nual that corresponds to your MySQL server version for the right syntax to use n
ear 'TYPE=MyISAM' at line 14
Loading Table: global_tasks
ERROR 1064 (42000) at line 1: You have an error in your SQL syntax; check the ma
nual that corresponds to your MySQL server version for the right syntax to use n
ear 'TYPE=MyISAM' at line 10
Loading Table: heroes
ERROR 1064 (42000) at line 1: You have an error in your SQL syntax; check the ma
nual that corresponds to your MySQL server version for the right syntax to use n
ear 'TYPE=MyISAM' at line 7
Loading Table: item_attributes
ERROR 1064 (42000) at line 1: You have an error in your SQL syntax; check the ma
nual that corresponds to your MySQL server version for the right syntax to use n
ear 'TYPE=MyISAM' at line 9
Loading Table: items
ERROR 1064 (42000) at line 1: You have an error in your SQL syntax; check the ma
nual that corresponds to your MySQL server version for the right syntax to use n
ear 'TYPE=MyISAM' at line 20
Loading Table: items_delayed
ERROR 1064 (42000) at line 1: You have an error in your SQL syntax; check the ma
nual that corresponds to your MySQL server version for the right syntax to use n
ear 'TYPE=MyISAM' at line 15
Loading Table: killcount
Loading Table: mail
Loading Table: olympiad_nobles
Loading Table: petitions
ERROR 1064 (42000) at line 1: You have an error in your SQL syntax; check the ma
nual that corresponds to your MySQL server version for the right syntax to use n
ear 'TYPE=MyISAM' at line 17
Loading Table: pets
ERROR 1064 (42000) at line 1: You have an error in your SQL syntax; check the ma
nual that corresponds to your MySQL server version for the right syntax to use n
ear 'TYPE=MyISAM' at line 13
Loading Table: posts
ERROR 1064 (42000) at line 1: You have an error in your SQL syntax; check the ma
nual that corresponds to your MySQL server version for the right syntax to use n
ear 'TYPE=MyISAM' at line 10
Loading Table: raidboss_points
Loading Table: raidboss_status
ERROR 1064 (42000) at line 1: You have an error in your SQL syntax; check the ma
nual that corresponds to your MySQL server version for the right syntax to use n
ear 'TYPE=MyISAM' at line 7
Loading Table: residence_functions
ERROR 1064 (42000) at line 1: You have an error in your SQL syntax; check the ma
nual that corresponds to your MySQL server version for the right syntax to use n
ear 'TYPE=MyISAM' at line 10
Loading Table: server_variables
Loading Table: seven_signs
ERROR 1064 (42000) at line 1: You have an error in your SQL syntax; check the ma
nual that corresponds to your MySQL server version for the right syntax to use n
ear 'TYPE=MyISAM' at line 16
Loading Table: seven_signs_festival
Loading Table: seven_signs_status
ERROR 1064 (42000) at line 1: You have an error in your SQL syntax; check the ma
nual that corresponds to your MySQL server version for the right syntax to use n
ear 'TYPE=MyISAM' at line 25
Loading Table: siege_clans
ERROR 1064 (42000) at line 1: You have an error in your SQL syntax; check the ma
nual that corresponds to your MySQL server version for the right syntax to use n
ear 'TYPE=MyISAM' at line 6
Loading Table: siege_doorupgrade
ERROR 1064 (42000) at line 1: You have an error in your SQL syntax; check the ma
nual that corresponds to your MySQL server version for the right syntax to use n
ear 'TYPE=MyISAM' at line 5
Loading Table: siege_guards
Loading Table: siege_territory_members
Loading Table: topic
Loading Table: tournament_table
Loading Table: tournament_teams
Loading Table: tournament_variables
Loading Table: vote

Upgrading tables !!!

Loading Table: ai_params
Loading Table: armor
Loading Table: armor_ex
Loading Table: armorsets
Loading Table: auto_chat
Loading Table: auto_chat_text
Loading Table: char_templates
Loading Table: class_list
Loading Table: doors
Loading Table: droplist
Loading Table: etcitem
Loading Table: fish
Loading Table: fishreward
Loading Table: four_sepulchers_spawnlist
Loading Table: henna
Loading Table: henna_trees
Loading Table: lastimperialtomb_spawnlist
Loading Table: locations
Loading Table: lvlupgain
Loading Table: mapregion
Loading Table: merchant_areas_list
Loading Table: minions
Loading Table: npc
Loading Table: npcskills
Loading Table: pet_data
Loading Table: pets_skills
Loading Table: random_spawn
Loading Table: random_spawn_loc
Loading Table: recipes
Loading Table: recitems
Loading Table: siege_door
Loading Table: skills
Loading Table: skill_learn
Loading Table: skill_spellbooks
Loading Table: skill_trees
Loading Table: spawnlist
Loading Table: tournament_class_list
Loading Table: weapon
Loading Table: weapon_ex
Loading Table: updates
ERROR 1146 (42S02) at line 23: Table 'l2db.character_quests' doesn't exist

Complete !!!

Свернуть ↑Развернуть ↓

Дайте ответ как можно быстрей!!!
За ранее спасибо!

[Ozzy]

Самый простой вариант избавиться от ошибки - поставить MySQL 5.1 вместо того что установили Вы.

P.S.: В следующий раз внимательнее проверяйте что пишете в названии темы.

P.P.S.: Только за "Дайте ответ как можно быстрей!!!" Вам бы не стоило давать ответ. Выглядит как требование, а не как просьба помочь.

[Сергей_98]

Извините, буду в следующий раз внимательней, требований больше не будет.
Тут выскочила ещё 1 проблема с геодатой.

Вся загрузка gameserver:

Свернуть ↑
Making a full backup into 14.06.2013-17'29'14_backup_full.sql

"mysqldump.exe" не является внутренней или внешней
командой, исполняемой программой или пакетным файлом.

Backup complite 14.06.2013-17'29'14_backup_full.sql

Starting L2P Game Server.

17:29:16.640 Gameserver Version: exported, build date: 2010.08.12 03:12
17:29:17.140 Loading gameserver config.
17:29:17.171 Abuse: Loaded 18 abuse words.
17:29:17.484 loading xml GMAccess
17:29:17.515 MLog clients using java 1.4+ standard logging.
17:29:17.703 Initializing c3p0-0.9.1.2 [built 21-May-2007 15:04:56; debug? true
; trace: 10]
17:29:17.796 Initializing c3p0 pool... com.mchange.v2.c3p0.ComboPooledDataSourc
e [ acquireIncrement -> 5, acquireRetryAttempts -> 0, acquireRetryDelay -> 100,
autoCommitOnClose -> true, automaticTestTable -> null, breakAfterAcquireFailure
-> false, checkoutTimeout -> 0, connectionCustomizerClassName -> null, connectio
nTesterClassName -> com.mchange.v2.c3p0.impl.DefaultConnectionTester, dataSource
Name -> 30jmc78vi2uuwa1vcxstm|101614a, debugUnreturnedConnectionStackTraces -> f
alse, description -> null, driverClass -> com.mysql.jdbc.Driver, factoryClassLoc
ation -> null, forceIgnoreUnresolvedTransactions -> false, identityToken -> 30jm
c78vi2uuwa1vcxstm|101614a, idleConnectionTestPeriod -> 60, initialPoolSize -> 1,
jdbcUrl -> jdbc:mysql://localhost/l2db, maxAdministrativeTaskTime -> 0, maxConn
ectionAge -> 0, maxIdleTime -> 600, maxIdleTimeExcessConnections -> 0, maxPoolSi
ze -> 50, maxStatements -> 100, maxStatementsPerConnection -> 0, minPoolSize ->
1, numHelperThreads -> 5, numThreadsAwaitingCheckoutDefaultUser -> 0, preferredT
estQuery -> null, properties -> {user=******, password=******}, propertyCycle ->
0, testConnectionOnCheckin -> false, testConnectionOnCheckout -> false, unretur
nedConnectionTimeout -> 0, usesTraditionalReflectiveProxies -> false ]
17:29:19.015 Loaded 418 translit entrys
17:29:19.031 Clear characters online status and accesslevel.
17:29:19.031 Total cleaned: 0, updated: 0 elements in database.
17:29:19.125 IdFactory: Extracting 0 used id's from data tables...
17:29:19.125 IdFactory: Successfully extracted 0 used id's from data tables.
17:29:19.125 IDFactory: 102912 id's available.
17:29:19.156 CrestCache: Loaded 0 crests
17:29:19.171 Initializing AuctionManager
17:29:19.593 Loaded: 38 active auction(s)
17:29:24.281 SkillsEngine: Loaded 61000 skill templates from XML files. Max id:
26073, max level: 259
17:29:28.375 PetSkillsTable: Loaded 2187 skills.
17:29:29.203 ItemTable: Loaded 2919 Armors.
17:29:29.218 ItemTable: Loaded 10077 Items.
17:29:29.750 ItemTable: Loaded 3499 Weapons.
17:29:29.937 ArmorSetsTable: Loaded 171 armor sets.
17:29:30.234 TradeController: Loaded 4 file(s).
17:29:30.234 TradeController: Loaded 27864 Items.
17:29:30.234 TradeController: Loaded 822 Buylists.
17:29:30.468 RecipeController: Loaded 936 Recipes.
17:29:34.609 SkillTreeTable: Loaded 16575 skills.
17:29:34.609 SkillTreeTable: Loaded 109 fishing skills.
17:29:34.609 SkillTreeTable: Loaded 20 transformation skills.
17:29:34.609 SkillTreeTable: Loaded 64 clan skills.
17:29:34.609 SkillTreeTable: Loaded 523 enchanted skills.
17:29:34.640 SkillSpellbookTable: Loaded 85 Spellbooks.
17:29:34.750 CharTemplateTable: Loaded 206 Character Templates.
17:29:34.812 NpcTable: Loaded 375 AI params for 278 NPCs.
17:29:35.093 Scripts loading...
17:29:57.015 error while creating npc table
java.lang.NullPointerException
at l2p.extensions.scripts.Compiler.<init>(Compiler.ja va:36)
at l2p.extensions.scripts.Compiler.getInstance(Compil er.java:30)
at l2p.extensions.scripts.Scripts.load(Scripts.java:1 25)
at l2p.extensions.scripts.Scripts.<init>(Scripts.java :50)
at l2p.extensions.scripts.Scripts.getInstance(Scripts .java:43)
at l2p.gameserver.templates.L2NpcTemplate.setInstance (L2NpcTemplate.java
:183)
at l2p.gameserver.templates.L2NpcTemplate.<init>(L2Np cTemplate.java:132)

at l2p.gameserver.tables.NpcTable.fillNpcTable(NpcTab le.java:402)
at l2p.gameserver.tables.NpcTable.RestoreNpcData(NpcT able.java:90)
at l2p.gameserver.tables.NpcTable.<init>(NpcTable.jav a:58)
at l2p.gameserver.tables.NpcTable.getInstance(NpcTabl e.java:47)
at l2p.gameserver.GameServer.<init>(GameServer.java:2 00)
at l2p.gameserver.GameServer.main(GameServer.java:514 )

17:29:57.125 error while reading npcskills table
java.lang.NullPointerException
at l2p.gameserver.tables.NpcTable.RestoreNpcData(NpcT able.java:113)
at l2p.gameserver.tables.NpcTable.<init>(NpcTable.jav a:58)
at l2p.gameserver.tables.NpcTable.getInstance(NpcTabl e.java:47)
at l2p.gameserver.GameServer.<init>(GameServer.java:2 00)
at l2p.gameserver.GameServer.main(GameServer.java:514 )

17:29:57.218 error reading npc drops
java.lang.NullPointerException
at l2p.gameserver.tables.NpcTable.RestoreNpcData(NpcT able.java:175)
at l2p.gameserver.tables.NpcTable.<init>(NpcTable.jav a:58)
at l2p.gameserver.tables.NpcTable.getInstance(NpcTabl e.java:47)
at l2p.gameserver.GameServer.<init>(GameServer.java:2 00)
at l2p.gameserver.GameServer.main(GameServer.java:514 )

17:29:57.218 error loading minions
java.lang.NullPointerException
at l2p.gameserver.tables.NpcTable.RestoreNpcData(NpcT able.java:243)
at l2p.gameserver.tables.NpcTable.<init>(NpcTable.jav a:58)
at l2p.gameserver.tables.NpcTable.getInstance(NpcTabl e.java:47)
at l2p.gameserver.GameServer.<init>(GameServer.java:2 00)
at l2p.gameserver.GameServer.main(GameServer.java:514 )

17:29:57.218 error loading minions
java.lang.NullPointerException
at l2p.gameserver.tables.NpcTable.RestoreNpcData(NpcT able.java:271)
at l2p.gameserver.tables.NpcTable.<init>(NpcTable.jav a:58)
at l2p.gameserver.tables.NpcTable.getInstance(NpcTabl e.java:47)
at l2p.gameserver.GameServer.<init>(GameServer.java:2 00)
at l2p.gameserver.GameServer.main(GameServer.java:514 )

17:29:57.281 HennaTable: Loaded 180 Templates.
17:29:57.343 HennaTreeTable: Loaded 8134 Henna Tree Templates.
17:29:57.343 LevelUpData: Loaded 103 Character Level Up Templates.
17:29:57.531 Geo Engine: - Loading Geodata...
Exception in thread "main" java.lang.OutOfMemoryError: Java heap space
at l2p.gameserver.geodata.GeoEngine.LoadGeodataFile(G eoEngine.java:1578)

Свернуть ↑Развернуть ↓

При загрузке геодаты:

Свернуть ↑ 17:29:57.531 Geo Engine: - Loading Geodata...
Exception in thread "main" java.lang.OutOfMemoryError: Java heap space
at l2p.gameserver.geodata.GeoEngine.LoadGeodataFile(G eoEngine.java:1578)

at l2p.gameserver.geodata.GeoEngine.loadGeo(GeoEngine .java:1422)
at l2p.gameserver.GameServer.<init>(GameServer.java:2 16)
at l2p.gameserver.GameServer.main(GameServer.java:514 )

Свернуть ↑Развернуть ↓

Кто может помочь вот ссылка на сайт с сервером L2Phoenix rev 20736+geodata

[MasVild]

Мозгов не хватает для гео... Отключи http://forum.zone-game.info/showthre...EE%E4%E0%F2%FB

[Сергей_98]

Сообщение от MasVild

Мозгов не хватает для гео... Отключи http://forum.zone-game.info/showthre...EE%E4%E0%F2%FB

У меня исходников нету...

[MasVild]

Сообщение от Сергей_98

У меня исходников нету...

Ну тогда извините Исходы были на форуме или на других порталах