View Single Post
  #2  
Old 06-01-2009, 10:06 AM
gaeorn
Developer
 
Join Date: Apr 2009
Location: USA
Posts: 478
Default

You need to run drop_system.sql. If you have bots, be sure to save them first using the script/batchfile. Then source the peqdb_1129RevXXX.sql. After that is done, then you need to source any updates in ./updates/RevXXX.sql between the rev you were and the rev you will now be. Also, source the sql for the bots at this point if needed.

The reason for needing to do both is the first part (drop_system.sql and peqdb_1129RevXXX.sql) drops and recreates the system portions of the DB. It is much easier for the PEQ team to do this than to create incremental updates for that portion of the DB. The second part (./updates/RevXXX.sql) updates the player portions of the DB. They do incremental updates for this portion since every server's players are different, making it impractical to do a drop and create.

Let me know if you have any further questions.
Reply With Quote