HOW TO UPDATE YOUR MANGOS AND SAVE YOUR ACCOUNTS
Download latest Revision (for exemple :
MaNGOS Rev2358 &
ScritpDev rev127 HERE or
HERE)
Download Full DB (for exemple :
Full DB rev 216 HERE)
Download lastest patch for DB (for exemple :
Patch DB 0.4.25 rev 218 HERE)
(OPTIONAL)
Backup your Existing User Accounts :
1 - Save/Backup the realmd database ...
2 - Save/Backup the tables which concern the players ...
|
| Quote: |
- auctionhouse_item
- auctionhouse
- character
- character_action
- character_aura
- character_homebind
- character_kill
- character_pet
- character_queststatus
- character_reputation
- character_social
- character_spell
- character_ticket
- character_tutorial
- guild
- guild_member
- guild_rank
- item_instance
|
Delete all old tables in mangos DB.
3 - Execute batch file on mangos DB - Full DB (exemple : rev216.sql)
4 - Execute batch file on mangos DB - Updates DB (exemple : patchs *.sql in folder rev218 and in folder "updates" in lastest revision)
5 - (OPTIONAL) Execute batch file on mangos DB - your backup : TablesOfPlayersbackup.sql (for recovery your characters/accounts/guilds)
(OPTIONAL)
6 - (OPTIONAL) Execute batch file on realmd DB - your backup : realmdbackup.sql (for recovery your characters/accounts/realmdID)
Enjoy !!
IMPORTANT : will know that it is preferable to update the dB without preserving old accounts/characters indeed..., sometimes the tables of the characters contain errors which they reflect on the whole of new dB at the time of the reintegration of that after update & backup. ... for your pleasures and mine ...