992 to 1002

[koldar]

Hello,
I have managed to CVS the latest DB and I have unpacked all of the new binaries to my eqemu directory however I am wondering how to upgrade my database to what I just CVSed without losing my existing character data. Can someone point me in the right direction?

Thank you!

[techguy84]

Just execute any addition SQL lines that are in the changelog into your database

[koldar]

I don't see any sql statements in the changelog for builds in between 992 and 1002. So that means there are no DB changes required? That's cool. Thank you for the pointer.

Now how about if I want to import the latest DB build or the latest ax db while retaining my character data? Would I just export the character_ table and then drop the db and recreate it?

[So_1337]

Yes. Each database table is separate, so just drop whichever table you want to update (say, for example, npc_types), and then go to File --> Load Script and find npc_types.sql. Through this method, you can choose which specific tables you want to use without losing any that you don't choose to replace.

[Zengez]

Also if it's the PEQ database they actually have the source stuff broken down so you can just mass update everything that isn't personalized character related data, i.e. npc types, grid spawns, etc, to get all the stuff you want without losing your character... i believe the file is called 'load systems.sql' or something similar, you obviously need to use the corresponding 'drop systems.sql' before you execute it... theres a systems one and another one, the systems one replaces all the non character related data...

This all assumes you are using PEQ updates of course.