MMOwned - World of Warcraft Exploits, Hacks, Bots and Guides  
Homepage Register FAQ Members Mark Forums Read Advertise Marketplace FPSowned


Go Back   MMOwned - World of Warcraft Exploits, Hacks, Bots and Guides > WoW Emulator Server > Emulator Server Discussion
Reload this Page How do i backup these needed things with navicat and re put them back on after update
Emulator Server Discussion World of Warcraft Emulator Server general chat .
[NO Questions here]

Reply
 
LinkBack Thread Tools
How do i backup these needed things with navicat and re put them back on after update
(#1)
Old
BillyBob31 is Offline
Knight-Lieutenant
Rep Power: 1
Reputation: 24
BillyBob31 is on a distinguished road
  
Posts: 231
Join Date: Feb 2008
How do i backup these needed things with navicat and re put them back on after update - 03-01-2008
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 ??
Reply With Quote

Donate to remove ads.
(#2)
Old
Maikash2's Avatar
Maikash2 is Offline
Site n00b.. (A leecher if I've been here for more than a month and can't earn 5 rep)
Rep Power: 2
Reputation: 1
Maikash2 is an unknown quantity at this point
  
Posts: 22
Join Date: May 2007
03-01-2008
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.
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=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
Reply With Quote
(#3)
Old
BillyBob31 is Offline
Knight-Lieutenant
Rep Power: 1
Reputation: 24
BillyBob31 is on a distinguished road
  
Posts: 231
Join Date: Feb 2008
03-01-2008
how do i know it backed it up for sure ... and will this save all their old info ... lvl .... and items on their characters ??
Reply With Quote
(#4)
Old
Le Froid's Avatar
Le Froid is Offline
Contributor
Rep Power: 3
Reputation: 154
Le Froid has a spectacular aura aboutLe Froid has a spectacular aura about
  
Posts: 1,242
Join Date: Mar 2007
Location: /b/
03-01-2008
Right click on DB, then click "dump sql file"

"I don't fail at stuff, I succeed at finding what doesn't work"
Reply With Quote
(#5)
Old
BillyBob31 is Offline
Knight-Lieutenant
Rep Power: 1
Reputation: 24
BillyBob31 is on a distinguished road
  
Posts: 231
Join Date: Feb 2008
03-01-2008
Quote:
Originally Posted by Le Froid View Post
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
Reply With Quote
(#6)
Old
latruwski's Avatar
latruwski is Offline
*Candy L33T*
Legendary User
Rep Power: 7
Reputation: 616
latruwski is a name known to alllatruwski is a name known to alllatruwski is a name known to alllatruwski is a name known to alllatruwski is a name known to alllatruwski is a name known to all
  
Posts: 2,283
Join Date: Dec 2006
Location: Langemark, Belgium
03-01-2008
Quote:
Originally Posted by BillyBob31 View Post
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

(\_/) Give to people who have been helpfull!
(O.o) This is Bunny. Copy Bunny into your signature
(> <) to help him on his way to world domination.
Quote:
Originally Posted by Dragon[Sky]
All I have to say is: You're all ungrateful fags.
If you don't like Ascent nor can wait, GTFO. Mangos welcomes you.

Reply With Quote
Reply

« Previous Thread | Next Thread »
Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are On



Powered by vBulletin® Version 3.7.4
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Search Engine Optimization by vBSEO 3.2.0
vBulletin Skin developed by: vBStyles.com
Contact Us - MMOwned - World of Warcraft Exploits, Hacks, Bots and Guides - Archive - Privacy Statement - Top

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 181 182 183 184 185 186 187 188 189 190 191 192 193 194 195 196 197 198 199 200 201 202 203 204 205 206 207 208 209 210 211 212 213 214 215 216 217 218 219 220 221 222 223 224 225 226 227 228 229 230 231 232 233 234 235 236 237 238 239 240 241 242 243 244 245 246 247 248 249 250 251 252 253 254 255 256 257 258 259 260 261 262 263 264 265 266 267 268 269 270 271 272 273 274 275 276 277 278 279 280 281 282 283 284 285 286 287 288 289 290 291 292 293 294 295 296 297 298 299 300 301 302 303 304 305 306 307 308 309 310 311 312 313 314 315 316 317 318 319 320 321 322 323 324 325 326 327 328 329 330 331 332 333 334 335 336 337 338 339 340 341 342 343 344 345 346 347 348 349 350 351 352 353 354 355 356 357 358 359 360 361