Cyberfreak

What you are asking for. Yes. It does not touch the intro itself, but maybe the intro depends to the starting location. Just give it a try.As a personal opinion, you should not use a repack just because of problems while getting started. If you are yet not able to compile, install & configure a server by yourself, you are also not able to give support, so you better should work on your sql problem, its not a miracle to run a selfmade mangos server.

There is no ultimate way, its depending to the patch, so you maybe should ask the author, but the often used way is a patch file, which you can insert with "git apply filename.patch" in your mangos source directory.

If there is no self-made content, which by the way should always be prepared in sql statements, you simply can drop the whole mangos (and SD2) database and replace it with an actual version. This should not affect the account or character database. For this two, there are much less updates, which can easily be inserted one by one.

By the way the mangos project (and also other WoW Server) does not compare to emulation.

First of all, mangos is a software development and learning project, not a "wow server for dummies". You need advanced skills in handling your operation system and network administration, its much bulky than game server for counterstrike and other. The wiki guides starting with download any needed programms and ending with running the compiled application, including everything like database structure. For installing any content DB like UDB there are own guides from specific developer, so where is your problem? And by the way, if you are asking for additional guide, it would be nice to know for which operating system.

8 realms is a huge load and you should really not run them as root, but there ist enough free ram. The processor is at full load, which does not suprise me with 8 realms. You simply should login at different compression level and looking for lags. If there are lags, you can try to reduce the compression rate, otherwise, you can set it higher if you want to save bandwith.

Good luck about that in the ScriptDev2 forum, and dont forget, its a pre-alpha development branch, not a well running productive system.

Project site: http://udb.no-ip.org/ But the link is still correct, there is only no new release since 09/2010.

It is just a blind shot, but maybe you tried this with a security level > 0 account? I did not check, but when it would not suprise me that a GM/Admin could learn more than the config given numbers of professions.

Does the server recognize any connection attempt in the console? Maybe the communication is blocked by a kind of firewall, you also can check if the ports are open.

Have you inserted the host name in the realmd.realmlist table?

UDB and other only provide the content in development language, which is english, but there are many localized cleaving like "name_loc3" which can be filled by independent projects and then will be automatically used for the client specified language.

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

If there is no installation guide from the patch author, it could be "git apply patchfile.patch" in your mangos source directory.

This are called NPCs. You properly inserted only the sql files from mangos, which only contains a structure, without any content. They like a blueprint for content database developer. Get a content database like UDB or YTDB, then you will get NPCs.