Creating 2 Realmd in WoW Mangos Private Server

Reaper-X | Oct, 20 2007 89 Comments Related Posts Share RSS Feed

Some people have requested a guide on how to create or link their WoW Private server realmd so their users can choose whatever realmd they want to login to (for example, the first realmd is the PVP World, while the second realmd is to those who prefer normal world) :) … and that’s why i decided to create this guide, and hopefully it’ll be not confusing (i tried my best to make it easy to understand but you judge it by yourself) :)

So here goes the guide :

Requirements :

1. Basic knowledge about MySQL and know how to use MySQL Client program such as Navicat, SQLYog, or PHPMyadmin :)

2. Have lots of free memory / RAM left for best result (i’m using 3GB DDR2 Dual Channel RAM)

3. Mangos already worked and you can use it before trying to attempt this ;)

Note : Depending on which mangos revision you’re using the realmd column might be different (if you’re using my 4602 version then you can just use the same sql query as shown in this example)

also as a side note, you just need to have 1 account to login to each realmd, but it’ll use different data inside each database used

Here are the steps :

1. First make a copy of your mangos (or your mangos directory), so in the end you’ll get two mangos directory, in this example i was using my own compiled version 4617 (my latest version which is available for download for everyone is 4602)

2. Now you’ll need to create a new realmd id as shown on below image, and you can use below sql query if you’re using my 4602 release but if you’re using lower version, there are two option for you to choose : 1. Upgrade or 2. Adjust the column name accordingly

The above query will automatically assign REALMD ID 2 as it’s ID Number if you didn’t touch anything before in realmd table, and another thing to note is use different value for the WORLD Server PORT (in this example i’m using 8086

3. After finished with the above process, now of course you’ll need to create new Mangos Database first for your second realmd, and to do this we need to create a new database and then import the Mangos-UDB.sql file (if you’re using my 4602 release) or adjust it as necessary if you’re using another release, see below image for the example :

3.1 Creating New Mangos Database

or type mysqladmin -u root -p create database-name … if you can’t see the command used on above image

3.2 Importing Mangos DB

After finished creating new database for your second database, now you’ll need to import the fully working database from before into your newly created mangos database (if you’re using my 4602 release, the database name was called mangos-udb.sql and can be found in reaper-eazy-mangos folder)

4. Now you just need to go inside your second mangos directory which is created at step #1 and then open mangosd.conf inside that directory and search for this line :

RealmID = 1

and replace it with :

RealmID = 2

and then search for :

GameType = 1

replace it with :

GameType = 0

and now search for :

WorldDatabaseInfo = “127.0.0.1;3306;mangos;mangos;mangos”

and replace it with :

WorldDatabaseInfo = “127.0.0.1;3306;root;yourpassword;yoursecondmangosdatabasename”

lastly search for :

WorldServerPort = 8085

and replace it with :

WorldServerPort = 8086

The above step was done because the previous mangos user doesn’t have the privilege to touch that new database name so we need to use root that has global privilege (this is the most quickest and dirtiest way) :P

As a side note, it’d be better for you to create new username for your second database and grant privilege to it for better security (it’s not good to use root account) :)

5. Run the realmd.exe from any of your mangos directory (the first directory which was there before, or the new mangos directory which is created for this purpose), and then run mangosd.exe from the first directory and the second directory

So that result in three new process created … 1 realmd.exe, and 2 mangosd.exe from different directory

6. Now login with your previous username or create a new username and if you’ve done all of the above steps correctly you’ll see two realmd that you can use as shown on below image :

6.1 Realmd Selection Screen

6.2 The first Database With all the characters from before (i think you already saw my character for each screenshot used lol)

6.3 The Second Realmd which is used for this guide

That’s it … i hope you can understand the above explanation … and just like before, if i missed anything just let me know about it :)