Automatic Database Upgrade and Versioning

[Akkadius]

Just wanted to shoot out a quick update for this, had a code session grind last night and earlier today to finish this out. We've been needing this for quite a while. Thanks Demonstar55 for helping me test the Linux side of the updates.

What this solves:

It will automatically go through and look at each update historically and compare it against your database, if your database is missing the update, it will continue and build a list of updates and apply them in a very quick fashion
As people update their source, they no longer need to worry about upgrading their database as the process has become streamlined and completely automatic


How it Works:

When World boots up, it will start this check process by pulling down scripts from Github if you don't have them, this process happens transparent to the user
The script will load a manifest that we use to intelligently drive the script to know which updates need to be ran, I have the manifest cleanly working for old databases all the way back through our Github SQL updates about 2 years back. I have yet to go through SVN, but when I do it will work the same for people.


With this I was able to take a super old server database, and get it upgraded within minutes and boot it up. So it will be great to have for regular updates and folks who haven't upgraded in quite a while.

To run it manually, there is a db_update.pl in the server directory that you can run, to trigger other utilities such as the db_dumper.pl (Backup script) for pre-backup measures.

In the future:

We can do things like pull down latest opcodes from Github
Pull down latest PEQ AA Tables
Pull down latest PEQ Mercenary tables
Anything else that makes sense


Below is an example of what it would look like:

- On world bootup or standalone run of db_update.pl, users will be prompted with a simple menu that we will expand upon later:

================================================== ==========
EQEmu: Automatic Database Upgrade Check
================================================== ==========
Operating System is: MSWin32
(Windows) MySQL is in system path
Path = C:\Program Files\MariaDB 10.0\bin/mysql
================================================== ==========
Binary Database Version: (9057)
Local Database Version: (9057)

Database up to Date: Continuing World Bootup...
================================================== ==========
Retrieving latest database manifest...
URL: https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/db_update_manifest.txt
Saved: db_update/db_update_manifest.txt

Database Management Menu (Please Select):
1) Backup Database - (Saves to Backups folder)
Ideal to perform before performing updates
2) Backup Database Compressed - (Saves to Backups folder)
Ideal to perform before performing updates
3) Check for pending Database updates
Stages updates for automatic upgrade...
0) Exit


When you select 3) it would stage to see which updates your database does not have.

You would see something like this:

Reading manifest...

Missing DB Update 9057 '2014_11_13_spells_new_updates.sql'
URL: https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/git/required/2014_11_13_spells_new_updates.sql
Saved: db_update/2014_11_13_spells_new_updates.sql
Missing DB Update 9056 '2014_11_08_RaidMembers.sql'
URL: https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/git/required/2014_11_08_RaidMembers.sql
Saved: db_update/2014_11_08_RaidMembers.sql
Missing DB Update 9055 '2014_10_30_special_abilities_null.sql'
URL: https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/git/required/2014_10_30_special_abilities_null.sql
Saved: db_update/2014_10_30_special_abilities_null.sql
ERROR 1146 (42S02) at line 1: Table 'eoc.raid_leaders' doesn't exist
Missing DB Update 9054 '2014_10_19_raid_group_mentor.sql'
URL: https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/git/required/2014_10_19_raid_group_mentor.sql
Saved: db_update/2014_10_19_raid_group_mentor.sql
Missing DB Update 9053 '2014_10_18_group_mentor.sql'
URL: https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/git/required/2014_10_18_group_mentor.sql
Saved: db_update/2014_10_18_group_mentor.sql
Missing DB Update 9052 '2014_10_13_RaidLeadership.sql'
URL: https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/git/required/2014_10_13_RaidLeadership.sql
Saved: db_update/2014_10_13_RaidLeadership.sql
Missing DB Update 9051 '2014_10_11_RaidMOTD.sql'
URL: https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/git/required/2014_10_11_RaidMOTD.sql
Saved: db_update/2014_10_11_RaidMOTD.sql
Missing DB Update 9050 '2014_09_20_ban_messages.sql'
URL: https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/git/required/2014_09_20_ban_messages.sql
Saved: db_update/2014_09_20_ban_messages.sql
Missing DB Update 9048 '2014_09_09_attack_delay.sql'
URL: https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/git/required/2014_09_09_attack_delay.sql
Saved: db_update/2014_09_09_attack_delay.sql
Missing DB Update 9046 '2014_08_23_player_events_and_player_aa_rate_hourl y.sql'
URL: https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/git/required/2014_08_23_player_events_and_player_aa_rate_hourly .sql
Saved: db_update/2014_08_23_player_events_and_player_aa_rate_hourly .sql
Missing DB Update 9045 '2014_08_23_Complete_QueryServ_Table_Structures.sq l'
URL: https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/git/required/2014_08_23_Complete_QueryServ_Table_Structures.sql
Saved: db_update/2014_08_23_Complete_QueryServ_Table_Structures.sql
Missing DB Update 9044 '2014_08_20_merchantlist_probability.sql'
URL: https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/git/required/2014_08_20_merchantlist_probability.sql
Saved: db_update/2014_08_20_merchantlist_probability.sql
Missing DB Update 9043 '2014_08_18_spells_new_update.sql'
URL: https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/git/required/2014_08_18_spells_new_update.sql
Saved: db_update/2014_08_18_spells_new_update.sql
Missing DB Update 9042 '2014_08_12_NPC_raid_targets.sql'
URL: https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/git/required/2014_08_12_NPC_raid_targets.sql
Saved: db_update/2014_08_12_NPC_raid_targets.sql
Missing DB Update 9041 '2014_08_02_spells_new.sql'
URL: https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/git/required/2014_08_02_spells_new.sql
Saved: db_update/2014_08_02_spells_new.sql
Missing DB Update 9040 '2014_07_10_npc_spells.sql'
URL: https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/git/required/2014_07_10_npc_spells.sql
Saved: db_update/2014_07_10_npc_spells.sql
Missing DB Update 9039 '2014_07_04_AA_Updates.sql'
URL: https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/git/required/2014_07_04_AA_Updates.sql
Saved: db_update/2014_07_04_AA_Updates.sql
Missing DB Update 9038 '2014_06_25_AA_Updates.sql'
URL: https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/git/required/2014_06_25_AA_Updates.sql
Saved: db_update/2014_06_25_AA_Updates.sql
Missing DB Update 9036 '2014_05_04_SlowMitigationFix.sql'
URL: https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/git/required/2014_05_04_SlowMitigationFix.sql
Saved: db_update/2014_05_04_SlowMitigationFix.sql
Missing DB Update 9035 '2014_04_27_AISpellEffects.sql'
URL: https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/git/required/2014_04_27_AISpellEffects.sql
Saved: db_update/2014_04_27_AISpellEffects.sql
Missing DB Update 9034 '2014_04_25_spawn_events.sql'
URL: https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/git/required/2014_04_25_spawn_events.sql
Saved: db_update/2014_04_25_spawn_events.sql
Missing DB Update 9032 '2014_04_12_SlowMitigation.sql'
URL: https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/git/required/2014_04_12_SlowMitigation.sql
Saved: db_update/2014_04_12_SlowMitigation.sql
Missing DB Update 9031 '2014_04_10_No_Target_With_Hotkey.sql'
URL: https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/git/required/2014_04_10_No_Target_With_Hotkey.sql
Saved: db_update/2014_04_10_No_Target_With_Hotkey.sql
Missing DB Update 9030 '2014_04_04_PhysicalResist.sql'
URL: https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/git/required/2014_04_04_PhysicalResist.sql
Saved: db_update/2014_04_04_PhysicalResist.sql
Missing DB Update 9029 '2014_02_26_virulentvenomAA.sql'
URL: https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/git/required/2014_02_26_virulentvenomAA.sql
Saved: db_update/2014_02_26_virulentvenomAA.sql
Missing DB Update 9028 '2014_02_26_roambox_update.sql'
URL: https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/git/required/2014_02_26_roambox_update.sql
Saved: db_update/2014_02_26_roambox_update.sql
Missing DB Update 9027 '2014_02_20_buff_update.sql'
URL: https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/git/required/2014_02_20_buff_update.sql
Saved: db_update/2014_02_20_buff_update.sql
DB up to date with: 9026 '2014_02_13_spells_new_update.sql'
Missing DB Update 9025 '2014_02_13_Rename_instance_lockout_tables.sql'
URL: https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/git/required/2014_02_13_Rename_instance_lockout_tables.sql
Saved: db_update/2014_02_13_Rename_instance_lockout_tables.sql
DB up to date with: 9024 '2014_02_02_SpellCriticalsAA.sql'
Missing DB Update 9023 '2014_01_27_CritcalMendAA.sql'
URL: https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/git/required/2014_01_27_CritcalMendAA.sql
Saved: db_update/2014_01_27_CritcalMendAA.sql
Missing DB Update 9022 '2014_01_20_Weather.sql'
URL: https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/git/required/2014_01_20_Weather.sql
Saved: db_update/2014_01_20_Weather.sql
Missing DB Update 9021 '2014_01_20_SpellCastingReinforcement.sql'
URL: https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/git/required/2014_01_20_SpellCastingReinforcement.sql
Saved: db_update/2014_01_20_SpellCastingReinforcement.sql
DB up to date with: 9020 '2014_01_20_Not_Extendable.sql'
Missing DB Update 9019 '2014_01_20_MezMastery.sql'
URL: https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/git/required/2014_01_20_MezMastery.sql
Saved: db_update/2014_01_20_MezMastery.sql
Missing DB Update 9018 '2014_01_09_PreservePetSize.sql'
URL: https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/git/required/2014_01_09_PreservePetSize.sql
Saved: db_update/2014_01_09_PreservePetSize.sql
DB up to date with: 9017 '2014_01_08_SpellsNewAdditions.sql'
Missing DB Update 9016 '2014_01_04_SongModCapAAs.sql'
URL: https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/git/required/2014_01_04_SongModCapAAs.sql
Saved: db_update/2014_01_04_SongModCapAAs.sql
Missing DB Update 9015 '2013_12_26_MerchantList_Class_Required.sql'
URL: https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/git/required/2013_12_26_MerchantList_Class_Required.sql
Saved: db_update/2013_12_26_MerchantList_Class_Required.sql
DB up to date with: 9014 '2013_11_18_AssistRadius.sql'
DB up to date with: 9013 '2013_11_13_Instrument_Singing_Mastery.sql'
DB up to date with: 9012 '2013_11_07_BaseData.sql'
DB up to date with: 9011 '2013_10_31_Recipe_disabling.sql'
DB up to date with: 9009 '2013_10_12_Merc_Special_Abilities.sql'
DB up to date with: 9008 '2013_07_11_NPC_Special_Abilities.sql'
DB up to date with: 9007 '2013_05_05_Item_Tick.sql'
DB up to date with: 9006 '2013_05_05_Account_Flags.sql'
DB up to date with: 9005 '2013_04_08_Salvage.sql'
DB up to date with: 9004 '2013_04_04_NaturesBounty.sql'
DB up to date with: 9002 '2013_03_1_Merc_Rules_and_Equipment.sql'
DB up to date with: 9001 '2013_02_25_Impr_HT_LT.sql'
DB up to date with: 9000 '2013_02_18_Merc_Rules_and_Tables.sql'
DB up to date with: 8000 'mercs.sql'

