[Guide]Running two Realms with different databases

**PsycoDisciples** · 01-24-2008

The basic principle of this is that each server must have its own port, otherwise they will be joined and conflict with each other. This creates an issue with characters not showing up, and more that you are unknowing of.
The point of having two MySQL databases is so you can customize one, and not the other, and people can choose which one to go on.

Declarations:
Server1 folder = The folder you have for your Cypack or other server already.
Server2 folder = The copy of the folder you will make in this guide.
Server1Database = The MySQL database you already have for your Cypack or other server.
Server2Database = A new, clean Cypack or other server database that you will create in this guide.
PUCLICIP = The IP that people use to connect to your server.
REALM1NAME = The name of you first Realm, which is your original one you have already.
REALM2NAME = The name of your new Realm that you will make in this guide.
PASSWORD = Your MySQL password.

Step One:
- Copy your server files and put them in another folder (I will call it Server2 in this guide). Then delete the logonserver.exe and logonserver.conf files.
- Create a new database in Navicat or called "accounts" (no "" of course ).
- Go into your Server1 folder and open up logonserver.conf.
- Change:
CODE
<LogonDatabase Hostname = "localhost"
Username = "root"
Password = "PASSWORD"
Name = "antrix"
Port = "3306"
Type = "1">

To:
CODE
<LogonDatabase Hostname = "localhost"
Username = "root"
Password = "PASSWORD"
Name = "accounts"
Port = "3306"
Type = "1">

Step Two:
- Create a new database in Navicat (I'll call it Server2Database in this guide).
- Set up Server2Database with a new copy of the Cypack database.
- Right click on the "accounts" table in Navicat in and click Dump SQL File. Save this somewhere you remember.
- Go into the "Accounts" database you created in step one, and right click on it and click Execute Batch File and choose the file you dumped just before. This should add the "accounts" table with all your accounts into it.
- Delete the "accounts" table from Server1Database and Server2Database.

Step Three:
- Login to your router, and navigate to where you open ports.
- Open the port 8130.
- Go into your Server2 folder and open Ascent.conf.
- Change:
CODE
<WorldDatabase Hostname = "localhost" Username = "root" Password = "PASSWORD" Name = "Server1Database" Port = "3306" Type = "1">
<CharacterDatabase Hostname = "localhost" Username = "root" Password = "PASSWORD" Name = "Server1Database" Port = "3306" Type = "1">

To:
CODE
<WorldDatabase Hostname = "localhost" Username = "root" Password = "PASSWORD" Name = "Server2Database" Port = "3306" Type = "1">
<CharacterDatabase Hostname = "localhost" Username = "root" Password = "PASSWORD" Name = "Server2Database" Port = "3306" Type = "1">
.
Change:
CODE
<Listen Host = "0.0.0.0"
WorldServerPort = "8129">

To:
CODE
<Listen Host = "0.0.0.0"
WorldServerPort = "8130">

- Go into your Server2 folder and open Realms.conf.
- Change:
CODE
<Realm1 Name = "REALM1NAME"
Address = "PUBLICIP:8129"
Icon = "PVP"
Colour = "1"
Population = "1.0"
TimeZone = "1">

To:
CODE
<Realm1 Name = "REALM2NAME"
Address = "PUBLICIP:8130"
Icon = "PVP"
Colour = "1"
Population = "1.0"
TimeZone = "1">

Step Four:
- Go to Server1 folder and start logonserver.exe and ascent.exe
- Once they are both fully done loading, go into your Server2 folder and start ascent.exe

Congratulations! You now have 2 seperate realms!

You can configure all your rates and stuff for one realm, and not the other. So one realm can be high-rate, and one lower-rate.

Credits to Robert .