How to upgrade my current server and db without losing data?

[Markelly]

Hello,i'm not sure if this is the right place to post this.

I'm upgrading my wow server to 3.3.3a and i want to keep my custom items,could you tell me how to upgrade server core and db without losing the data ?

Thanks.

[darkstalker]

apply updates?

[Markelly]

upgrade it from 3.2.2a to 3.3.3a,i tested with another server i made for testing and the custom items i added got deleted when upgraded the db

my current opinion is to extract every custom item to an sql file but it will take long so im asking you guys for help

[Patman128]

That's impossible. If you just apply the mangos updates, either all your items would be deleted, or none of them, because items aren't included with mangos.

[Markelly]

Okay guys,thanks for the help.

[Unkle Nuke]

It's unavoidable that you must maintain any additions you make to the database. This means making proper backups of such data and importing them back into your database.

One thing to bear in mind is client versions after 3.2.2a no longer support custom items in the same way. The DBC data is now hard-linked, which means you must use existing item IDs. You can no longer make your own IDs. Your custom items must be added through unused items in the DBC that are of the same type, i.e.: custom dagger must use a dagger type weapon.

[Markelly]

So if i got this right for custom items i must use IDs of existing items,like items from closed instances lime MC so players can use normal gear and wont get the custom one while leveling up.

Thank you for the great help