When this routine completes, you should see something that resembles the following:

Running Update: 9015 - 2013_12_26_MerchantList_Class_Required.sql
Running Update: 9016 - 2014_01_04_SongModCapAAs.sql
Running Update: 9018 - 2014_01_09_PreservePetSize.sql
Running Update: 9019 - 2014_01_20_MezMastery.sql
Running Update: 9021 - 2014_01_20_SpellCastingReinforcement.sql
Running Update: 9022 - 2014_01_20_Weather.sql
Running Update: 9023 - 2014_01_27_CritcalMendAA.sql
Running Update: 9025 - 2014_02_13_Rename_instance_lockout_tables.sql
Running Update: 9027 - 2014_02_20_buff_update.sql
ERROR 1146 (42S02) at line 4: Table 'eoc.botbuffs' doesn't exist
ERROR 1146 (42S02) at line 8: Table 'eoc.botbuffs' doesn't exist
ERROR 1146 (42S02) at line 12: Table 'eoc.botbuffs' doesn't exist
ERROR 1146 (42S02) at line 16: Table 'eoc.botbuffs' doesn't exist
ERROR 1146 (42S02) at line 20: Table 'eoc.botbuffs' doesn't exist
ERROR 1054 (42S22) at line 22: Unknown column 'not_reflectable' in 'spells_new'
Running Update: 9028 - 2014_02_26_roambox_update.sql
Running Update: 9029 - 2014_02_26_virulentvenomAA.sql
Running Update: 9030 - 2014_04_04_PhysicalResist.sql
Running Update: 9031 - 2014_04_10_No_Target_With_Hotkey.sql
Running Update: 9032 - 2014_04_12_SlowMitigation.sql
Running Update: 9034 - 2014_04_25_spawn_events.sql
Running Update: 9035 - 2014_04_27_AISpellEffects.sql
Running Update: 9036 - 2014_05_04_SlowMitigationFix.sql
Running Update: 9038 - 2014_06_25_AA_Updates.sql
Running Update: 9039 - 2014_07_04_AA_Updates.sql
Running Update: 9040 - 2014_07_10_npc_spells.sql
Running Update: 9041 - 2014_08_02_spells_new.sql
Running Update: 9042 - 2014_08_12_NPC_raid_targets.sql
Running Update: 9043 - 2014_08_18_spells_new_update.sql
Running Update: 9044 - 2014_08_20_merchantlist_probability.sql
Running Update: 9045 - 2014_08_23_Complete_QueryServ_Table_Structures.sql
Running Update: 9046 - 2014_08_23_player_events_and_player_aa_rate_hourly .sql
Running Update: 9048 - 2014_09_09_attack_delay.sql
Running Update: 9050 - 2014_09_20_ban_messages.sql
Running Update: 9051 - 2014_10_11_RaidMOTD.sql
Running Update: 9052 - 2014_10_13_RaidLeadership.sql
Running Update: 9053 - 2014_10_18_group_mentor.sql
Running Update: 9054 - 2014_10_19_raid_group_mentor.sql
Running Update: 9055 - 2014_10_30_special_abilities_null.sql
Running Update: 9056 - 2014_11_08_RaidMembers.sql
Running Update: 9057 - 2014_11_13_spells_new_updates.sql
Reading manifest...

DB up to date with: 9057 '2014_11_13_spells_new_updates.sql'
DB up to date with: 9056 '2014_11_08_RaidMembers.sql'
DB up to date with: 9055 '2014_10_30_special_abilities_null.sql'
DB up to date with: 9054 '2014_10_19_raid_group_mentor.sql'
DB up to date with: 9053 '2014_10_18_group_mentor.sql'
DB up to date with: 9052 '2014_10_13_RaidLeadership.sql'
DB up to date with: 9051 '2014_10_11_RaidMOTD.sql'
DB up to date with: 9050 '2014_09_20_ban_messages.sql'
DB up to date with: 9048 '2014_09_09_attack_delay.sql'
DB up to date with: 9046 '2014_08_23_player_events_and_player_aa_rate_hourl y.sql'
DB up to date with: 9045 '2014_08_23_Complete_QueryServ_Table_Structures.sq l'
DB up to date with: 9044 '2014_08_20_merchantlist_probability.sql'
DB up to date with: 9043 '2014_08_18_spells_new_update.sql'
DB up to date with: 9042 '2014_08_12_NPC_raid_targets.sql'
DB up to date with: 9041 '2014_08_02_spells_new.sql'
DB up to date with: 9040 '2014_07_10_npc_spells.sql'
DB up to date with: 9039 '2014_07_04_AA_Updates.sql'
DB up to date with: 9038 '2014_06_25_AA_Updates.sql'
DB up to date with: 9036 '2014_05_04_SlowMitigationFix.sql'
DB up to date with: 9035 '2014_04_27_AISpellEffects.sql'
DB up to date with: 9034 '2014_04_25_spawn_events.sql'
DB up to date with: 9032 '2014_04_12_SlowMitigation.sql'
DB up to date with: 9031 '2014_04_10_No_Target_With_Hotkey.sql'
DB up to date with: 9030 '2014_04_04_PhysicalResist.sql'
DB up to date with: 9029 '2014_02_26_virulentvenomAA.sql'
DB up to date with: 9028 '2014_02_26_roambox_update.sql'
DB up to date with: 9027 '2014_02_20_buff_update.sql'
DB up to date with: 9026 '2014_02_13_spells_new_update.sql'
DB up to date with: 9025 '2014_02_13_Rename_instance_lockout_tables.sql'
DB up to date with: 9024 '2014_02_02_SpellCriticalsAA.sql'
DB up to date with: 9023 '2014_01_27_CritcalMendAA.sql'
DB up to date with: 9022 '2014_01_20_Weather.sql'
DB up to date with: 9021 '2014_01_20_SpellCastingReinforcement.sql'
DB up to date with: 9020 '2014_01_20_Not_Extendable.sql'
DB up to date with: 9019 '2014_01_20_MezMastery.sql'
DB up to date with: 9018 '2014_01_09_PreservePetSize.sql'
DB up to date with: 9017 '2014_01_08_SpellsNewAdditions.sql'
DB up to date with: 9016 '2014_01_04_SongModCapAAs.sql'
DB up to date with: 9015 '2013_12_26_MerchantList_Class_Required.sql'
DB up to date with: 9014 '2013_11_18_AssistRadius.sql'
DB up to date with: 9013 '2013_11_13_Instrument_Singing_Mastery.sql'
DB up to date with: 9012 '2013_11_07_BaseData.sql'
DB up to date with: 9011 '2013_10_31_Recipe_disabling.sql'
DB up to date with: 9009 '2013_10_12_Merc_Special_Abilities.sql'
DB up to date with: 9008 '2013_07_11_NPC_Special_Abilities.sql'
DB up to date with: 9007 '2013_05_05_Item_Tick.sql'
DB up to date with: 9006 '2013_05_05_Account_Flags.sql'
DB up to date with: 9005 '2013_04_08_Salvage.sql'
DB up to date with: 9004 '2013_04_04_NaturesBounty.sql'
DB up to date with: 9002 '2013_03_1_Merc_Rules_and_Equipment.sql'
DB up to date with: 9001 '2013_02_25_Impr_HT_LT.sql'
DB up to date with: 9000 '2013_02_18_Merc_Rules_and_Tables.sql'
DB up to date with: 8000 'mercs.sql'



