[Guide] Export your data Beta

SKi

Newbie Spellweaver
Joined
Feb 15, 2007
Messages
60
Reaction score
0
For some of you who wish to keep your characters when you update the server here is a guide to do so.
WARNING! This has been tested only from Mangos 2.0.6 to Mangos 2.0.8.
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
EXPORTING CHARACTERS
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
[1]Open SQLyog
SKi - [Guide] Export your data Beta - RaGEZONE Forums


[2] Open the tree to realmd_bc
SKi - [Guide] Export your data Beta - RaGEZONE Forums


Then you will get a window that looks like this.
SKi - [Guide] Export your data Beta - RaGEZONE Forums


Make sure It looks the same! Save to File though, can be what ever you want to call the SQL file. You'll need to remember it because after you update to the newer version you'll have in import it. Do this for realmcharacter table, but name it something like MyRealmCharacters.sql in Save to File.

[3] Now Open mangos_bc
SKi - [Guide] Export your data Beta - RaGEZONE Forums


Do the same as the end of step [2], just save the file as MyCharacters.sql

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
DROPPING AND IMPORTING
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
If you have a whole new sql database you wish to use you need to drop the current
database. I'm not going to go over that right now. But now with v2.0.8 installed you
open up the files like shown above.

[1]
SKi - [Guide] Export your data Beta - RaGEZONE Forums


[2] Then right click on Realmd_bc and select restore from SQL Dump
SKi - [Guide] Export your data Beta - RaGEZONE Forums


[3] And select the appropriate SQL file that you exported.
SKi - [Guide] Export your data Beta - RaGEZONE Forums


Click on execute and you should have all you data back. To check, refresh that database
SKi - [Guide] Export your data Beta - RaGEZONE Forums

Continue to do the same for all the exported files, character in mangos_bc and realmcharacters in realmd_bc. It's that simple.
 
Thank you!
Finally something useful on this forum.
 
Back