Update : You can browse this site software category if you’re looking for my mangos release or my custom mangos release … btw i’d suggest you to get my mangos release first because it has been tested with WoW 2.2.3 and will be updated frequently (even easier than anything written on this old post because i already include everything you need to run your own wow private server except for mysql program of course)
Or you can also look at the recent software section located at the footer section of this website to see the new update to my mangos release :)
This is the second part of the Creating your own World of Warcraft Server using Mangos
Okay and before i start i’d like to warn you first especially to those who’s using Dial Up Connection because there are a lot of images used here and the previous mysql installation guide although i’ve optimized it further
Without further ado … here’s the guide ;)
Requirements :
If you’re planning on creating :
– The Burning Crusade Server :
Okay i’ve decided to upload my own compiled mangos to make thing easier, for more info see this new post
Btw … the installing mysql part is still the same … so if you need information on how to install mysql refer to the part 1
Note : Since most people who compiled Mangos for Win32 already included DBC and Map Extractor in their release you should use that one first. And unfortunately i can not give direct link to the files so you must try it by yourself and judge which version is the best for you :)
Btw some people prefer (especially to those who’s using high speed internet access – not me of course –) to download the extracted maps and dbc from somewhere rather than extracting it directly so if you are using the same high speed connection you might like to use this option
– World of Warcraft Classic Server :
That’s it … unfortunately since it is using the old mangos revision you’ll notice more bugs compared to latest / newest version for TBC … and since i dont have TBC Client installed, i can only give you a how to guide to configure your mangos server based on my experience when doing remote assistance to someone who asked for help via MSN
Btw if you’re going to create WoW Classic server you can use my extracted DBC Files
Side Note : Basically since there are no differences on creating WoW TBC Server and WoW Classic Server the only thing you should change is just the filename … don’t worry if you don’t understand what i’m talking about right now, soon you’ll know about it :)
Creating Directory Structure :
Okay i assume you’ve finished downloading all the required stuff and now its the time to configure your mangos. But before that you need to extract the required files first into your harddrive and organize it before starting to configure mangos (although this step optional but i think organized directory structure looks better but that is just my own opinion)
Look at the image below for a good explanation about this :

Extracting Maps and DBC Files from World of Warcraft Game :
Now this is when the ad.exe and dbc extractor came. But first we are going to use the ad.exe. And here’s the step

After you’ve finished extracting maps now it is the time you use DBC Extractor … and here’s the step to use it
If you want a more detailed explanation look at the screenshot below

and then the shortcut properties

Importing the SDB Files :
Okay we have finished extracting the maps and dbc files required for mangos, now we need to import the database first before you can run mangos program
and here’s the summary on how it done :
If you’re going to create WoW Classic Server

and here’s what it’ll looks like when it’s finished

Note : Because some people prefer to see the importing process (some say it’s like Matrix .. lol), i decided to use -v (verbose) switch but if you prefer not to see it you can safely remove the -v switch
If you’re going to create TBC Server
Here’s the summary on how it’s done :
An example on how to execute the query is like below (you must do this in order) and using the same path as the above image
And that’s it you’re finished importing the database required :)
Editing Mangos Configuration :
You’ve finished extracting maps, dbc and already imported the database required but now what else ? of course you need to edit the mangosd.conf file itself
Now here’s the summary on how it is done :
Now here’s some screenshot of the mangos configuration file editing process :


Make sure everything is working as it should :
Now you’ve done almost everyting required to make your own wow private server … now before started playing it you need to make sure that everything is okay before starting to connect to your own server
Here’s how it is done :
And now here’s the screenshot if your mangosd and realmd process is working as it should :


The last step for configuring mangos and wow, editing the Realmlist used by WoW to connect :
After everything is okay, now there’s one more thing left for you to do … which is editing the realmlist.wtf file inside your WoW Game directory (C:\Program Files\World of Warcraft\realmlist.wtf) using your favorite text editor. You can use notepad or wordpad to do this
The default realmlist.wtf file should be like this :
set realmlist us.logon.worldofwarcraft.com
and then change it into
set realmlist 127.0.0.1
Creating Test Account for yourself :
Okay now you’ve created and set up everything but there’s still one more thing left and that is creating a test account with normal player status for yourself. And this process is really simple actually all you have to do is just typing this on the mangosd window (above image)
create desired_username desired_password
Okay that’s it you just created a test account that can be used to connect to your own wow server. If you get error message and / or stuck at realm loop i’m sure there’s something wrong with your configuration or you’re not using compatible mangos / wow client
That’s all for this part … stay tune for the next part ;)
As a side note, this is the first time i’m using lots of images on my guides and i’m looking forward to your opinion about this (tell me if you like it this way or would you prefer text with few screenshot or images) :)
Update :
To those who’s still having problem with Mangos like finding the correct mangos version,etc. I’ve decided to upload my own compiled Mangos Revision 4431 with Scriptdev2 241, and also included DBC Extractor (Thanks to XLayer for his DBC Extractor) and VMaps Extractor. And also mirrored the SDB 0.7.3 with Changesets 208 from http://opensvn.csie.org/NewSDB
And here’s the file :
Another Update : See my new post about new Mangos 4488 Update with Silvermoon Database … and tested with WoW 2.1.3 Client … just look at the screenshot below
All you have to do (i assume you’ve completed all of the steps involving mysql installation, and also already extract the DBC and VMaps files) is just :
1. Import / Overwrite the database with this new SDB (if you want the easiest way to start all over again from the Importing SDB step, you can execute the create-database.sql inside my Mangos 4431 archive (in reaper-sql directory) using this command :
mysql -u root -p < create-database.sql
mysql -u root -p -D mangos < SDB_0.7.3_Changeset_208_Rev1.sql
mysql -u root -p -D mangos < reaper4431.sql
Note : Make sure you’re in the same directory as the create-database.sql and the SDB_0.7.3.sql when executing that command
2. And then the next step is, importing the sql files inside the scriptdev2-sql directory (2 files) like below example (must be in order) :
mysql -u root -p -D mangos < scriptdev_full.sql
mysql -u root -p -D mangos < scriptdev_additional_req.sql
And you’re done :)
Perhaps the above might sound confusing for some people, so if you need help just leave comment here
Here’s a screenshot taken using Mangos 4488 Scriptdev2 134


