Mangos ( How to update ? )

[Najjstroem]

How do i update to a newer rev " WITHOUT " loosing important data as characters, characters items and that? And what new rev do you suggest me to use? :afro2:

[MentaL]

[FxMaster]

i'l like to know the very same question not realy mastered mysql yet and the functions

[Dristol]

Manually export the accounts and characters or use Mangos DB Handler to do it for you. Then once you've got your new core and db, import the account data.

----------

All necessary SQL-Updates can be found in the mangos/sql/updates folder. You will need them to run MaNGOS properly.

The DB structure is often changed so you need those .sql files to run MaNGOS.
Basicly you can say if you want to run e.g. revision 2650 you have to apply all updates till 2650. The revision number is showed in the sql filename for revision 2650 you will need the updates 2650_xxx.sql. Execute them with Navicat or Sqlyog.

--------

How to backup your db

At first you have to get a programm like Navicat. Downloading the trial version will do it. Then connect to your DB as you know it and right klick on the name of the database. Now select "dump to sql file"(or equal) and save this file in any directory.

If you dont want to backup the whole database but just the characters and accounts you have to backup following tables:
character_xxx
item_instance
guild_xxx
auctionhouse

Databases can be archived to aproximatly 8 megabytes a file which is very handy