Updating

From ArcEmu-Wiki
(Difference between revisions)
Jump to: navigation, search
(Updating the updating page.)
 
 
(5 intermediate revisions by 2 users not shown)
Line 1: Line 1:
{{TocRight}}
+
{{LanguageLinks|Updating|EN}}
  
== Updating ==
+
__TOC__
  
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:
+
= 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
  
  REMEMBER TO APPLY THE REQUIRED UPDATES!
+
  git pull
REMEMBER TO APPLY THE REQUIRED UPDATES!
+
REMEMBER TO APPLY THE REQUIRED UPDATES!
+
REMEMBER TO APPLY THE REQUIRED UPDATES!
+
REMEMBER TO APPLY THE REQUIRED UPDATES!
+
  
 +
* [[CMake|Run CMake]]
 +
* Compile normally, f.ex. for [[Compiling:_Windows|Windows]]
  
== Updating your binaries ==
+
{{Note|Beside the binaries pay attention if may the databases has changed too. So you may also have to follow carefully the next step.}}
  
*Compile normally
+
= Updating your SQL databases =
**Move server executable to Server Directory
+
***Copy Link Libraries from the script_bin the build directory to the server directory.
+
Overwrite both executables and Libraries previously in the script_bin.
+
  
 +
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.
  
== Updating your database ==
+
Usually when a database update is needed, it comes as a SQL dump file ready for you.
  
Usually when a database update is needed, it comes prepackaged and 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.
  
Get your current server revision out. Identify which patch you require to run on your database through increases in this patch number.
+
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.
 
+
<BIG>'''THIS WILL ASSUME THAT, IN THIS SITUATION PETS HAVE BEEN UPDATED'''</BIG>
+
 
+
*Migrate to '''"trunk\sql"'''
+
**Identify where the problem is, E.x. if the pet system was changed its a good chance the character database was changed
+
*** Open '''"trunk\sql\character_updates\4000 - pets.sql"''' with a program such as NaviCat
+
**** Execute the query on your database.
+
 
+
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.
+

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