Yes there were some errors, because I'm not using bots. But everything else went through smoothly.

And then a return back to the management menu:

Database Management Menu (Please Select):
1) Backup Database - (Saves to Backups folder)
Ideal to perform before performing updates
2) Backup Database Compressed - (Saves to Backups folder)
Ideal to perform before performing updates
3) Check for pending Database updates
Stages updates for automatic upgrade...
0) Exit


When the database is up to date, world will not interrupt the bootup process. When versions match it will simply bootup as intended. When you have updates that need to be made, you probably shouldn't be booting up anyways.

If anyone has any questions, comments feel free. Enjoy this should be a huge step in keeping our server upgrade process streamlined.

http://i.imgur.com/lCVKRms.png

Changelog Notes:


== 11/16/2014 ==
demonstar55: fix size issue with ControlBoat_Struct and exploit fix in OP_BoardBoat
Akkadius: Implemented Automatic Database update and versioning system
Akkadius: Created database revision define, this is located in version.h in common #define CURRENT_BINARY_DATABASE_VERSION 9057
- This revision define will need to be incremented each time a database update is made
- Along with a revision define increment, you will need to update the db_update manifest located in:
- https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/db_update_manifest.txt
- An entry needs to be made at the bottom of the manifest, the entry is quite simple
- Example: 9057|2014_11_13_spells_new_updates.sql|SHOW COLUMNS FROM `spells_new` LIKE 'disallow_sit'|empty|
- This latest example is checking to see if the spells_new table contains the column 'disallow_sit', if its empty, the update needs to be ran
- More examples of match types below:
# Example: Version|Filename.sql|Query_to_Check_Condition_For_ Needed_Update|match type|text to match
# 0 = Database Version
# 1 = Filename.sql
# 2 = Query_to_Check_Condition_For_Needed_Update
# 3 = Match Type - If condition from match type to Value 4 is true, update will flag for needing to be ran
# contains = If query results contains text from 4th value
# match = If query results matches text from 4th value
# missing = If query result is missing text from 4th value
# empty = If the query results in no results
# not_empty = If the query is not empty
# 4 = Text to match
- The manifest contains all database updates 'Required' to be made to the schema, and it will contain a working backport all the way back to SVN -
currently it is tested and backported through the beginning of our Github repo
- On world bootup or standalone run of db_update.pl, users will be prompted with a simple menu that we will expand upon later:

================================================== ==========
EQEmu: Automatic Database Upgrade Check
================================================== ==========
Operating System is: MSWin32
(Windows) MySQL is in system path
Path = C:\Program Files\MariaDB 10.0\bin/mysql
================================================== ==========
Binary Database Version: (9057)
Local Database Version: (9057)

Database up to Date: Continuing World Bootup...
================================================== ==========
Retrieving latest database manifest...
URL: https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/db_update_manifest.txt
Saved: db_update/db_update_manifest.txt

Database Management Menu (Please Select):
1) Backup Database - (Saves to Backups folder)
Ideal to perform before performing updates
2) Backup Database Compressed - (Saves to Backups folder)
Ideal to perform before performing updates
3) Check for pending Database updates
Stages updates for automatic upgrade...
0) Exit

Akkadius: Created db_update.pl, placed in utils/scripts folder, used for the automatic database update routine (Linux/Windows)
- db_update.pl script created db_version table if not created, if old one is present it will remove it
Akkadius: Created db_dumper.pl, placed in utils/scripts folder, used for the automatic database update routine backups and standalone backups (Linux/Windows)
Akkadius: World will now check the db_update.pl script on bootup, if the db_update.pl script is not present, it will fetch it remotely before running -
when db_update.pl is done running, world will continue with bootup

Thanks,
Akka

[ghanja]

Is there a parameter world can be passed to either make a users preferred choice and/or completely say "not right now go away" ?

Confused because you stated:

When World boots up, it will start this check process by pulling down scripts from Github if you don't have them, this process happens transparent to the user


but then what reads to be a slight contradiction:

When you have updates that need to be made, you probably shouldn't be booting up anyways.


Interrupting the World process seems, well, a little pushy. <shrug> You asked for opinions, there ya go.

[Akkadius]

These are required database scheme updates and if you are updating your binaries you are also going to want your schematic to reflect so what you're saying doesn't make sense.

Adding a skip check parameter to world can be done for those who would like the choice. But the point is to have it so most users will notice that there is an upgrade needing to be done with the database side. It really takes seconds to do and you won't have to see it until you update your source with another schema change.

Also what you may not be seeing as well is that if your schema is up to date, world will still boot up uninterrupted. if world boots up and their binary DB version is greater than you local than you would want to update otherwise you could have major things flat out not work.

Anything can be added to it at this point it's pretty easy. Most of the heavy lifting is done and it was a lot of work in a short amount of time mainly because I've had a lot of time to think about it.

[ghanja]

These are required database scheme updates and if you are updating your binaries you are also going to want your schematic to reflect so what you're saying doesn't make sense.


Halting the running of World waiting for user input was the gist of what I was making comment about.

Made sense to me. :)

[vsab]

Just to clarify; assuming that you are running a server and don't update the binaries and your database is 100% up to date with the binaries you are using, this script will determine that you are running the latest you need and basically do nothing and World will just run without any intervention. So in this case automated restarts will simply "just work".

However, if you update your binaries but NOT your database, then it will update, immediately after which I assume you would be doing a restart attended (or manually update the database).

Is that correct?

[chrsschb]

Making sure I understand this fully...

The script automatically does schema updates, NOT content updates. Correct?

So for instance it won't overwrite changes to spells, items, AAs, rules, etc?

[Akkadius]

Once again, required schema updates are things like adding a table, or a field or changing core mechanic data. Not content oriented data.

[Scorpious2k]

I hate people who wait until something is done and then come around to poke it and criticize. I apologize if I appear to be doing that. That isn't what is intended. I think this is a brilliant and useful feature!

That said, wouldn't it have been better in shared_memory instead of world? That way it could update the DB before writing out the tables. Tables affected, including those in shared memory would then be up-to-date before you got to world.

It seems to me that if you do it in world, and tables affected includes those in shared_memory then shared_memory could crash before ever getting to world or it would write old style tables to shared memory which would ultimately cause problems in world/zones.

I could of course be wrong.

[Akkadius]

I think people are severely missing the point here.

I did this for a mere quality of life benefit for the EQEmu community.

The complaints or suggestions I'm getting are one small fucking step in regards to quality of life as to how you open your server. Patch it, be done within seconds, never see it again until next binary update actually requires a database change.

If you are maintaining a server, updating binaries, you need to update your database, it's that simple. Otherwise, there is no change in the workflow.

[chrsschb]

I think people are severely missing the point here.

I did this for a mere quality of life benefit for the EQEmu community.

The complaints or suggestions I'm getting are one small fucking step in regards to quality of life as to how you open your server. Patch it, be done within seconds, never see it again until next binary update actually requires a database change.

If you are maintaining a server, updating binaries, you need to update your database, it's that simple. Otherwise, there is no change in the workflow.

No hate intended from me, just wanting to make sure I understand 100%. :-D

Appreciate it!

[provocating]

Oh my!! Going to test this out soon, awesomeness.

[Akkadius]

Here is a Wiki article that may explain things a little more clearly:

http://wiki.eqemulator.org/p?Automatic_Database_Upgrade_System&frm=Main

In the end, the system is super simple to use.

[ionhsmith]

This seems cool ... I know U said u have it working for Linux ... is it available for others? If so how do I get it to work?

[Akkadius]

This seems cool ... I know U said u have it working for Linux ... is it available for others? If so how do I get it to work?

............What?

[Akkadius]

FYI this now optionally allow users to pull fresh PEQ AA tables:

http://i.imgur.com/OBrIOCM.png

[Krran]

This is pretty good stuff and will cut down on the errors people are encountering starting and updating a server. Thanks for putting in the time to make this process MUCH easier, especially for newbies or those who are not as familiar with how to script this kind of stuff.
I know I will be using it and will help me to update more frequently.

[Drajor]

This is a really positive step in the right direction IMO. Anything that lowers or removes an entry barrier will hopefully result in more people trying it out and making cool things. Also less 'Hulp! It's broken!' posts heh

[pfyon]

Just FYI, my old start script redirects the output of all the binaries (world, zone, etc) to a logfile. Turns out when this starts, it prompts for user input if there are updates.... and continues to prompt. 16GB logfile later I discovered this and killed it.

