How to update my completely db?

[redigaffi]

Hello, i installed the udb database, alright. but when i start ./mangosd it says:

[A] You have: --> `10537_01_mangos_command.sql`

[C] You need: --> `11489_01_mangos_creature_template.sql`

Also i now how to update each file, but they are too much, how can i update all in one time??

[Schmoozerd]

the smoothest way is to copy all files that are _bigger_ than 11489 into a temp folder, and then use

for f in *_mangos_*; do mysql -uUsername -pPassword mangos < $f; done

[redigaffi]

i dont understand, show me the complete syntax please.

[redigaffi]

the smoothest way is to copy all files that are _bigger_ than 11489 into a temp folder, and then use

for f in *_mangos_*; do mysql -uUsername -pPassword mangos < $f; done

Bigger not, because im on: 10537_01_ and i need: 11489_01_

[redigaffi]

i get error in your command please help

:'(

ERROR 1054 (42S22) at line 1: Unknown column 'required_10503_04_mangos_gameobject_respawn' in 'db_version'
ERROR 1054 (42S22) at line 1: Unknown column 'required_10537_01_mangos_command' in 'db_version'
ERROR 1054 (42S22) at line 1: Unknown column 'required_10551_01_mangos_spell_proc_event' in 'db_version'
ERROR 1054 (42S22) at line 1: Unknown column 'required_10582_01_mangos_spell_proc_event' in 'db_version'
ERROR 1054 (42S22) at line 1: Unknown column 'required_10604_01_mangos_spell_proc_event' in 'db_version'
ERROR 1054 (42S22) at line 1: Unknown column 'required_10621_01_mangos_quest_template' in 'db_version'
ERROR 1054 (42S22) at line 1: Unknown column 'required_10628_01_mangos_mangos_string' in 'db_version'
ERROR 1054 (42S22) at line 1: Unknown column 'required_10629_01_mangos_mangos_string' in 'db_version'
ERROR 1054 (42S22) at line 1: Unknown column 'required_10654_01_mangos_game_event_creature_quest' in 'db_version'
ERROR 1054 (42S22) at line 1: Unknown column 'required_10660_01_mangos_game_event_quest' in 'db_version'
ERROR 1054 (42S22) at line 1: Unknown column 'required_10679_01_mangos_npc_vendor_template' in 'db_version'
ERROR 1054 (42S22) at line 1: Unknown column 'required_10679_02_mangos_creature_template' in 'db_version'
ERROR 1054 (42S22) at line 1: Unknown column 'required_10682_01_mangos_item_convert' in 'db_version'
ERROR 1054 (42S22) at line 1: Unknown column 'required_10704_01_mangos_gossip_menu_option' in 'db_version'
ERROR 1054 (42S22) at line 1: Unknown column 'required_10742_01_mangos_spell_bonus_data' in 'db_version'
ERROR 1054 (42S22) at line 1: Unknown column 'required_10743_01_mangos_spell_chain' in 'db_version'
ERROR 1054 (42S22) at line 1: Unknown column 'required_10743_02_mangos_spell_bonus_data' in 'db_version'
ERROR 1054 (42S22) at line 1: Unknown column 'required_10746_01_mangos_mangos_string' in 'db_version'
ERROR 1054 (42S22) at line 1: Unknown column 'required_10749_01_mangos_mangos_string' in 'db_version'
ERROR 1054 (42S22) at line 1: Unknown column 'required_10762_01_mangos_spell_proc_event' in 'db_version'
ERROR 1054 (42S22) at line 1: Unknown column 'required_10764_01_mangos_spell_proc_event' in 'db_version'
ERROR 1054 (42S22) at line 1: Unknown column 'required_10786_01_mangos_spell_proc_item_enchant' in 'db_version'
ERROR 1054 (42S22) at line 1: Unknown column 'required_10786_02_mangos_spell_proc_event' in 'db_version'
ERROR 1054 (42S22) at line 1: Unknown column 'required_10788_01_mangos_creature_addon' in 'db_version'
ERROR 1054 (42S22) at line 1: Unknown column 'required_10788_02_mangos_creature_template_addon' in 'db_version'
ERROR 1054 (42S22) at line 1: Unknown column 'required_10835_01_mangos_spell_proc_event' in 'db_version'
ERROR 1054 (42S22) at line 1: Unknown column 'required_10863_01_mangos_spell_proc_event' in 'db_version'
ERROR 1054 (42S22) at line 1: Unknown column 'required_10864_01_mangos_spell_proc_event' in 'db_version'
ERROR 1054 (42S22) at line 1: Unknown column 'required_10867_01_mangos_npc_trainer_template' in 'db_version'
ERROR 1054 (42S22) at line 1: Unknown column 'required_10867_02_mangos_creature_template' in 'db_version'
ERROR 1054 (42S22) at line 1: Unknown column 'required_10883_01_mangos_spell_proc_event' in 'db_version'
ERROR 1054 (42S22) at line 1: Unknown column 'required_10906_01_mangos_spell_proc_event' in 'db_version'
ERROR 1054 (42S22) at line 1: Unknown column 'required_10906_02_mangos_spell_bonus_data' in 'db_version'
ERROR 1054 (42S22) at line 1: Unknown column 'required_10932_01_mangos_game_event_creature_data' in 'db_version'
ERROR 1054 (42S22) at line 1: Unknown column 'required_10945_01_mangos_mangos_string' in 'db_version'
ERROR 1054 (42S22) at line 1: Unknown column 'required_10946_01_mangos_spell_proc_event' in 'db_version'
ERROR 1054 (42S22) at line 1: Unknown column 'required_10949_01_mangos_mangos_string' in 'db_version'
ERROR 1054 (42S22) at line 1: Unknown column 'required_10950_01_mangos_mangos_string' in 'db_version'
ERROR 1054 (42S22) at line 1: Unknown column 'required_10951_01_mangos_spell_proc_event' in 'db_version'
ERROR 1054 (42S22) at line 1: Unknown column 'required_10972_01_mangos_command' in 'db_version'
ERROR 1054 (42S22) at line 1: Unknown column 'required_10973_01_mangos_game_event_mail' in 'db_version'
ERROR 1054 (42S22) at line 1: Unknown column 'required_10988_01_mangos_mangos_string' in 'db_version'
ERROR 1054 (42S22) at line 1: Unknown column 'required_10989_01_mangos_loot_template' in 'db_version'
ERROR 1054 (42S22) at line 1: Unknown column 'required_10993_01_mangos_loot_template' in 'db_version'
ERROR 1054 (42S22) at line 1: Unknown column 'required_10998_01_mangos_spell_proc_event' in 'db_version'
ERROR 1054 (42S22) at line 1: Unknown column 'required_11002_01_mangos_spell_proc_event' in 'db_version'
ERROR 1054 (42S22) at line 1: Unknown column 'required_11018_01_mangos_command' in 'db_version'
ERROR 1054 (42S22) at line 1: Unknown column 'required_11023_01_mangos_spell_threat' in 'db_version'
ERROR 1054 (42S22) at line 1: Unknown column 'required_11036_01_mangos_spell_threat' in 'db_version'
ERROR 1054 (42S22) at line 1: Unknown column 'required_11040_01_mangos_spell_chain' in 'db_version'
ERROR 1054 (42S22) at line 1: Unknown column 'required_11040_02_mangos_spell_bonus_data' in 'db_version'
ERROR 1054 (42S22) at line 1: Unknown column 'required_11058_01_mangos_spell_proc_event' in 'db_version'
ERROR 1054 (42S22) at line 1: Unknown column 'required_11115_01_mangos_command' in 'db_version'
ERROR 1054 (42S22) at line 1: Unknown column 'required_11117_01_mangos_world_template' in 'db_version'
ERROR 1054 (42S22) at line 1: Unknown column 'required_11169_01_mangos_mangos_string' in 'db_version'
ERROR 1054 (42S22) at line 1: Unknown column 'required_11169_02_mangos_command' in 'db_version'
ERROR 1054 (42S22) at line 1: Unknown column 'required_11190_01_mangos_pool_creature_template' in 'db_version'
ERROR 1054 (42S22) at line 1: Unknown column 'required_11190_01_mangos_pool_gameobject_template' in 'db_version'
ERROR 1054 (42S22) at line 1: Unknown column 'required_11200_01_mangos_spell_bonus_data' in 'db_version'
ERROR 1054 (42S22) at line 1: Unknown column 'required_11205_01_mangos_spell_proc_event' in 'db_version'
ERROR 1054 (42S22) at line 1: Unknown column 'required_11214_01_mangos_mangos_string' in 'db_version'
ERROR 1054 (42S22) at line 1: Unknown column 'required_11214_02_mangos_command' in 'db_version'
ERROR 1054 (42S22) at line 1: Unknown column 'required_11217_01_mangos_creature_addon' in 'db_version'
ERROR 1054 (42S22) at line 1: Unknown column 'required_11234_01_mangos_command' in 'db_version'
ERROR 1054 (42S22) at line 1: Unknown column 'required_11310_01_mangos_mangos_string' in 'db_version'
ERROR 1054 (42S22) at line 1: Unknown column 'required_11312_01_mangos_mangos_string' in 'db_version'
ERROR 1054 (42S22) at line 1: Unknown column 'required_11335_01_mangos_mangos_string' in 'db_version'
ERROR 1054 (42S22) at line 1: Unknown column 'required_11335_02_mangos_mangos_string' in 'db_version'
ERROR 1054 (42S22) at line 1: Unknown column 'required_11337_01_mangos_mangos_string' in 'db_version'
ERROR 1054 (42S22) at line 1: Unknown column 'required_11348_01_mangos_spell_bonus_data' in 'db_version'
ERROR 1054 (42S22) at line 1: Unknown column 'required_11385_01_mangos_creature_template' in 'db_version'
ERROR 1054 (42S22) at line 1: Unknown column 'required_11433_01_mangos_item_template' in 'db_version'
ERROR 1054 (42S22) at line 1: Unknown column 'required_11452_01_mangos_spell_bonus_data' in 'db_version'
ERROR 1054 (42S22) at line 1: Unknown column 'required_11452_02_mangos_spell_proc_event' in 'db_version'
ERROR 1054 (42S22) at line 1: Unknown column 'required_11453_01_mangos_spell_proc_event' in 'db_version'
root@h1750370:~/mangos/sql/updates/tmp#

