updating Server Files.

[GaG]

ok this maybe a stupid question but do i have to totaly reinstall everything when a new version comes out or can i just unzip it in to my directory?

[tallerin]

just unzip it into your folder and add the changes if any to your Database from the changelog so the DB stays compatible.

only time you would have to do a reinstall is if you were to go from say 6.0 to 7.0 then you would have to install titanium so your client would be compatible.

[Zorlofe]

I think Gag is having the same problem I am on knowing how to update the db as in what exact commands if this is done in a command prompt etc. I'm looking for the exact steps as I'm a complete newb with the (my)SQL enviroment to update the DB. I was asking basically the same question here http://www.eqemulator.net/forums/showthread.php?goto=newpost&t=21075

[Zard]

This thread should help you with the commands to open up the promt.

http://www.eqemulator.net/forums/showthread.php?t=20768

Enter in all the entries from the changelog you are updating to.

http://www.eqemulator.net/download.php

[Thristam]

This is how i make my updates:

Firstly i download the new eqemu precompiled source and unzip it to a folder.

Read the change log and see if anything new has changed on the DB.

If somthing has changed I open my client utility from mysql.com called control center. Or you can use the query browser if your feeling brave =)

OR you can goto a command prompt. in the command prompt goto your sql\bin directory

Type in mysql -u (your username) -p (the database) and hit enter
type in your password

Copy the database changes out of the change log and paste them onto the prompt. Make sure you get the semi colon at the end. hit enter. make sure they suceed. When your done close out the window.

After that i remove the default config .xml file from the new eqemu source folder so i dont have to make my .xml config over again.

copy the new files into your eqemu dir.

[CrabClaw]

Same as Thristam, but I always keep a *.rar or *.zip of the last working Emu by zipping up the entire EQEmu diretory (minus the maps to save space) before making any changes. I also back up the database too using the MySQL Admin tool.

You can get it here (http://www.mysql.com/products/tools/administrator/), only if you are using MySQL 5.x.

:-)

[Zorlofe]

Awesome, thanks for the help guys! This is a great community!

[Zorlofe]

Unfortunately I'm still having the same "Zone Unavailable" message as before even after updating but as busy as I am these days I'll probably just wait for the next server pack from cavedude.

[Zard]

All I could suggest is to make sure that you are using the correct database when you are entering the SQL commands.

I used to use cavedudes database and when I switched to peq I made this mistake.
cavedudes = "use eq"
Peq = "use peq"

"Zone not available" is a red flag for not getting any or all of the SQL commands entered from my searching the forums, especially when updating.

[Aramid]

"Zone not available" is a red flag for not getting any or all of the SQL commands entered from my searching the forums, especially when updating.

Exactly. I missed just ONE entry because it looked like it was there, but I misread it and I got the same thing with the zones not available.

[Zorlofe]

I didn't realize that. I'll retry to make sure. Thanks.


**EDIT**
Went back over everything and found I missed some entries on some earlier logs for fixes <sigh>. Finally got it working and now my wife is happy again, lol. Thanks for saving my butt guys!

[Zard]

Yay! Happy wife = A good thing!

[Zorlofe]

Heheee, let meh tell yah!