So anyone who redirects output to a logfile, beware.

[Akkadius]

Just FYI, my old start script redirects the output of all the binaries (world, zone, etc) to a logfile. Turns out when this starts, it prompts for user input if there are updates.... and continues to prompt. 16GB logfile later I discovered this and killed it.

So anyone who redirects output to a logfile, beware.

These are the sorts of things that I need to fix and be brought to attention.

I'm assuming this is Linux.

If your database is up to date you won't have that issue since it will not wait for a prompt.

Can you reproduce to me what the contents of the log is? I'm going to guess its reprinting the menu because the start script is sending characters.

[trevius]

Just FYI, my old start script redirects the output of all the binaries (world, zone, etc) to a logfile. Turns out when this starts, it prompts for user input if there are updates.... and continues to prompt. 16GB logfile later I discovered this and killed it.

So anyone who redirects output to a logfile, beware.

Had this same issue, so Akkadius was already aware and it will be resolved. Until it is fixed, you can get around this by starting world manually the first time after you update by doing the following:

./world

Then you can respond to the prompts, update your db and CTRL+C to end the process. Finally, use your startup script again as normal and you will be running without issues (at least until the next update).

[pfyon]

Had this same issue, so Akkadius was already aware and it will be resolved. Until it is fixed, you can get around this by starting world manually the first time after you update by doing the following:

./world

Then you can respond to the prompts, update your db and CTRL+C to end the process. Finally, use your startup script again as normal and you will be running without issues (at least until the next update).

Yeah, I realized the issue after waiting about half an hour and doing a df -h. And yes, linux.

Ultimately, I was bringing my source up to date and my database is all screwed up because I guess bots are screwed up right now? So it was never able to run all the updates properly.

[knowom]

Is this a bit like WSUS offline slipstream updates applied to EQemu? Basically take for example EQemu repack and ensure it stays up to date automatically as the peqDB changes in the future?

Another words combined together a slipstream installation and patching system. I kind of assume it was partly made both to update old DB's easily, but also to ensure your repack stays up to date and doesn't require constant maintenance for users?

[Akkadius]

Is this a bit like WSUS offline slipstream updates applied to EQemu? Basically take for example EQemu repack and ensure it stays up to date automatically as the peqDB changes in the future?

Another words combined together a slipstream installation and patching system. I kind of assume it was partly made both to update old DB's easily, but also to ensure your repack stays up to date and doesn't require constant maintenance for users?

No, its not supposed to be a WSUS type of setup. Most people upgrading a server are connected to the internet at the time because they need to pull down new source files to even compile and this script runs no differently.

This is for everyone, to keep databases consistent and also provide us a graceful medium to apply updates effectively.

Yeah sure its being but right in the middle of normal workflow, but if you're up to date you don't notice anything.

At its core its meant to keep a database update with the binary you are running, it fetches updates from github and runs whatever is appropriate.

With it, we also can start providing pre-patch options in it too. Like for example enabling bots at the database level or enabling mercenaries, turning on and off rules and such can be made plug and play with this as well. Lots to evolve with.

[Akkadius]

Yeah, I realized the issue after waiting about half an hour and doing a df -h. And yes, linux.

Ultimately, I was bringing my source up to date and my database is all screwed up because I guess bots are screwed up right now? So it was never able to run all the updates properly.

Are you running bots currently?

[pfyon]

Are you running bots currently?

I was, but that was around 6 months ago. I had to rebuild my vps and am just getting around to getting eqemu back up now.

[Akkadius]

Here is a fix for linux users. Replace your start script as such:

http://wiki.eqemulator.org/i?Module=Pastebin&Paste=xRJzfmq2

It will run the update routine before ever triggering world, which will all the user take care of updates, exit the program and then everything will continue to flow and start the server up every single time until you decide to upgrade.

[ionhsmith]

Hmm I must be missing something ... how do I go about installing this?

[Akkadius]

Hmm I must be missing something ... how do I go about installing this?

What do you mean? Are you running Linux? Or are you talking about the system itself?

[ionhsmith]

No I do not run linux ... I was talking about the system itself ... I like the idea of being able to quickly install updates .... Is this only for linux?

[Akkadius]

No being on Linux just means you have to change a little bit of your scripts to make it more friendly.

This explains how it works here, in the end its part of the binary and I've put a lot of effort in making it seamless.

http://wiki.eqemulator.org/p?Automatic_Database_Upgrade_System#how-the-upgrade-process-works

[Burningsoul]

Hypopathetically speaking, what's the age limit on a database this will upgrade? I see your in your example pic it starts with updates from 2013, anyone run Zeb/Squeeker/older stuff through it for giggles?

[Akkadius]

Hypopathetically speaking, what's the age limit on a database this will upgrade? I see your in your example pic it starts with updates from 2013, anyone run Zeb/Squeeker/older stuff through it for giggles?

Thanks for reminding me, I have the manifest built through all of Github updates. I need to configure the manifest to understand all of the upgrades through SVN.

So technically when I have that done, it should take a super old database all the way up to recent with ease.

Akka's Funhouse for example was just old enough to be a few months ahead of when we started with Git, so I took a 2 year old database and brought it to recent within seconds. Very very nice thing to have.

[wirepuller134]

Just compiled and updated. This worked flawlessly, thank you for adding this feature!

[Riklin]

I just wanted to mention that this works GREAT!

For around 20 total hours I tried every guide I could find, every list of steps, to update halls havoc database correctly. Everything I tried would have errors in various sql scripts. Then when it apparently worked, there were things obviously wrong. Things like inventory disappeared completely and all items seemed to be unavailable, yet the items table was full of items. I ended up resurrecting a an old database save from before I started trying to update, and then sourced the data then ran the server.

The automatic updater worked perfectly!


I think there is so much obsolete information out there now, that it is difficult to figure out exactly what to do. This auto-updater is a GREAT feature!

Excellent work, all!

Rick HallsHavoc

[iluvseq]

This only works if the database runs on the same host as the world server. Your script grabs host from the config file, but never actually uses the $host variable in your mysql commands.

Since it also auto-downloads db_update.pl I can't even fix the script as my changes get overwritten.

[Akkadius]

This only works if the database runs on the same host as the world server. Your script grabs host from the config file, but never actually uses the $host variable in your mysql commands.

Since it also auto-downloads db_update.pl I can't even fix the script as my changes get overwritten.

Run your updates on the world server?

[iluvseq]

The world server and the database server are not the same host. You should simply modify the script to add --host="$host" to the various mysql command lines and that would solve the issue.

As a work-around, I've simply set the MYSQL_HOST environment variable prior to running ./world

Even then, the script still doesn't fully update the database (coming from peqbeta_2014-10-11-02:01.sql) as apparently that database is missing some core tables like character_buffs so there are 8 required updates which fail to apply. Not really a problem with the script, per-se, although I'm surprised there isn't a simple empty schema included with the source that one could apply to build an empty, clean and current database so that this whole patch process wouldn't be necessary for a brand new installation. Relying on PEQ to provide the base schema seems silly.

[Riklin]

But there are warnings all over the place not to use the October 2014 version of the database. You need to use the September version...

[iluvseq]

I have yet to see any of those warnings. Other than the one I posted after I figured it out the hard way.

Regardless, that has nothing to do with the fact that the update_db.pl script parses the configuration file for <host> and then ignores it, only working on localhost unless you set the MYSQL_HOST environment variable.

