[QUESTION] Updating MySQL

[Auntie Mangos]

http://getmangos.eu/community/viewtopic.php?id=13121

PART 15 - UPDATING YOUR DATABASE WITH SQL FILES

It may be hard to explain but when get to understand the concept, it's all goiing fine....

[lol553]

Well... none of the guides explain what to do after you execute mangos.sql and the udb.sql file to update it. Can someone please explain what files to execute in order.

[NickoNiklas]

If you want an empty database, then just apply the mangos.sql file to your mangos database,

and if you haven't used an older rev. of mangos.sql, your mangos database should be up to date.

And the question about updating your database that's at rev. x, up to rev. y,

then there are plenty of threads about this,

there's even a stickie "[Guide]Updating for Windows" that explains how to update your database,

the principals are the same for all os.

Skip to the "Third stage "Databases":".

If you however want a content database, like UDB,

go to that forum and read their guides on how to apply that database to mangos.

All UDB related questions/problems should be directed to the UDB forum.

[lol553]

UDB forums have been down for like 2 weeks.

[VladimirMangos]

With this thread in same forum section exist pinned thread with links to 3rd party projects and it list not only forums but also projects svn/git repos.

So not important forum up state for access to last existed version.

[lol553]

i dont get it?

[lol553]

Ok i updated the db now but i get:

ERROR:Error in item_template table, probably sql file format was updated (there should be 138 fields in sql).

[lol553]

ok, got it working, but i have 1 more question how do you teleport to alterac valley?

[temporary]

No idea... haven't bin there and i'm not even using my server...lmao