Updating

From ArcEmu-Wiki
(Difference between revisions)
Jump to: navigation, search
 
(One intermediate revision by one user not shown)
Line 1: Line 1:
 
{{LanguageLinks|Updating|EN}}
 
{{LanguageLinks|Updating|EN}}
  
{{NeedUpdate}}
+
__TOC__
{{TocRight}}
+
 
+
= Updating =
+
 
+
Updating your database will be (almost) painless. You will usually be able to tell that you need to apply a sql update when you update your server's binaries by them causing errors, crashing, or otherwise bad behavior. '''Its a good idea to check the SVN log''' especially if Dfighter is spamming the log messages with:
+
 
+
REMEMBER TO APPLY THE REQUIRED UPDATES!
+
REMEMBER TO APPLY THE REQUIRED UPDATES!
+
REMEMBER TO APPLY THE REQUIRED UPDATES!
+
 
+
  
 
= Updating your binaries =
 
= Updating your binaries =
Line 25: Line 15:
 
{{Note|Beside the binaries pay attention if may the databases has changed too. So you may also have to follow carefully the next step.}}
 
{{Note|Beside the binaries pay attention if may the databases has changed too. So you may also have to follow carefully the next step.}}
  
= Updating your database =
+
= Updating your SQL databases =
 
+
Usually when a database update is needed, it comes prepackaged and ready for you.
+
  
Get your current server revision out. Identify which patch you require to run on your database through increases in this patch number.
+
Updating your database will be (almost) painless. You will usually be able to tell that you need to apply a SQL update when you update your server's binaries. It's a good idea to check the Git log for more information.
  
<BIG>'''THIS WILL ASSUME THAT, IN THIS SITUATION PETS HAVE BEEN UPDATED'''</BIG>
+
Usually when a database update is needed, it comes as a SQL dump file ready for you.
  
*Migrate to '''"trunk\sql"'''
+
Do these steps carefully and exactly:
**Identify where the problem is, E.x. if the pet system was changed its a good chance the character database was changed
+
* Open with a mySQL Client your world database.
*** Open '''"trunk\sql\character_updates\4000 - pets.sql"''' with a program such as NaviCat
+
* Open the table '''world_db_version'''. You will find there something like that: yyyy-mm-dd_hh-mm_textmessage (f.ex. 2012-02-09_00-55_earth_shield)
**** Execute the query on your database.
+
* This mean that you world db is up to date till f.ex 9. Feb. 2012
 +
* Now go to your ArcEmu source and have a look into the sql/world_updates folder.
 +
* Apply all SQL dump files to your world database that are '''NEWER''' than the above date '''IN ORDER''' of date of the patch.
  
Note: when updating to new revisions you may require multiple updates. It usually isn't a bad idea to backup your database before running any updates '''in case''' your pets database gets deleted or flushed to make way for change.
+
Im some rare cases may also the logon and the character database needs some updates. Check it regularly and repeat above steps in the same manner.

Latest revision as of 12:28, 25 February 2012

+/-
Main Page                   Other languages:   English  •   German   •   FrenchArcEmu Website     ArcEmu Forum     Bug Tracker


Contents


Updating your binaries

Repeate these steps as you have already done it with your first installation:

  • Run the following in your local Arcemu GIT copy
git pull
Ico info.png Beside the binaries pay attention if may the databases has changed too. So you may also have to follow carefully the next step.


Updating your SQL databases

Updating your database will be (almost) painless. You will usually be able to tell that you need to apply a SQL update when you update your server's binaries. It's a good idea to check the Git log for more information.

Usually when a database update is needed, it comes as a SQL dump file ready for you.

Do these steps carefully and exactly:

  • Open with a mySQL Client your world database.
  • Open the table world_db_version. You will find there something like that: yyyy-mm-dd_hh-mm_textmessage (f.ex. 2012-02-09_00-55_earth_shield)
  • This mean that you world db is up to date till f.ex 9. Feb. 2012
  • Now go to your ArcEmu source and have a look into the sql/world_updates folder.
  • Apply all SQL dump files to your world database that are NEWER than the above date IN ORDER of date of the patch.

Im some rare cases may also the logon and the character database needs some updates. Check it regularly and repeat above steps in the same manner.

Personal tools