This is a bug in the script, regardless of which peq db one uses (or even if one doesn't use peq at all!)

[Akkadius]

I have yet to see any of those warnings. Other than the one I posted after I figured it out the hard way.

Regardless, that has nothing to do with the fact that the update_db.pl script parses the configuration file for <host> and then ignores it, only working on localhost unless you set the MYSQL_HOST environment variable.

This is a bug in the script, regardless of which peq db one uses (or even if one doesn't use peq at all!)

Wouldn't necessarily call it a bug.

It pulls it down automatically because I've set it that way for a while because at one point the script wasn't capable of checking itself for updates by being passed parameters by the source, could probably change that soon.

Also, why are you using multiple hosts? It's far unecessary unless you actually have load to match the necessity.

98% of the folks who run the script aren't going to need a host option and would simply run it on their database server.

Updated, you're welcome.

https://github.com/EQEmu/Server/commit/73c29fc2f0e6e5b36771007f24a6e1e00cc91214

And

Even then, the script still doesn't fully update the database (coming from peqbeta_2014-10-11-02:01.sql) as apparently that database is missing some core tables like character_buffs so there are 8 required updates which fail to apply. Not really a problem with the script, per-se, although I'm surprised there isn't a simple empty schema included with the source that one could apply to build an empty, clean and current database so that this whole patch process wouldn't be necessary for a brand new installation. Relying on PEQ to provide the base schema seems silly.

This has to do with PEQ dumps, the schema update does exactly what it needs to do and PEQ missing tables is another issue in itself. I will notify those who oversee those dumps.

[iluvseq]

I run on multiple hosts because I have multiple hosts already setup in a variety of roles. My DMZ host (where I run eqemu) doesn't run mysql. I already have it running on an internal host and adding the eqemu database to that makes the most sense for my environment.

[Aristoxenus]

This is not working for me and I cant seem to find out what is wrong. It downloads all the database updates but doesn't seem to apply them.

[World Server] Loading server configuration..
[World Server] CURRENT_VERSION: 1.0.0
[World Server] Added loginserver login.eqemulator.net:5998
[World Server] Connecting to MySQL...
[Status] Starting File Log 'logs/world_4700.log'
[World Server] HTTP world service disabled.
[World Server] Checking Database Conversions..
[Upgrade Script] No script update necessary
Perl Version is 5.12.3
The system cannot find the path specified.
The system cannot find the path specified.
The system cannot find the path specified.
Table 'db_version' does not exists.... Creating...

The system cannot find the path specified.
================================================== ==========
EQEmu: Automatic Upgrade Check
================================================== ==========
(Windows) MySQL is in system path
Path = C:\Program Files (x86)\MySQL\MySQL Server 5.5\bin/mysql
================================================== ==========
Binary Database Version: (9069)
Local Database Version: ()

Retrieving latest database manifest...
URL: https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/
db_update_manifest.txt
Saved: db_update/db_update_manifest.txt
You have missing database updates, type 1 or 2 to backup your database before ru
nning them as recommended...

Database Management Menu (Please Select):
1) Backup Database - (Saves to Backups folder)
Ideal to perform before performing updates
2) Backup Database Compressed - (Saves to Backups folder)
Ideal to perform before performing updates
3) Check for pending REQUIRED Database updates
Stages updates for automatic upgrade...
4) AAs - Get Latest AA's from PEQ (This deletes AA's already in the data
base)
5) OPCodes - Download latest opcodes from repository
0) Exit

> 3
Reading manifest...

The system cannot find the path specified.
Missing DB Update 9069 '2015_01_25_logsys_Mercenaries_category.sql'
URL: https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/
git/required/2015_01_25_logsys_Mercenaries_category.sql
Saved: db_update/2015_01_25_logsys_Mercenaries_category.sql
The system cannot find the path specified.
Missing DB Update 9068 '2015_01_15_logsys_categories_table.sql'
URL: https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/
git/required/2015_01_15_logsys_categories_table.sql
Saved: db_update/2015_01_15_logsys_categories_table.sql
The system cannot find the path specified.
Missing DB Update 9067 '2015_01_21_npc_types_update.sql'
URL: https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/
git/required/2015_01_21_npc_types_update.sql
Saved: db_update/2015_01_21_npc_types_update.sql
The system cannot find the path specified.
DB up to date with: 9066 - '2014_12_31_npc_types_default_values_update.sql'
The system cannot find the path specified.
Missing DB Update 9065 '2014_12_26_merc_weaponinfo_table_update.sql'
URL: https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/
git/required/2014_12_26_merc_weaponinfo_table_update.sql
Saved: db_update/2014_12_26_merc_weaponinfo_table_update.sql
The system cannot find the path specified.
Missing DB Update 9064 '2014_12_24_npc_types_table_update.sql'
URL: https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/
git/required/2014_12_24_npc_types_table_update.sql
Saved: db_update/2014_12_24_npc_types_table_update.sql
The system cannot find the path specified.
Missing DB Update 9063 '2014_12_24_npc_types_update.sql'
URL: https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/
git/required/2014_12_24_npc_types_update.sql
Saved: db_update/2014_12_24_npc_types_update.sql
The system cannot find the path specified.
Missing DB Update 9062 '2014_12_15_multiple_table_updates.sql'
URL: https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/
git/required/2014_12_15_multiple_table_updates.sql
Saved: db_update/2014_12_15_multiple_table_updates.sql
The system cannot find the path specified.
Missing DB Update 9061 '2014_12_13_inventory_table_update.sql'
URL: https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/
git/required/2014_12_13_inventory_table_update.sql
Saved: db_update/2014_12_13_inventory_table_update.sql
The system cannot find the path specified.
Missing DB Update 9060 '2014_12_09_items_table_update.sql'
URL: https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/
git/required/2014_12_09_items_table_update.sql
Saved: db_update/2014_12_09_items_table_update.sql
The system cannot find the path specified.
Missing DB Update 9059 '2014_12_01_mercs_table_update.sql'
URL: https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/
git/required/2014_12_01_mercs_table_update.sql
Saved: db_update/2014_12_01_mercs_table_update.sql
The system cannot find the path specified.
Missing DB Update 9058 '2014_11_26_InventoryTableUpdate.sql'
URL: https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/
git/required/2014_11_26_InventoryTableUpdate.sql
Saved: db_update/2014_11_26_InventoryTableUpdate.sql
The system cannot find the path specified.
Missing DB Update 9057 '2014_11_13_spells_new_updates.sql'
URL: https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/
git/required/2014_11_13_spells_new_updates.sql
Saved: db_update/2014_11_13_spells_new_updates.sql
The system cannot find the path specified.
Missing DB Update 9056 '2014_11_08_RaidMembers.sql'
URL: https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/
git/required/2014_11_08_RaidMembers.sql
Saved: db_update/2014_11_08_RaidMembers.sql
The system cannot find the path specified.
DB up to date with: 9055 - '2014_10_30_special_abilities_null.sql'
The system cannot find the path specified.
Missing DB Update 9054 '2014_10_19_raid_group_mentor.sql'
URL: https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/
git/required/2014_10_19_raid_group_mentor.sql
Saved: db_update/2014_10_19_raid_group_mentor.sql
The system cannot find the path specified.
Missing DB Update 9053 '2014_10_18_group_mentor.sql'
URL: https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/
git/required/2014_10_18_group_mentor.sql
Saved: db_update/2014_10_18_group_mentor.sql
The system cannot find the path specified.
Missing DB Update 9052 '2014_10_13_RaidLeadership.sql'
URL: https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/
git/required/2014_10_13_RaidLeadership.sql
Saved: db_update/2014_10_13_RaidLeadership.sql
The system cannot find the path specified.
Missing DB Update 9051 '2014_10_11_RaidMOTD.sql'
URL: https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/
git/required/2014_10_11_RaidMOTD.sql
Saved: db_update/2014_10_11_RaidMOTD.sql
The system cannot find the path specified.
Missing DB Update 9050 '2014_09_20_ban_messages.sql'
URL: https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/
git/required/2014_09_20_ban_messages.sql
Saved: db_update/2014_09_20_ban_messages.sql
The system cannot find the path specified.
Missing DB Update 9048 '2014_09_09_attack_delay.sql'
URL: https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/
git/required/2014_09_09_attack_delay.sql
Saved: db_update/2014_09_09_attack_delay.sql
The system cannot find the path specified.
Missing DB Update 9046 '2014_08_23_player_events_and_player_aa_rate_hourl y.sql'

URL: https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/
git/required/2014_08_23_player_events_and_player_aa_rate_hourly .sql
Saved: db_update/2014_08_23_player_events_and_player_aa_rate_hourly .sql