[Schmoozerd]

ah, yes, my typo

[A] You have: --> `10537_01_mangos_command.sql`

[C] You need: --> `11489_01_mangos_creature_template.sql`

A(10537) is less than B(11489)

so ofc you need to apply all files that are bigger than A (10537)

the first then would be: 10551_01_mangos_spell_proc_event.sql

[redigaffi]

yes but ins't there a command what execute all ?

[redigaffi]

LOL when i execute sql command: 10551_01_mangos_spell_proc_event.sql

i get

Line no.:1

Error Code: 1054 - Unknown column 'required_10537_01_mangos_command' in 'db_version'

[Cyberfreak]

And what is so "lol" about using a wrong update file?

[redigaffi]

And what is so "lol" about using a wrong update file?

Sorry i think you doesn't understand, this are too much files to update, isn't there a command to go faste

[redigaffi]

OK, i moved all directories to updates all, and i have a lot of sql files, now i executed:

for f in *_mangos_*; do mysql -uUsername -pPassword mangos < $f; done

Hopefully it works!

[redigaffi]

Ok, now i get this error executing ./mangosd:

oading MaNGOS strings...

SQL: SELECT entry,content_default,content_loc1,content_loc2,content_loc3,content_loc4,content_loc5,content_loc6,content_loc7,content_loc8 FROM mangos_string

query ERROR: Unknown column 'content_loc8' in 'field list'

[**************************************************] 100%

>> Loaded 0 mangos strings. DB table `mangos_string` is empty. Cannot continue.

PLease help

[redigaffi]

i fixed it with an python script, also i gonna do a tutorial for all peopple who has the same problem!