help needed with databases update

[networkmoneky]

Hi I've followed the guild to install mangos on a debian system using Revision 12330 when i start the server i get this message

The table `db_version` in your [WORLD] database indicates that this database is out of date!

[A] You have: --> `12195_02_mangos_mangos_string.sql`

[B] You need: --> `12300_01_mangos_mangos_string.sql`

You must apply all updates after [A] to [B] to use mangos with this database.
These updates are included in the sql/updates folder.
Please read the included [README] in sql/updates for instructions on updating.

ive tried install the update 12300_01_mangos_mangos_string.sql
using mysql -u root -p mangos < 12300_01_mangos_mangos_string.sql

this throws this error

ERROR 1054 (42S22) at line 1: Unknown column 'required_12298_01_mangos_spell_template' in 'db_version'
root@wow-server:~/mangos/server/sql/updates#

if i install that update is throws a similar error
can someone please help

paul

[XxXGenesisXxX]

You have to install ALL the updates, in order.

[networkmoneky]

this is the update directory
0.10 12112_10_mangos_player_xp_for_level.sql 12216_04_mangos_gameobject_loot_template.sql
0.11 12112_11_mangos_playercreateinfo_action.sql 12216_05_mangos_item_loot_template.sql
0.12 12112_12_mangos_playercreateinfo_spell.sql 12216_06_mangos_mail_loot_template.sql
0.13 12112_13_mangos_player_levelstats.sql 12216_07_mangos_milling_loot_template.sql
0.14 12112_14_mangos_command.sql 12216_08_mangos_pickpocketing_loot_template.sql
0.15 12120_01_mangos_spell_template.sql 12216_09_mangos_prospecting_loot_template.sql
0.16 12121_01_mangos_spell_template.sql 12216_10_mangos_reference_loot_template.sql
0.17 12138_01_characters_characters.sql 12216_11_mangos_skinning_loot_template.sql
0.5 12138_01_mangos_command.sql 12216_12_mangos_spell_loot_template.sql
0.6 12141_01_characters_character_currencies.sql 12225_01_mangos_locales_quest.sql
0.7 12141_01_mangos_command.sql 12225_02_mangos_quest_template.sql
0.8 12141_02_mangos_mangos_string.sql 12241_01_mangos_creature_template.sql
0.9 12150_01_characters_saved_variables.sql 12245_01_mangos_mangos_string.sql
12112_01_characters_character_phase_data.sql 12150_01_mangos_mangos_string.sql 12257_01_mangos_spell_learn_spell.sql
12112_01_mangos_item_template.sql 12161_01_characters_characters.sql 12259_01_characters_petition.sql
12112_01_realmd_account_access.sql 12164_01_mangos_command.sql 12259_02_characters_petition_sign.sql
12112_02_characters_character.sql 12179_01_mangos_player_levelstats.sql 12274_01_mangos_vehicle_accessory.sql
12112_02_mangos_quest_template.sql 12180_01_mangos_spell_learn_spell.sql 12275_01_mangos_creature_template_spells.sql
12112_03_mangos_gameobject_template.sql 12185_01_mangos_item_template.sql 12297_01_characters_auction.sql
12112_04_mangos_npc_vendor.sql 12186_01_mangos_item_template.sql 12298_01_mangos_spell_template.sql
12112_05_mangos_npc_vendor_template.sql 12195_01_mangos_areatrigger_teleport.sql 12300_01_characters_characters.sql
12112_06_mangos_mangos_string.sql 12195_02_mangos_mangos_string.sql 12300_01_mangos_mangos_string.sql
12112_07_mangos_quest_phase_maps.sql 12216_01_mangos_creature_loot_template.sql 12300_02_characters_mail.sql
12112_08_mangos_player_classlevelstats.sql 12216_02_mangos_disenchant_loot_template.sql README
12112_09_mangos_playercreateinfo.sql 12216_03_mangos_fishing_loot_template.sql

if i install 12300_01_mangos_mangos_string.sql using mysql -u root -p mangos < 12300_01_mangos_mangos_string.sql it will ask for the file below this in the list, I've tried to install the first sql file ie 12112_01_characters_character_phase_data.sql in the list using mysql -u root -p characters < 12112_01_characters_character_phase_data.sql and this asks for a earlier file so I'm a little unsure in the sense of how to install the updates in order can some one point this out or could all the updates be run from a bash script

paul

[XxXGenesisXxX]

Install them manually by exectuting the scripts in a DB editor (Navicat, HeidiSQL, SQLyog). And make sure you are putting them into the right databases.

characters_character_currencies.sql -> Goes in characters database not mangos database.
mangos_spell_template.sql -> Vice versa.