The system cannot find the path specified.
Missing DB Update 9045 '2014_08_23_Complete_QueryServ_Table_Structures.sq l'
URL: https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/
git/required/2014_08_23_Complete_QueryServ_Table_Structures.sql
Saved: db_update/2014_08_23_Complete_QueryServ_Table_Structures.sql
The system cannot find the path specified.
Missing DB Update 9044 '2014_08_20_merchantlist_probability.sql'
URL: https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/
git/required/2014_08_20_merchantlist_probability.sql
Saved: db_update/2014_08_20_merchantlist_probability.sql
The system cannot find the path specified.
Missing DB Update 9043 '2014_08_18_spells_new_update.sql'
URL: https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/
git/required/2014_08_18_spells_new_update.sql
Saved: db_update/2014_08_18_spells_new_update.sql
The system cannot find the path specified.
Missing DB Update 9042 '2014_08_12_NPC_raid_targets.sql'
URL: https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/
git/required/2014_08_12_NPC_raid_targets.sql
Saved: db_update/2014_08_12_NPC_raid_targets.sql
The system cannot find the path specified.
Missing DB Update 9041 '2014_08_02_spells_new.sql'
URL: https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/
git/required/2014_08_02_spells_new.sql
Saved: db_update/2014_08_02_spells_new.sql
The system cannot find the path specified.
Missing DB Update 9040 '2014_07_10_npc_spells.sql'
URL: https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/
git/required/2014_07_10_npc_spells.sql
Saved: db_update/2014_07_10_npc_spells.sql
The system cannot find the path specified.
DB up to date with: 9036 - '2014_05_04_SlowMitigationFix.sql'
The system cannot find the path specified.
Missing DB Update 9035 '2014_04_27_AISpellEffects.sql'
URL: https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/
git/required/2014_04_27_AISpellEffects.sql
Saved: db_update/2014_04_27_AISpellEffects.sql
The system cannot find the path specified.
Missing DB Update 9034 '2014_04_25_spawn_events.sql'
URL: https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/
git/required/2014_04_25_spawn_events.sql
Saved: db_update/2014_04_25_spawn_events.sql
The system cannot find the path specified.
DB up to date with: 9032 - '2014_04_12_SlowMitigation.sql'
The system cannot find the path specified.
Missing DB Update 9031 '2014_04_10_No_Target_With_Hotkey.sql'
URL: https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/
git/required/2014_04_10_No_Target_With_Hotkey.sql
Saved: db_update/2014_04_10_No_Target_With_Hotkey.sql
The system cannot find the path specified.
Missing DB Update 9030 '2014_04_04_PhysicalResist.sql'
URL: https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/
git/required/2014_04_04_PhysicalResist.sql
Saved: db_update/2014_04_04_PhysicalResist.sql
The system cannot find the path specified.
Missing DB Update 9028 '2014_02_26_roambox_update.sql'
URL: https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/
git/required/2014_02_26_roambox_update.sql
Saved: db_update/2014_02_26_roambox_update.sql
The system cannot find the path specified.
Missing DB Update 9027 '2014_02_20_buff_update.sql'
URL: https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/
git/required/2014_02_20_buff_update.sql
Saved: db_update/2014_02_20_buff_update.sql
The system cannot find the path specified.
Missing DB Update 9026 '2014_02_13_spells_new_update.sql'
URL: https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/
git/required/2014_02_13_spells_new_update.sql
Saved: db_update/2014_02_13_spells_new_update.sql
The system cannot find the path specified.
Missing DB Update 9025 '2014_02_13_Rename_instance_lockout_tables.sql'
URL: https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/
git/required/2014_02_13_Rename_instance_lockout_tables.sql
Saved: db_update/2014_02_13_Rename_instance_lockout_tables.sql
The system cannot find the path specified.
Missing DB Update 9022 '2014_01_20_Weather.sql'
URL: https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/
git/required/2014_01_20_Weather.sql
Saved: db_update/2014_01_20_Weather.sql
The system cannot find the path specified.
Missing DB Update 9020 '2014_01_20_Not_Extendable.sql'
URL: https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/
git/required/2014_01_20_Not_Extendable.sql
Saved: db_update/2014_01_20_Not_Extendable.sql
The system cannot find the path specified.
Missing DB Update 9018 '2014_01_09_PreservePetSize.sql'
URL: https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/
git/required/2014_01_09_PreservePetSize.sql
Saved: db_update/2014_01_09_PreservePetSize.sql
The system cannot find the path specified.
Missing DB Update 9017 '2014_01_08_SpellsNewAdditions.sql'
URL: https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/
git/required/2014_01_08_SpellsNewAdditions.sql
Saved: db_update/2014_01_08_SpellsNewAdditions.sql
The system cannot find the path specified.
Missing DB Update 9015 '2013_12_26_MerchantList_Class_Required.sql'
URL: https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/
git/required/2013_12_26_MerchantList_Class_Required.sql
Saved: db_update/2013_12_26_MerchantList_Class_Required.sql
The system cannot find the path specified.
Missing DB Update 9014 '2013_11_18_AssistRadius.sql'
URL: https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/
git/required/2013_11_18_AssistRadius.sql
Saved: db_update/2013_11_18_AssistRadius.sql
The system cannot find the path specified.
Missing DB Update 9012 '2013_11_07_BaseData.sql'
URL: https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/
git/required/2013_11_07_BaseData.sql
Saved: db_update/2013_11_07_BaseData.sql
The system cannot find the path specified.
Missing DB Update 9011 '2013_10_31_Recipe_disabling.sql'
URL: https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/
git/required/2013_10_31_Recipe_disabling.sql
Saved: db_update/2013_10_31_Recipe_disabling.sql
The system cannot find the path specified.
Missing DB Update 9009 '2013_10_12_Merc_Special_Abilities.sql'
URL: https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/
git/required/2013_10_12_Merc_Special_Abilities.sql
Saved: db_update/2013_10_12_Merc_Special_Abilities.sql
The system cannot find the path specified.
Missing DB Update 9008 '2013_07_11_NPC_Special_Abilities.sql'
URL: https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/
git/required/2013_07_11_NPC_Special_Abilities.sql
Saved: db_update/2013_07_11_NPC_Special_Abilities.sql
The system cannot find the path specified.
Missing DB Update 9007 '2013_05_05_Item_Tick.sql'
URL: https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/
git/required/2013_05_05_Item_Tick.sql
Saved: db_update/2013_05_05_Item_Tick.sql
The system cannot find the path specified.
Missing DB Update 9006 '2013_05_05_Account_Flags.sql'
URL: https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/
git/required/2013_05_05_Account_Flags.sql
Saved: db_update/2013_05_05_Account_Flags.sql
The system cannot find the path specified.
Missing DB Update 9005 '2013_04_08_Salvage.sql'
URL: https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/
git/required/2013_04_08_Salvage.sql
Saved: db_update/2013_04_08_Salvage.sql
The system cannot find the path specified.
Missing DB Update 9002 '2013_03_1_Merc_Rules_and_Equipment.sql'
URL: https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/
git/required/2013_03_1_Merc_Rules_and_Equipment.sql
Saved: db_update/2013_03_1_Merc_Rules_and_Equipment.sql
The system cannot find the path specified.
Missing DB Update 9001 '2013_02_25_Impr_HT_LT.sql'
URL: https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/
git/required/2013_02_25_Impr_HT_LT.sql
Saved: db_update/2013_02_25_Impr_HT_LT.sql
The system cannot find the path specified.
Missing DB Update 9000 '2013_02_18_Merc_Rules_and_Tables.sql'
URL: https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/
git/required/2013_02_18_Merc_Rules_and_Tables.sql
Saved: db_update/2013_02_18_Merc_Rules_and_Tables.sql
The system cannot find the path specified.
Missing DB Update 8000 'mercs.sql'
URL: https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/
svn/mercs.sql
Saved: db_update/mercs.sql

Database Management Menu (Please Select):
1) Backup Database - (Saves to Backups folder)
Ideal to perform before performing updates
2) Backup Database Compressed - (Saves to Backups folder)
Ideal to perform before performing updates
3) Run pending REQUIRED updates... (51)
4) AAs - Get Latest AA's from PEQ (This deletes AA's already in the data
base)
5) OPCodes - Download latest opcodes from repository
0) Exit

