How do i backup these needed things with navicat and re put them back on after update

[BillyBob31]

How do i save the need files or w/e say to save everyones account info ..... the custom items , custom npc's so that important stuff dosnt get lost, and then update my private servers database, and how to i re put them on?? plz can someone help me detailed ??

[Maikash2]

With the NCDB tool in the NCDB SVN, you can easily backup and restore accounts and players.. here's the whole thing, obviously edit the settings at the top. The original credits go to M4ksiu. This is ofc, assuming you use Ascent, if you don't, just post back.

@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=CHANGEME
set pass=CHANGEME
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=ncdb
set cdb=char
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(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_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
%mysqlpath%mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%tables_worldcreature_timed_emotes.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
: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%updatesChangeset_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%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

[BillyBob31]

how do i know it backed it up for sure ... and will this save all their old info ... lvl .... and items on their characters ??

[Le Froid]

Right click on DB, then click "dump sql file"

[BillyBob31]

Right click on DB, then click "dump sql file"

ok yeah in localhost in navicat i have ascent and ascentlogon so i right click ascent logon and dumb sql .... but how do i put it back on ... i try execute batch file and it fails says unsuccesful

[latruwski]

ok yeah in localhost in navicat i have ascent and ascentlogon so i right click ascent logon and dumb sql .... but how do i put it back on ... i try execute batch file and it fails says unsuccesful

if you dumped it to a sql file and get error when trying to execute post the error here... full one...

grtz