This guide will help you making your very own MaNGOS private server for World of Warcraft patch 2.4.3 (8606)
You will only success if you follow each step very good, and give yourself time to read the guide.
1) MySQL
a. Download & Install MySQL Server 5.1.
b. Configure MySQL and remember the password you made for it.
c. Done with that
2) SQLyog
a. Download & Install SQLyog Enterprise.
b. Run SQLyog and click on "New..." -and call it what you want.
c. Fill the formula like this:
d. Now click on Connect.MySQL host address - 127.0.0.1
Username - root
Password - The password you made in MySQL
Port - 3306
Database(s) - Leave this blank!
e. Right click on "root@ 127.0.0.1" to the left, and click on "Create Database...". Create 4 databases called mangos, characters, realmd and scriptdev2.
f. Quit SQLyog.
3) MaNGOS & PSDB
a. Download and extract it to your desktop with WinRAR.
b. Open MaNGOS 2.4.3 folder, and go to "SQL"-folder.
c. Run PSDB_Installer.bat and fill in the informations, and let it install the databases.
d. Go back to the main folder and open mangosd.conf with notepad, and fill the following informations:
And then save it and close it.LoginDatabaseInfo = "127.0.0.1;3306;root;MySQL Password;realmd"
WorldDatabaseInfo = "127.0.0.1;3306;root;MySQL Password;mangos"
CharacterDatabaseInfo = "127.0.0.1;3306;root;MySQL Password;characters"
e. Open realmd.conf with notepad and fill these informations:
And then save it and close it.LoginDatabaseInfo = "127.0.0.1;3306;root;MySQL Password;realmd"
f. Open scriptdev2.conf with notepad and fill following:
Save it and close it.ScriptDev2DatabaseInfo = "127.0.0.1;3306;root;MySQL Password;scriptdev2"
4) DBC/MAPS/VMAPS - Final
a. To get the map files, you'll have to use the ad.exe from "MaNGOS 2.4.3/SQL/Tools/Map_Extractor". Then go to your World of Warcraft installation folder, and create a folder named "maps". Copy the ad.exe to the WoW folder, and let it run till it's done! When it's done, take the "maps" folder to your MaNGOS folder.
b. Now you will need the DBC files. You'll find the extractors in "MaNGOS 2.4.3/SQL/Tools/DBC_Extractor". Place MPQE.exe, SFmpq.dll, and the appropriate .cmd file for your locale in the World of Warcraft\data\[your locale]\ folder and then run the .cmd file. Once it is finished, you will have a dbc/ folder which can be moved into your main MaNGOS folder.
c. You're almost done, and you just need the VMaps. Go to "MaNGOS 2.4.3/SQL/Tools/VMap_Extractor", run the makevmaps_SIMPLE.bat, and wait till it's done. Then take the VMap folder(s) to the main MaNGOS folder.
That's all! Works perfectly for me, and I do hope it will for you too. If you have any questions, please post 'em here, or pm me. I'll help you as much as possible!