> 3
Running Update: 8000 - mercs.sql
The system cannot find the path specified.
The system cannot find the path specified.
Running Update: 9000 - 2013_02_18_Merc_Rules_and_Tables.sql
The system cannot find the path specified.
The system cannot find the path specified.
Running Update: 9001 - 2013_02_25_Impr_HT_LT.sql
The system cannot find the path specified.
The system cannot find the path specified.
Running Update: 9002 - 2013_03_1_Merc_Rules_and_Equipment.sql
The system cannot find the path specified.
The system cannot find the path specified.
Running Update: 9005 - 2013_04_08_Salvage.sql
The system cannot find the path specified.
The system cannot find the path specified.
Running Update: 9006 - 2013_05_05_Account_Flags.sql
The system cannot find the path specified.
The system cannot find the path specified.
Running Update: 9007 - 2013_05_05_Item_Tick.sql
The system cannot find the path specified.
The system cannot find the path specified.
Running Update: 9008 - 2013_07_11_NPC_Special_Abilities.sql
The system cannot find the path specified.
The system cannot find the path specified.
Running Update: 9009 - 2013_10_12_Merc_Special_Abilities.sql
The system cannot find the path specified.
The system cannot find the path specified.
Running Update: 9011 - 2013_10_31_Recipe_disabling.sql
The system cannot find the path specified.
The system cannot find the path specified.
Running Update: 9012 - 2013_11_07_BaseData.sql
The system cannot find the path specified.
The system cannot find the path specified.
Running Update: 9014 - 2013_11_18_AssistRadius.sql
The system cannot find the path specified.
The system cannot find the path specified.
Running Update: 9015 - 2013_12_26_MerchantList_Class_Required.sql
The system cannot find the path specified.
The system cannot find the path specified.
Running Update: 9017 - 2014_01_08_SpellsNewAdditions.sql
The system cannot find the path specified.
The system cannot find the path specified.
Running Update: 9018 - 2014_01_09_PreservePetSize.sql
The system cannot find the path specified.
The system cannot find the path specified.
Running Update: 9020 - 2014_01_20_Not_Extendable.sql
The system cannot find the path specified.
The system cannot find the path specified.
Running Update: 9022 - 2014_01_20_Weather.sql
The system cannot find the path specified.
The system cannot find the path specified.
Running Update: 9025 - 2014_02_13_Rename_instance_lockout_tables.sql
The system cannot find the path specified.
The system cannot find the path specified.
Running Update: 9026 - 2014_02_13_spells_new_update.sql
The system cannot find the path specified.
The system cannot find the path specified.
Running Update: 9027 - 2014_02_20_buff_update.sql
The system cannot find the path specified.
The system cannot find the path specified.
Running Update: 9028 - 2014_02_26_roambox_update.sql
The system cannot find the path specified.
The system cannot find the path specified.
Running Update: 9030 - 2014_04_04_PhysicalResist.sql
The system cannot find the path specified.
The system cannot find the path specified.
Running Update: 9031 - 2014_04_10_No_Target_With_Hotkey.sql
The system cannot find the path specified.
The system cannot find the path specified.
Running Update: 9034 - 2014_04_25_spawn_events.sql
The system cannot find the path specified.
The system cannot find the path specified.
Running Update: 9035 - 2014_04_27_AISpellEffects.sql
The system cannot find the path specified.
The system cannot find the path specified.
Running Update: 9040 - 2014_07_10_npc_spells.sql
The system cannot find the path specified.
The system cannot find the path specified.
Running Update: 9041 - 2014_08_02_spells_new.sql
The system cannot find the path specified.
The system cannot find the path specified.
Running Update: 9042 - 2014_08_12_NPC_raid_targets.sql
The system cannot find the path specified.
The system cannot find the path specified.
Running Update: 9043 - 2014_08_18_spells_new_update.sql
The system cannot find the path specified.
The system cannot find the path specified.
Running Update: 9044 - 2014_08_20_merchantlist_probability.sql
The system cannot find the path specified.
The system cannot find the path specified.
Running Update: 9045 - 2014_08_23_Complete_QueryServ_Table_Structures.sql
The system cannot find the path specified.
The system cannot find the path specified.
Running Update: 9046 - 2014_08_23_player_events_and_player_aa_rate_hourly .sql
The system cannot find the path specified.
The system cannot find the path specified.
Running Update: 9048 - 2014_09_09_attack_delay.sql
The system cannot find the path specified.
The system cannot find the path specified.
Running Update: 9050 - 2014_09_20_ban_messages.sql
The system cannot find the path specified.
The system cannot find the path specified.
Running Update: 9051 - 2014_10_11_RaidMOTD.sql
The system cannot find the path specified.
The system cannot find the path specified.
Running Update: 9052 - 2014_10_13_RaidLeadership.sql
The system cannot find the path specified.
The system cannot find the path specified.
Running Update: 9053 - 2014_10_18_group_mentor.sql
The system cannot find the path specified.
The system cannot find the path specified.
Running Update: 9054 - 2014_10_19_raid_group_mentor.sql
The system cannot find the path specified.
The system cannot find the path specified.
Running Update: 9056 - 2014_11_08_RaidMembers.sql
The system cannot find the path specified.
The system cannot find the path specified.
Running Update: 9057 - 2014_11_13_spells_new_updates.sql
The system cannot find the path specified.
The system cannot find the path specified.
Running Update: 9058 - 2014_11_26_InventoryTableUpdate.sql
The system cannot find the path specified.
The system cannot find the path specified.
Running Update: 9059 - 2014_12_01_mercs_table_update.sql
The system cannot find the path specified.
The system cannot find the path specified.
Running Update: 9060 - 2014_12_09_items_table_update.sql
The system cannot find the path specified.
The system cannot find the path specified.
Running Update: 9061 - 2014_12_13_inventory_table_update.sql
The system cannot find the path specified.
The system cannot find the path specified.
Running Update: 9062 - 2014_12_15_multiple_table_updates.sql
The system cannot find the path specified.
The system cannot find the path specified.
Running Update: 9063 - 2014_12_24_npc_types_update.sql
The system cannot find the path specified.
The system cannot find the path specified.
Running Update: 9064 - 2014_12_24_npc_types_table_update.sql
The system cannot find the path specified.
The system cannot find the path specified.
Running Update: 9065 - 2014_12_26_merc_weaponinfo_table_update.sql
The system cannot find the path specified.
The system cannot find the path specified.
Running Update: 9067 - 2015_01_21_npc_types_update.sql
The system cannot find the path specified.
The system cannot find the path specified.
Running Update: 9068 - 2015_01_15_logsys_categories_table.sql
The system cannot find the path specified.
The system cannot find the path specified.
Running Update: 9069 - 2015_01_25_logsys_Mercenaries_category.sql
The system cannot find the path specified.
The system cannot find the path specified.
Reading manifest...

The system cannot find the path specified.
Missing DB Update 9069 '2015_01_25_logsys_Mercenaries_category.sql'
URL: https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/
git/required/2015_01_25_logsys_Mercenaries_category.sql
Saved: db_update/2015_01_25_logsys_Mercenaries_category.sql
The system cannot find the path specified.
Missing DB Update 9068 '2015_01_15_logsys_categories_table.sql'
URL: https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/
git/required/2015_01_15_logsys_categories_table.sql
Saved: db_update/2015_01_15_logsys_categories_table.sql
The system cannot find the path specified.
Missing DB Update 9067 '2015_01_21_npc_types_update.sql'
URL: https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/
git/required/2015_01_21_npc_types_update.sql
Saved: db_update/2015_01_21_npc_types_update.sql
The system cannot find the path specified.
DB up to date with: 9066 - '2014_12_31_npc_types_default_values_update.sql'
The system cannot find the path specified.
Missing DB Update 9065 '2014_12_26_merc_weaponinfo_table_update.sql'
URL: https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/
git/required/2014_12_26_merc_weaponinfo_table_update.sql
Saved: db_update/2014_12_26_merc_weaponinfo_table_update.sql
The system cannot find the path specified.
Missing DB Update 9064 '2014_12_24_npc_types_table_update.sql'
URL: https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/
git/required/2014_12_24_npc_types_table_update.sql
Saved: db_update/2014_12_24_npc_types_table_update.sql
The system cannot find the path specified.
Missing DB Update 9063 '2014_12_24_npc_types_update.sql'
URL: https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/
git/required/2014_12_24_npc_types_update.sql
Saved: db_update/2014_12_24_npc_types_update.sql
The system cannot find the path specified.
Missing DB Update 9062 '2014_12_15_multiple_table_updates.sql'
URL: https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/
git/required/2014_12_15_multiple_table_updates.sql
Saved: db_update/2014_12_15_multiple_table_updates.sql
The system cannot find the path specified.
Missing DB Update 9061 '2014_12_13_inventory_table_update.sql'
URL: https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/
git/required/2014_12_13_inventory_table_update.sql
Saved: db_update/2014_12_13_inventory_table_update.sql
The system cannot find the path specified.
Missing DB Update 9060 '2014_12_09_items_table_update.sql'
URL: https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/
git/required/2014_12_09_items_table_update.sql
Saved: db_update/2014_12_09_items_table_update.sql
The system cannot find the path specified.
Missing DB Update 9059 '2014_12_01_mercs_table_update.sql'
URL: https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/
git/required/2014_12_01_mercs_table_update.sql
Saved: db_update/2014_12_01_mercs_table_update.sql
The system cannot find the path specified.
Missing DB Update 9058 '2014_11_26_InventoryTableUpdate.sql'
URL: https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/
git/required/2014_11_26_InventoryTableUpdate.sql
Saved: db_update/2014_11_26_InventoryTableUpdate.sql
The system cannot find the path specified.
Missing DB Update 9057 '2014_11_13_spells_new_updates.sql'
URL: https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/
git/required/2014_11_13_spells_new_updates.sql
Saved: db_update/2014_11_13_spells_new_updates.sql
The system cannot find the path specified.
Missing DB Update 9056 '2014_11_08_RaidMembers.sql'
URL: https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/
git/required/2014_11_08_RaidMembers.sql
Saved: db_update/2014_11_08_RaidMembers.sql
The system cannot find the path specified.
DB up to date with: 9055 - '2014_10_30_special_abilities_null.sql'
The system cannot find the path specified.
Missing DB Update 9054 '2014_10_19_raid_group_mentor.sql'
URL: https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/
git/required/2014_10_19_raid_group_mentor.sql
Saved: db_update/2014_10_19_raid_group_mentor.sql
The system cannot find the path specified.
Missing DB Update 9053 '2014_10_18_group_mentor.sql'
URL: https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/
git/required/2014_10_18_group_mentor.sql
Saved: db_update/2014_10_18_group_mentor.sql
The system cannot find the path specified.
Missing DB Update 9052 '2014_10_13_RaidLeadership.sql'
URL: https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/
git/required/2014_10_13_RaidLeadership.sql
Saved: db_update/2014_10_13_RaidLeadership.sql
The system cannot find the path specified.
Missing DB Update 9051 '2014_10_11_RaidMOTD.sql'
URL: https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/
git/required/2014_10_11_RaidMOTD.sql
Saved: db_update/2014_10_11_RaidMOTD.sql
The system cannot find the path specified.
Missing DB Update 9050 '2014_09_20_ban_messages.sql'
URL: https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/
git/required/2014_09_20_ban_messages.sql
Saved: db_update/2014_09_20_ban_messages.sql
The system cannot find the path specified.
Missing DB Update 9048 '2014_09_09_attack_delay.sql'
URL: https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/
git/required/2014_09_09_attack_delay.sql
Saved: db_update/2014_09_09_attack_delay.sql
The system cannot find the path specified.
Missing DB Update 9046 '2014_08_23_player_events_and_player_aa_rate_hourl y.sql'

