- 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
[2] Open the tree to realmd_bc
Then you will get a window that looks like this.
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
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]
[2] Then right click on Realmd_bc and select restore from SQL Dump
[3] And select the appropriate SQL file that you exported.
Click on execute and you should have all you data back. To check, refresh that database
Continue to do the same for all the exported files, character in mangos_bc and realmcharacters in realmd_bc. It's that simple.
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 SKi - [Guide] Export your data Beta - RaGEZONE Forums](http://i108.photobucket.com/albums/n38/Muchalipski/Mysqlshit.jpg)
[2] Open the tree to realmd_bc
![SKi - [Guide] Export your data Beta - RaGEZONE Forums SKi - [Guide] Export your data Beta - RaGEZONE Forums](http://i108.photobucket.com/albums/n38/Muchalipski/EXportSQL1.jpg)
Then you will get a window that looks like this.
![SKi - [Guide] Export your data Beta - RaGEZONE Forums SKi - [Guide] Export your data Beta - RaGEZONE Forums](http://i108.photobucket.com/albums/n38/Muchalipski/ExportSQL2.jpg)
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 SKi - [Guide] Export your data Beta - RaGEZONE Forums](http://i108.photobucket.com/albums/n38/Muchalipski/EportSQL3.jpg)
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 SKi - [Guide] Export your data Beta - RaGEZONE Forums](http://i108.photobucket.com/albums/n38/Muchalipski/Drop.jpg)
[2] Then right click on Realmd_bc and select restore from SQL Dump
![SKi - [Guide] Export your data Beta - RaGEZONE Forums SKi - [Guide] Export your data Beta - RaGEZONE Forums](http://i108.photobucket.com/albums/n38/Muchalipski/Restor.jpg)
[3] And select the appropriate SQL file that you exported.
![SKi - [Guide] Export your data Beta - RaGEZONE Forums SKi - [Guide] Export your data Beta - RaGEZONE Forums](http://i108.photobucket.com/albums/n38/Muchalipski/Final.jpg)
Click on execute and you should have all you data back. To check, refresh that database
![SKi - [Guide] Export your data Beta - RaGEZONE Forums SKi - [Guide] Export your data Beta - RaGEZONE Forums](http://i108.photobucket.com/albums/n38/Muchalipski/refresh.jpg)
Continue to do the same for all the exported files, character in mangos_bc and realmcharacters in realmd_bc. It's that simple.