relax_ok

Once that's done...

-Go here to download the newest UDB database (contains all the world stuff)

-Make sure that your MaNGOS core is up-to-date with the database (check your core's revision number, then the compatible revision number within the file title of the UDB database)

-Download the latest UDB update packs here (if that link doesn't work, go here and find the updates folder in /trunk)

Updating your database with .sql batch files

-Open the .sql file you are going to use to update the database in Notepad

-Open SQLyog and connect to your server

-Select the database that is supposed to be updated

-In the textbox to the right of SQLyog at the top of the application (the query textbox), paste the contents of the .sql file

-Select all the text in the textbox, then press the play button in the toolbar at the top of SQLyog

-Parts of the application will become grayed, wait for the query to finish executing

OK, i'm fine up to this part, but this is where it starts to get crazy..

MaNGOS sql dir comes with a mangos.sql but also TONS of 'updates' - are you supposed to manually apply every single one of those updates? why isn't there one query file that is current at any given time in the repository?

Also, UDB comes with a large core sql and then a huge amount of updates..

nothing in these steps says the exact order in which all this stuff is supposed to happen.

So i'll just ask straight out.. if you're installing MaNGOS/UDB for the first time.. what order do you do this in?

is it..

1) create mangos schema

2) apply the large UDB sql e.g. UDB_0.11.6_Core_8734_SD2_1480.sql

3) apply the mangos source mangos.sql

?

I did that and the server was able to start without errors...

or do you need to do something crazy like

1) create mangos schema

2) apply mangos source mangos.sql

3) apply all the mangos source sql updates in sql\\updates one by one?! only the one update in the current core version like the 9297 item template for instance..? etc

4) apply full UDB sql like above

5) go into UDB\\updates in the version additions folder and add every single update in there one by one

It's very, very unclear from these instructions what to do.

i tried to

1) create mangos schema

2) apply full UDB sql

3) try to apply UDB\\updates sqls but got all sorts of errors related to db_version table (which mangos source mangos.sql seemed to fix..)

anyway, that's enough text for now, hopefully someone has some guidance here-- i don't know how anybody can think this mess makes sense!