URL: https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/
git/required/2014_08_23_player_events_and_player_aa_rate_hourly .sql
Saved: db_update/2014_08_23_player_events_and_player_aa_rate_hourly .sql

The system cannot find the path specified.
Missing DB Update 9045 '2014_08_23_Complete_QueryServ_Table_Structures.sq l'
URL: https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/
git/required/2014_08_23_Complete_QueryServ_Table_Structures.sql
Saved: db_update/2014_08_23_Complete_QueryServ_Table_Structures.sql
The system cannot find the path specified.
Missing DB Update 9044 '2014_08_20_merchantlist_probability.sql'
URL: https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/
git/required/2014_08_20_merchantlist_probability.sql
Saved: db_update/2014_08_20_merchantlist_probability.sql
The system cannot find the path specified.
Missing DB Update 9043 '2014_08_18_spells_new_update.sql'
URL: https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/
git/required/2014_08_18_spells_new_update.sql
Saved: db_update/2014_08_18_spells_new_update.sql
The system cannot find the path specified.
Missing DB Update 9042 '2014_08_12_NPC_raid_targets.sql'
URL: https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/
git/required/2014_08_12_NPC_raid_targets.sql
Saved: db_update/2014_08_12_NPC_raid_targets.sql
The system cannot find the path specified.
Missing DB Update 9041 '2014_08_02_spells_new.sql'
URL: https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/
git/required/2014_08_02_spells_new.sql
Saved: db_update/2014_08_02_spells_new.sql
The system cannot find the path specified.
Missing DB Update 9040 '2014_07_10_npc_spells.sql'
URL: https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/
git/required/2014_07_10_npc_spells.sql
Saved: db_update/2014_07_10_npc_spells.sql
The system cannot find the path specified.
DB up to date with: 9036 - '2014_05_04_SlowMitigationFix.sql'
The system cannot find the path specified.
Missing DB Update 9035 '2014_04_27_AISpellEffects.sql'
URL: https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/
git/required/2014_04_27_AISpellEffects.sql
Saved: db_update/2014_04_27_AISpellEffects.sql
The system cannot find the path specified.
Missing DB Update 9034 '2014_04_25_spawn_events.sql'
URL: https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/
git/required/2014_04_25_spawn_events.sql
Saved: db_update/2014_04_25_spawn_events.sql
The system cannot find the path specified.
DB up to date with: 9032 - '2014_04_12_SlowMitigation.sql'
The system cannot find the path specified.
Missing DB Update 9031 '2014_04_10_No_Target_With_Hotkey.sql'
URL: https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/
git/required/2014_04_10_No_Target_With_Hotkey.sql
Saved: db_update/2014_04_10_No_Target_With_Hotkey.sql
The system cannot find the path specified.
Missing DB Update 9030 '2014_04_04_PhysicalResist.sql'
URL: https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/
git/required/2014_04_04_PhysicalResist.sql
Saved: db_update/2014_04_04_PhysicalResist.sql
The system cannot find the path specified.
Missing DB Update 9028 '2014_02_26_roambox_update.sql'
URL: https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/
git/required/2014_02_26_roambox_update.sql
Saved: db_update/2014_02_26_roambox_update.sql
The system cannot find the path specified.
Missing DB Update 9027 '2014_02_20_buff_update.sql'
URL: https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/
git/required/2014_02_20_buff_update.sql
Saved: db_update/2014_02_20_buff_update.sql
The system cannot find the path specified.
Missing DB Update 9026 '2014_02_13_spells_new_update.sql'
URL: https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/
git/required/2014_02_13_spells_new_update.sql
Saved: db_update/2014_02_13_spells_new_update.sql
The system cannot find the path specified.
Missing DB Update 9025 '2014_02_13_Rename_instance_lockout_tables.sql'
URL: https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/
git/required/2014_02_13_Rename_instance_lockout_tables.sql
Saved: db_update/2014_02_13_Rename_instance_lockout_tables.sql
The system cannot find the path specified.
Missing DB Update 9022 '2014_01_20_Weather.sql'
URL: https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/
git/required/2014_01_20_Weather.sql
Saved: db_update/2014_01_20_Weather.sql
The system cannot find the path specified.
Missing DB Update 9020 '2014_01_20_Not_Extendable.sql'
URL: https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/
git/required/2014_01_20_Not_Extendable.sql
Saved: db_update/2014_01_20_Not_Extendable.sql
The system cannot find the path specified.
Missing DB Update 9018 '2014_01_09_PreservePetSize.sql'
URL: https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/
git/required/2014_01_09_PreservePetSize.sql
Saved: db_update/2014_01_09_PreservePetSize.sql
The system cannot find the path specified.
Missing DB Update 9017 '2014_01_08_SpellsNewAdditions.sql'
URL: https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/
git/required/2014_01_08_SpellsNewAdditions.sql
Saved: db_update/2014_01_08_SpellsNewAdditions.sql
The system cannot find the path specified.
Missing DB Update 9015 '2013_12_26_MerchantList_Class_Required.sql'
URL: https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/
git/required/2013_12_26_MerchantList_Class_Required.sql
Saved: db_update/2013_12_26_MerchantList_Class_Required.sql
The system cannot find the path specified.
Missing DB Update 9014 '2013_11_18_AssistRadius.sql'
URL: https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/
git/required/2013_11_18_AssistRadius.sql
Saved: db_update/2013_11_18_AssistRadius.sql
The system cannot find the path specified.
Missing DB Update 9012 '2013_11_07_BaseData.sql'
URL: https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/
git/required/2013_11_07_BaseData.sql
Saved: db_update/2013_11_07_BaseData.sql
The system cannot find the path specified.
Missing DB Update 9011 '2013_10_31_Recipe_disabling.sql'
URL: https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/
git/required/2013_10_31_Recipe_disabling.sql
Saved: db_update/2013_10_31_Recipe_disabling.sql
The system cannot find the path specified.
Missing DB Update 9009 '2013_10_12_Merc_Special_Abilities.sql'
URL: https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/
git/required/2013_10_12_Merc_Special_Abilities.sql
Saved: db_update/2013_10_12_Merc_Special_Abilities.sql
The system cannot find the path specified.
Missing DB Update 9008 '2013_07_11_NPC_Special_Abilities.sql'
URL: https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/
git/required/2013_07_11_NPC_Special_Abilities.sql
Saved: db_update/2013_07_11_NPC_Special_Abilities.sql
The system cannot find the path specified.
Missing DB Update 9007 '2013_05_05_Item_Tick.sql'
URL: https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/
git/required/2013_05_05_Item_Tick.sql
Saved: db_update/2013_05_05_Item_Tick.sql
The system cannot find the path specified.
Missing DB Update 9006 '2013_05_05_Account_Flags.sql'
URL: https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/
git/required/2013_05_05_Account_Flags.sql
Saved: db_update/2013_05_05_Account_Flags.sql
The system cannot find the path specified.
Missing DB Update 9005 '2013_04_08_Salvage.sql'
URL: https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/
git/required/2013_04_08_Salvage.sql
Saved: db_update/2013_04_08_Salvage.sql
The system cannot find the path specified.
Missing DB Update 9002 '2013_03_1_Merc_Rules_and_Equipment.sql'
URL: https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/
git/required/2013_03_1_Merc_Rules_and_Equipment.sql
Saved: db_update/2013_03_1_Merc_Rules_and_Equipment.sql
The system cannot find the path specified.
Missing DB Update 9001 '2013_02_25_Impr_HT_LT.sql'
URL: https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/
git/required/2013_02_25_Impr_HT_LT.sql
Saved: db_update/2013_02_25_Impr_HT_LT.sql
The system cannot find the path specified.
Missing DB Update 9000 '2013_02_18_Merc_Rules_and_Tables.sql'
URL: https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/
git/required/2013_02_18_Merc_Rules_and_Tables.sql
Saved: db_update/2013_02_18_Merc_Rules_and_Tables.sql
The system cannot find the path specified.
Missing DB Update 8000 'mercs.sql'
URL: https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/
svn/mercs.sql
Saved: db_update/mercs.sql

Database Management Menu (Please Select):
1) Backup Database - (Saves to Backups folder)
Ideal to perform before performing updates
2) Backup Database Compressed - (Saves to Backups folder)
Ideal to perform before performing updates
3) Run pending REQUIRED updates... (51)
4) AAs - Get Latest AA's from PEQ (This deletes AA's already in the data
base)
5) OPCodes - Download latest opcodes from repository
0) Exit

>

[dagulus2]

Did you select option 3 at this point?

[Aristoxenus]

Yes, I select option 3 and it downloads the updates even if I already have them in the db_update folder. I select option 3 again and I get several "The system cannot find the path specified." errors.

[Akkadius]

Little bit more detail please.

What OS?

Have you ran these updates before?

etc.

[Aristoxenus]

Solved! I had an extra MySQL entry in my windows path variable for version 5.5.

[noudess]

Made huge changes to my very old db and all worked just fine.

Thanks - great addition - makes it much easier to stay up-to-date.