Leave a response
Hi, ad.exe doesn’t work on GERMAN system … MPQ-data is stored under .\data\deDE … tryed copying it to .\data and then using ad.exe … NO USE … program quitting with following error:
error opening patch-2.mpq
error opening terrain.mpq
error opening dbc.mpq
Assertion failed in dbcfile.cpp Line 17
HELP please … what’s wrong?
MySQL installed and configured fine, and MPQE seemed to run alright, but ad.exe wont run correctly. I am also getting some other odd prompts. I am willing to do a direct connect if you are. Please help me out. Thank you.
where do i find the ad.exe file???
nvrmnd i went yous forums and found teh answer
i need some help, i got everything to work up to the point where i have to run the mangosd.exe file but the window wont stay open… any pointers on how to fix it???
my mangos and realms all work and connect theyre at revision 5953 the client is patched to 2.4.2 but everything works tell i get to the character creation window and its says “Logging on to game server” and it keeps bouncing between realmlist selection and the lil window saying “Logging on to game server”. would you please point me in the right direction to fix this?
hey ive followed your guide thru the mysql, it worked with no issues, however now im getting an error with the ad.exe, and im kinda stuck. If you would be willing, a remote connection would be great, I don’t want to mess anything up. also i noticed your links for the TBC server tools were unusable, this was the type of server i was hoping to create, is it possible? my email is insomniak07@yahoo.com if you need to reach me, thanks :]
Do you have a link to the latest warcraft classic server using the 2.2.3 patch? I mean one with all the improvements and updates available. I’m playing with a later WOW version of yours, and it’s great, but I want to play classic wow.
I have to get someone help me set it up, so if it is all in one package, it would help.
Thanks a lot.
Dude everything worked fin until i had to Run the sql query from the command prompt like you showed, it says that mysql is not reconised as an internal or external comand, operable program or batch file, what is wrong? psl hellp me… can you cintact me via mail?
the ad.exe file had an error when i ran it
# Dacu
I believe that you’ll need a windows machine for that process (extracting the DBC files)
# Ryan
Ah … you’ll need to execute the mysql command :)
# Bowl
Try searching the filefront website to search for WoW Patches
# Shadow
No problem ;)
And lastly … i’ve decided to close the comment form on this page, and that’s because the comments on this page are keep getting higher each day, so i think it’d be best to close it to reduce the server load and to prevent this page filesize keep getting higher and higher (surely no one are going to visit a page that is over 500Kb lol)
Thank you everyone for your comments, questions and help … and if you want to continue the discussion, you can continue it on the forums :)
Well reaper was right…That’s very embrassing to typed in the wrong path name for 2 days in a row. Well it works…hopefully I won’t get stuck in a realm loop. Thanks everyone! ^_^
I’m recently running 2.0.8, anyway to update the patches to a more recent version for ie. t6,BT,mercGlad, lootz ect?!?
Hey there…
Great guide, but I have a problem…
When I get to the part where I’m supposed to enter in all of the information in the CMD window…
I have no idea what to put in there…I’m trying to set up a TBC server…the Mangos i use is
“Mangos-4431-SD124.reaper-x”
Let me know if you can help =]
can anyone point me to a dbc extractor for linux for mangos 0.7 ?
So I’m running this all fine, I’ve made a few characters and tried some stuff out. My only problem is that I seem to be missing functionality when in-game. For example: When I tele to gmisland or programer island there’s no npc’s there, which I’m led to understand there are supposed to be. Also, when I’m in the exodar the guards wont give directions, they just say greetings. I’m wondering if I screwed something up, or I’m missing some data files or something. I get no errors when I boot mangos or realmd, and the game seems to run fine other than these little functionality probs.
# Trolking
Wait you lost me there. Open mysql window? I don’t remember there being one.
Only realmd and mangosd. Are you refering to writing something in command prompt?
Could you be more specific? :D
Thanks in advance.
# brynjarg
Try this, open mysql window and at the promt type:
use realmd
See if that helps.
# shadow
Im actually at work I’ll check your image tonight and see if i can help. You seem to have the same problem i had. But to answer the second part of your post yes, mine is working.
# Trolking
Thanks a lot Trolking :)
# Shadow
Lol .. actually the path you’ve set in your mangosd.conf is different than the actual path where the actual maps file can be found
from your screenshot :
You’ve configured mangos to look for the maps at :
D:\World of Warcraft\Data\maps (left image)
while the actual maps path from your screenshot is at :
D:\Program Files\Private Server\data\maps (right image)
http://i142.photobucket.com/albums/r102/ShadowDemon762000/errorofhell.jpg Used it…and still got it. I see the file there…but I don’t know whats going on. So should I just find somones 2.1.3 maps and use those? And does the mangos 4431 reaper upload works for that kind of server?
alright I got the ad.exe from johns link, I’m using all of the files the reaper has gave us under this update section and follow step by step. And my client is patched up to 2.1.3 right now. Hopefully this will work.