Newbie Spellweaver
- Joined
- Aug 9, 2007
- Messages
- 56
- Reaction score
- 0
Could someone tell me if there is something wrong because i cant import the DB? i says mySQL things are wrong... : S
THX !
EDIT: I got it working i changed some things.
In this part should i have not counfigured to root cause it had CHANGME on it. : S
THX !
EDIT: I got it working i changed some things.
In this part should i have not counfigured to root cause it had CHANGME on it. : S
Code:
if %user% == root GOTO id10t
if %pass% == root GOTO id10t
Code:
@ECHO off
REM ################################################## ##########################
REM #
REM # B A S I C U S E R C O N F I G U R A T I O N A R E A
REM #
REM ################################################## ##########################
set user=root
set pass=root
REM wdb - is the World Database
REM cdb - is the Character Database
REM If you do not have them seperated then set them to the same values
set wdb=ascentworld
set cdb=ascentchar
REM ################################################## ##########################
REM #
REM # A D V A N C E D U S E R C O N F I G U R A T I O N A R E A
REM #
REM ################################################## ##########################
set port=3306
set server=localhost
set devpath=.\Development\Database
set pubpath=.\Releases
set mysqlpath=.\Development\Database\MYSQL
REM ################################################## ##########################
REM #
REM # D O N O T M O D I F Y B E Y O N D T H I S P O I N T
REM #
REM ################################################## ##########################
if %user% == root GOTO id10t
if %pass% == root GOTO id10t
:menu
cls
ECHO.
ECHO.
ECHO ####################################
ECHO ####### Next Chapter #######
ECHO ###### Database ######
ECHO ####### Import Tool #######
ECHO ####################################
ECHO.
ECHO Please type the letter for the option:
ECHO.
ECHO w = Install NCDB World Database(Wipe current db).
ECHO u = Update NCDB World Database(Update current db)
ECHO.
ECHO b - Backup Characters/Acounts Data.
ECHO r - Restore Characters/Accounts Data.
ECHO.
ECHO d - Debug
ECHO x - Exit
ECHO.
set /p l= Enter Letter:
if %l%==* goto error
if %l%==w goto world
if %l%==W goto world
if %l%==u goto update
if %l%==U goto update
if %l%==b goto backup
if %l%==B goto backup
if %l%==r goto check2
if %l%==R goto check2
if %l%==d goto debug
if %l%==D goto debug
if %l%==x goto quit
if %l%==X goto quit
goto error
:check2
CLS
ECHO.
ECHO.
ECHO ! ! ! W A R N I N G ! ! !
ECHO.
ECHO.
ECHO This will DELETE all existing Character data
ECHO from the database!
ECHO.
ECHO Are you sure you want to:
ECHO Restore Character Database from a file?
ECHO.
ECHO y - Yes
ECHO n - No
ECHO.
set /p r= Enter Letter:
if %l%==* goto menu
if %r%==y goto restore
if %r%==Y goto restore
goto menu
:world
CLS
ECHO.
ECHO.
ECHO [Importing] Started...
ECHO [Importing] Creature/NPC tables
%mysqlpath%\mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%\tables_world\ai_agents.sql
%mysqlpath%\mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%\tables_world\ai_threattospellid.sql
%mysqlpath%\mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%\tables_world\creature_formations.sql
%mysqlpath%\mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%\tables_world\creature_names.sql
%mysqlpath%\mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%\tables_world\creature_proto.sql
%mysqlpath%\mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%\tables_world\petdefaultspells.sql
%mysqlpath%\mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%\tables_world\npc_gossip_textid.sql
%mysqlpath%\mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%\tables_world\npc_monstersay.sql
%mysqlpath%\mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%\tables_world\npc_text.sql
%mysqlpath%\mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%\tables_world\auctionhouse.sql
%mysqlpath%\mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%\tables_world\ItemPetFood.sql
%mysqlpath%\mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%\tables_world\Transport_creatures.sql
%mysqlpath%\mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%\tables_world\creature_timed_emotes.sql
ECHO [Importing] Loot tables
%mysqlpath%\mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%\tables_world\creatureloot.sql
%mysqlpath%\mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%\tables_world\fishingloot.sql
%mysqlpath%\mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%\tables_world\itemloot.sql
%mysqlpath%\mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%\tables_world\item_randomprop_groups.sql
%mysqlpath%\mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%\tables_world\item_randomsuffix_groups.sq l
%mysqlpath%\mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%\tables_world\objectloot.sql
%mysqlpath%\mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%\tables_world\prospectingloot.sql
%mysqlpath%\mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%\tables_world\pickpocketingloot.sql
%mysqlpath%\mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%\tables_world\skinningloot.sql
ECHO [Importing] Items tables
%mysqlpath%\mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%\tables_world\itempages.sql
%mysqlpath%\mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%\tables_world\items.sql
%mysqlpath%\mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%\tables_world\vendors.sql
ECHO [Importing] Quests tables
%mysqlpath%\mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%\tables_world\gameobject_quest_finisher.s ql
%mysqlpath%\mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%\tables_world\gameobject_quest_starter.sq l
%mysqlpath%\mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%\tables_world\creature_quest_finisher.sql
%mysqlpath%\mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%\tables_world\creature_quest_starter.sql
%mysqlpath%\mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%\tables_world\quests.sql
%mysqlpath%\mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%\tables_world\gameobject_quest_item_bindi ng.sql
%mysqlpath%\mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%\tables_world\gameobject_quest_pickup_bin ding.sql
ECHO [Importing] Reputation On Kill Tables
%mysqlpath%\mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%\tables_world\reputation_creature_onkill. sql
%mysqlpath%\mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%\tables_world\reputation_faction_onkill.s ql
%mysqlpath%\mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%\tables_world\reputation_instance_onkill. sql
ECHO [Importing] PlayerCreateInfo Tables
%mysqlpath%\mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%\tables_world\playercreateinfo.sql
%mysqlpath%\mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%\tables_world\playercreateinfo_bars.sql
%mysqlpath%\mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%\tables_world\playercreateinfo_items.sql
%mysqlpath%\mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%\tables_world\playercreateinfo_skills.sql
%mysqlpath%\mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%\tables_world\playercreateinfo_spells.sql
ECHO [Importing] Spawns Tables
%mysqlpath%\mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%\tables_world\creature_spawns.sql
%mysqlpath%\mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%\tables_world\creature_staticspawns.sql
%mysqlpath%\mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%\tables_world\creature_waypoints.sql
%mysqlpath%\mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%\tables_world\fishing.sql
%mysqlpath%\mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%\tables_world\gameobject_spawns.sql
%mysqlpath%\mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%\tables_world\gameobject_staticspawns.sql
ECHO [Importing] World Related Tables
%mysqlpath%\mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%\tables_world\banned_names.sql
%mysqlpath%\mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%\tables_world\banned_pharses.sql
%mysqlpath%\mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%\tables_world\weather.sql
%mysqlpath%\mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%\tables_world\worldmap_info.sql
%mysqlpath%\mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%\tables_world\zoneguards.sql
%mysqlpath%\mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%\tables_world\transport_data.sql
%mysqlpath%\mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%\tables_world\areatriggers.sql
%mysqlpath%\mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%\tables_world\recall.sql
%mysqlpath%\mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%\tables_world\graveyards.sql
ECHO [Importing] Trainer and Spells Related Tables
%mysqlpath%\mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%\tables_world\spellextra.sql
%mysqlpath%\mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%\tables_world\spelloverride.sql
%mysqlpath%\mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%\tables_world\spells112.sql
%mysqlpath%\mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%\tables_world\spell_disable.sql
%mysqlpath%\mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%\tables_world\spell_disable_trainers.sql
%mysqlpath%\mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%\tables_world\teleport_coords.sql
%mysqlpath%\mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%\tables_world\totemspells.sql
%mysqlpath%\mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%\tables_world\trainer_defs.sql
%mysqlpath%\mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%\tables_world\trainer_spells.sql
%mysqlpath%\mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%\tables_world\spell_proc_data.sql
ECHO [Importing] Gameobjects
%mysqlpath%\mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%\tables_world\gameobject_names.sql
ECHO [Importing] Localize Tables
%mysqlpath%\mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%\tables_world\creature_names_localized.sq l
%mysqlpath%\mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%\tables_world\gameobject_names_localized. sql
%mysqlpath%\mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%\tables_world\itempages_localized.sql
%mysqlpath%\mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%\tables_world\items_localized.sql
%mysqlpath%\mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%\tables_world\npc_text_localized.sql
%mysqlpath%\mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%\tables_world\quests_localized.sql
ECHO [Importing] Client Addons
%mysqlpath%\mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%\tables_world\clientaddons.sql
ECHO [Importing] Command System
%mysqlpath%\mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%\tables_world\command_overrides.sql
ECHO [Importing] Map Checkpoint
%mysqlpath%\mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%\tables_world\map_checkpoint.sql
ECHO [Importing] Name filters
%mysqlpath%\mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%\tables_world\wordfilter_character_names. sql
ECHO [Importing] Chat Filters
%mysqlpath%\mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%\tables_world\wordfilter_chat.sql
ECHO [Importing] Finished
ECHO.
PAUSE
GOTO menu
:update
CLS
ECHO.
ECHO.
ECHO [Importing] Started Updateing database with Changeset_103x.sql
%mysqlpath%\mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%\updates\Changeset_103x.sql
ECHO [Importing] Finished
ECHO.
PAUSE
GOTO menu
:backup
CLS
ECHO.
ECHO.
ECHO [Backing Up] Started...
ECHO [Backing Up] User Accounts and Characters...
%mysqlpath%\mysqldump -h %server% --user=%user% --password=%pass% --port=%port% %cdb% account_overrides accounts arenateams auctions banned_phrases banned_names characters charters corpses gm_tickets guilds guild_ranks instances ipbans mailbox playeritems playerpets playerpetspells playersummonspells questlog playercooldownitems playercooldownsecurity social tutorials > %pubpath%\Backups\characters_backup.sql
ECHO [Backing Up] Finished
ECHO.
PAUSE
GOTO menu
:restore
CLS
ECHO.
ECHO.
ECHO [Restoring] Started...
ECHO [Restoring] User Accounts and Characters...
%mysqlpath%\mysql -h %server% --user=%user% --password=%pass% --port=%port% %cdb% < %pubpath%\Backups\characters_backup.sql
ECHO [Restoring] Finished
ECHO.
PAUSE
GOTO menu
:debug
cls
ECHO.
ECHO.
ECHO ####################################
ECHO ###### Next Chapter ######
ECHO ##### Database #####
ECHO ###### Debug Tool ######
ECHO ####################################
ECHO.
ECHO User = %user%
ECHO Password = %pass%
ECHO World DB = %wdb%
ECHO Char DB = %cdb%
ECHO Port = %port%
ECHO Server = %server%
ECHO Development Directory Path = %devpath%
ECHO Releases Directory Path = %pubpath%
ECHO MySQL Bin Path = %mysqlpath%
ECHO.
PAUSE
GOTO menu
:error
CLS
ECHO.
ECHO.
ECHO [ERROR] An error has occured, you will be directed back to the
ECHO [ERROR] main menu.
PAUSE
GOTO menu
:id10t
CLS
ECHO.
ECHO.
ECHO [FAILURE] You did not change the proper directives in this file.
ECHO [FAILURE] Please edit this script and fill in the proper MYSQL Information.
ECHO [FAILURE] When the information is correct: Please Try Again.
PAUSE
GOTO quit
:quit
Last edited:
