make 2 realm on 1 server

[perryhiggins]

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 [COLOR=#0066CC ! important][COLOR=#0066CC ! important]database[/color][/color] 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 [COLOR=#0066CC ! important][COLOR=#0066CC ! important]security[/color][/color] (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

[praxsas]

nice guide need test some day

[jackdaripper]

Drop mangose and go Ascent....

[daser]

LOL ..... thx man +Rep ... i reeally nead that

[visitor]

Drop mangose and go Ascent....

ascent is a sh!t:yuck:... on ascent almost every hack is working with wpe and ce. not too much hacks working on mangos (i know only one hack that is working on mangos and that is the no cooldown hack... i tested it ).
we love MaNGOS

[Lakimen]

hehe:wave:

[Pettso]

Nice, Ill try that

[Dythzer]

Just so you know.. revision 4602 is very old. Latest is 6170+

Anyway.. I haven't read the guide but I guess it's good so +2 rep for you

[perryhiggins]

Im Glad u liked it

[Dmester]

I can not see the Images.
I donth understand it without the images..

[zoidberg891]

nice guide +rep x2

[wowessence]

I seen this same guide on another site, not sure if you jacked it from someone else or if they jacked it but yea i seen this on another site. Either way its a good guide.

[f1racer328]

I was wondering how to do this. Im going t do it on my Mac now.

[Ollox]

ey can anyone help me? i got a problem everything works clean but i want to make 2 realms use same database cus i have an internet server and a LAN server i want to use same things how?!

[Ryma]

Nice guide +Rep