Question about Upgrading Emu build from old version to new version

[ChaosSlayer]

Hello!
First of all let me say that I was away from Emu since May and I am simply AMAZED how much work was done for the project since then!!
I read the logs and you guys fixed and added tons and tons of features!
I am realy pleased to see that Emu is alive and kicking =)

Now on my question.
Basicly my Emu build is from May 07, and I like to put on the latest build. However I am concerned if all the changes you made will be compateable with my custom DB (I added/chaged items, npc etc)

I belive atleast once i saw in the log that a new table has to be added to DB.
But I never before uprgaded from one build to another so little uncertain to proper way to do it.
Could you please post some basic sugestions?

[ChaosSlayer]

anyone? =(

[rojadruid]

what is the build number of your binaries? are you using 7.0?

If using 7.0 you should be able to just paste the lastest build over the old one and then run all the sql thats in the changelog.txt from oldest to newest build. Start with anything after your build and move to current date.

[ChaosSlayer]

thank you for answering!

I am not sure what is 7.0
But my client is Titanium and my emulator build is 0.7.7-992
basicly I need understand if I am missing naything:

1. insert SQl values into Db as mentioned in changelog
2. download and copy over new build

anything else?

basicly by greatest worry if my custom DB is in jepordy from this uprgade =)

thanks again!

[rojadruid]

Originally Posted by ChaosSlayer

thank you for answering!

I am not sure what is 7.0
But my client is Titanium and my emulator build is 0.7.7-992
basicly I need understand if I am missing naything:

1. insert SQl values into Db as mentioned in changelog
2. download and copy over new build

anything else?

basicly by greatest worry if my custom DB is in jepordy from this uprgade =)

thanks again!

always always back up your database before the changes. and you will be good.

[koldar]

There have also been some changes to water mapping. You can find the new water maps at Angelox's site. With the current build (1074) and with a few rule additions listed under the development forum, you will be able to have all of the features listed under the 1074 log. Definitely back up though. I would also backup your eqemu directory just to be safe.

[Scorpious2k]

In theory, you can go back in the change log to the point when your DB was up-to-date and run all the sql changes in the log after that (in reverse order - moving up through the log) until you get to the top. That *should* get you current.

Having said that, we just did it for the Scorpious2k Server and sadly, not everything is in the change log. We also got a copy of the PEQ DB and compared to see what we were missing in tables and columns in existing tables.

Of course, we were converting from version 5.7 DR 6 (a much older version than yours) and even so we did succeed in spite of a few glitches along the way.

[narcberry]

Seems like there is an easier way. Couldn't you dump a desc of all the latest tables and apply a merge somehow? If so that would eliminate:

Problems with missing sql statements
Ever having to parse through the changelog to update your months-old version.


I'm sure it's possible, and I'm nearly certain it could be done safely.

[ChaosSlayer]

few more things on the subject.

I have downloaded lastest cavedude PEQ DB (with LOY) - basicly its a large file with sql statements....

next question is.. What do i do with it? =)
basicly how do I install it?

I know how to run single sql statements... but defently not 82mb file
Is there a comand to order this entire file to load (or better create new DB?)

thanks!

[ChaosSlayer]

NM that - i got it... =)