Use tool.bat:
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=password
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=ncdbclean
set cdb=ncdb
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=.DevelopmentDatabase
set pubpath=.Releases
set mysqlpath=.DevelopmentDatabaseMYSQL
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% == CHANGEME GOTO id10t
if %pass% == CHANGEME 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.
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%==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_worldai_agents.sql
%mysqlpath%mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%tables_worldai_threattospellid.sql
%mysqlpath%mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%tables_worldcreature_formations.sql
%mysqlpath%mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%tables_worldcreature_names.sql
%mysqlpath%mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%tables_worldcreature_proto.sql
%mysqlpath%mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%tables_worldpetdefaultspells.sql
%mysqlpath%mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%tables_worldnpc_gossip_textid.sql
%mysqlpath%mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%tables_worldnpc_monstersay.sql
%mysqlpath%mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%tables_worldnpc_text.sql
%mysqlpath%mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%tables_worldauctionhouse.sql
%mysqlpath%mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%tables_worldItemPetFood.sql
%mysqlpath%mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%tables_worldTransport_creatures.sql
ECHO [Importing] Loot tables
%mysqlpath%mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%tables_worldcreatureloot.sql
%mysqlpath%mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%tables_worldfishingloot.sql
%mysqlpath%mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%tables_worlditemloot.sql
%mysqlpath%mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%tables_worlditem_randomprop_groups.sql
%mysqlpath%mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%tables_worlditem_randomsuffix_groups.sql
%mysqlpath%mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%tables_worldobjectloot.sql
%mysqlpath%mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%tables_worldprospectingloot.sql
%mysqlpath%mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%tables_worldpickpocketingloot.sql
%mysqlpath%mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%tables_worldskinningloot.sql
ECHO [Importing] Items tables
%mysqlpath%mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%tables_worlditempages.sql
%mysqlpath%mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%tables_worlditems.sql
%mysqlpath%mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%tables_worldvendors.sql
ECHO [Importing] Quests tables
%mysqlpath%mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%tables_worldgameobject_quest_finisher.sql
%mysqlpath%mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%tables_worldgameobject_quest_starter.sql
%mysqlpath%mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%tables_worldcreature_quest_finisher.sql
%mysqlpath%mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%tables_worldcreature_quest_starter.sql
%mysqlpath%mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%tables_worldquests.sql
%mysqlpath%mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%tables_worldgameobject_quest_item_binding.sql
%mysqlpath%mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%tables_worldgameobject_quest_pickup_binding.sql
ECHO [Importing] Reputation On Kill Tables
%mysqlpath%mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%tables_worldreputation_creature_onkill.sql
%mysqlpath%mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%tables_worldreputation_faction_onkill.sql
%mysqlpath%mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%tables_worldreputation_instance_onkill.sql
ECHO [Importing] PlayerCreateInfo Tables
%mysqlpath%mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%tables_worldplayercreateinfo.sql
%mysqlpath%mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%tables_worldplayercreateinfo_bars.sql
%mysqlpath%mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%tables_worldplayercreateinfo_items.sql
%mysqlpath%mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%tables_worldplayercreateinfo_skills.sql
%mysqlpath%mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%tables_worldplayercreateinfo_spells.sql
ECHO [Importing] Spawns Tables
%mysqlpath%mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%tables_worldcreature_spawns.sql
%mysqlpath%mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%tables_worldcreature_staticspawns.sql
%mysqlpath%mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%tables_worldcreature_waypoints.sql
%mysqlpath%mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%tables_worldfishing.sql
%mysqlpath%mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%tables_worldgameobject_spawns.sql
%mysqlpath%mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%tables_worldgameobject_staticspawns.sql
ECHO [Importing] World Related Tables
%mysqlpath%mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%tables_worldbanned_names.sql
%mysqlpath%mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%tables_worldbanned_pharses.sql
%mysqlpath%mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%tables_worldweather.sql
%mysqlpath%mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%tables_worldworldmap_info.sql
%mysqlpath%mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%tables_worldzoneguards.sql
%mysqlpath%mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%tables_worldtransport_data.sql
%mysqlpath%mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%tables_worldareatriggers.sql
%mysqlpath%mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%tables_worldrecall.sql
%mysqlpath%mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%tables_worldgraveyards.sql
ECHO [Importing] Trainer and Spells Related Tables
%mysqlpath%mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%tables_worldspellextra.sql
%mysqlpath%mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%tables_worldspelloverride.sql
%mysqlpath%mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%tables_worldspells112.sql
%mysqlpath%mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%tables_worldspell_disable.sql
%mysqlpath%mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%tables_worldspell_disable_trainers.sql
%mysqlpath%mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%tables_worldteleport_coords.sql
%mysqlpath%mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%tables_worldtotemspells.sql
%mysqlpath%mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%tables_worldtrainer_defs.sql
%mysqlpath%mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%tables_worldtrainer_spells.sql
%mysqlpath%mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%tables_worldspell_proc_data.sql
ECHO [Importing] Gameobjects
%mysqlpath%mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%tables_worldgameobject_names.sql
ECHO [Importing] Localize Tables
%mysqlpath%mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%tables_worldcreature_names_localized.sql
%mysqlpath%mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%tables_worldgameobject_names_localized.sql
%mysqlpath%mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%tables_worlditempages_localized.sql
%mysqlpath%mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%tables_worlditems_localized.sql
%mysqlpath%mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%tables_worldnpc_text_localized.sql
%mysqlpath%mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%tables_worldquests_localized.sql
ECHO [Importing] Client Addons
%mysqlpath%mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%tables_worldclientaddons.sql
ECHO [Importing] Command System
%mysqlpath%mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%tables_worldcommand_overrides.sql
ECHO [Importing] Map Checkpoint
%mysqlpath%mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%tables_worldmap_checkpoint.sql
ECHO [Importing] Name filters
%mysqlpath%mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%tables_worldwordfilter_character_names.sql
ECHO [Importing] Chat Filters
%mysqlpath%mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%tables_worldwordfilter_chat.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%Backupscharacters_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%Backupscharacters_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
Only modify tool.bat, not tool.sh - tool.sh should not be modified!!!