rev's And DB's In mangos

[mostafa_afus]

hello
i have a problem i Downloaded rev 2614 and 2616 and SDB v.52 so when i install this DB and rev's i can't be able to run mangos



PLZ Help me


Thank You

[MentaL]

[Kavokane]

SDB 0.5.2 rev 272 is effectively the silver database supporting up to mangos rev 2578. So if you start off with a clean 0.5.2rev272 you need to run the sql updates in sql/updates/ up to the version you have (2616).

In this case you would start with 2580_character.sql and go on down the list running each one down to the last one 2610_character.sql

Take note that you will be running these scripts on the mangos database except for 2605_realmd_account.sql which should be run, as it says, on the realmd database.

If this does not solve your problem, please be more specific as to your troubles and possibly a mangos server log.

[gemoroj]

Yay thanx, posted the problem just like this one here, but buh, her`s the solution. Thanx, no more 'Connected' looping.

[Madghost]

IS there a way to run them all at one time too many .sql files run 1 by one since the first rev.

And some of them when runnig batch in mangos says. That there is a probem 1 example.

[Err] 1054 - Unknown column 'RequiredRaputationRank' in 'item_template'
[Msg] Finished - Unsuccessfully

[Kavokane]

You only need to run the sql updates that are released after the effective database you are running. So for example if you just got SDB 0.5.2 rev 272 you have a db up to the date of revision 2578, that means you would run all scripts after 2578 up to your current server version.

As for the hastle of running the scripts, there are a few points I can make on that. First of all you probably won't be wiping your database very often, for if a new revision comes out, you just have to upgrade your old db using the update scripts as described above.

Second of all not all of the scripts have to be executed because some later ones end up changing things around so much that earlier changes may end up deleted anyway. I prefer to run all scripts from the sdb version all the way up to my revision if I do a clean wipe just to make sure I didn't miss anything and to save you the trouble of making the decision that an earlier update is irrelevant anyways.

My last point and best solution for you would be the mangos db handler tool. This tool will allow you to simply double click on an sql update script and with the push of the enter key, the script will have executed on the mangos database. This makes it possible to execute even 25 scripts very fast and without hurting your head too much. The forum link for this tool is:
http://forum.ragezone.com/world-warc...er-169619.html

From my experience, you shouldn't get failed sql updates unless you made a mistake somewhere along the line. I hope this helps and you get your server functioning.