need help updating database

[litttleman10]

my arcemu database is 3.2.2 and i would like to update it to 3.3.3.

the problem is that the db structures are different. I want to update without losing all my needed stuff.

thanks and if you need more info just ask

[Aellya]

Make a backup of the db first(if you're worried about losing data), then check in the world_db -> db_version, find revision.
Go to arcemu server source folder -> sql directory -> worldupdates -> apply updates squentially(last word being the keyword here) by rightclicking your world_db name, hitting execute batchfile and choosing the correct path.


Good luck!

[litttleman10]

world_db -> db_version, find revision.

sry for the noob question but could you give me directions of how to do that...like is that somewere in hedisql?

[Aellya]

I use navicat myself so cant help you with that(but any sql editor will do), but you should have a database named world_db, within it there'll be a table named db_version, in that table is a field named "latest_update". It'll show the latest one thats been run, then run all the batches released after it, but in the right order

[litttleman10]

i dont have the table db_version but in my world.conf i have this at the top

#######################################################################
# ArcEmu Configuration File
# Last Update: $Id: arcemu-world.conf rev.2208
#######################################################################

logon.conf

#######################################################################
# ArcEmu Realms Configuration File
# Last updated at rev.1875
#######################################################################

optional.conf

###########################################################################
# ArcEmu Optional Configuration File
# Last Update: $Id: arcemu-optional.conf rev.2718
#
# This configuration file contains all non-blizzlike values.
###########################################################################

idk if that helps...im asking the person that i got the db from what is