How to update my server!!! pls help

[marcosgue]

hello everybody, first sorry for my english...

i have a simple question, i have a server run in version rev30 and now i want update this to version rev45, but i dont know how update the SQL database, i want update the database but i not want lose my accounts and character...

pls help me
and again sorry for my english

 

[MuDarkSky]

Hi... first go to navicat and make a backup of your account, character, item and storage (make backup to .sql extension), save this and delete roseon database!

After this you can restore the database rev45 and open query, make a new file and load yours .sql archives!

=X
It's easy!

 

[marcosgue]

thanks... but i have a last question, item in rev 45 not have updates in reference to rev 30????

i hope you understand my question.

 

[Sasuke210]

What you mean by reference? Item ID? they are listed in STB and not in sql i think

 

[marcosgue]

im sorry im not speak english... i try to say that, the item table in SQL of rev 45 not is more new at the item table in SQL of rev 30.

i hope you understand now

 

[Sasuke210]

Oh you mean structure, well you can edit table if there is new things

 

[marcosgue]

i make a back up of chars items and accounts tables, i replace that tables on new sql of rev45 and then i open the game enter with my character and when i click start give me a error discconect server...

i thik that error is for the table characters in rev 45 have colum town id and in the rev 30 table dont have towin id colum