i need help my servers link up when i use this way help plz how can i run 2 realms
I use Navicat for my DB viewer. What I figured out is:
When you create a new connection for your database, you use that connection for all added realms. You make a Database called world and one called logon or whatever names you decide to use. Then create more databases in that same connection with names like world1 and logon1. You can keep creating added databases like world3 and logon 3.. all you have to do then is link eack database name to the corrosponding config files.\
Code:
<LogonDatabase Hostname = "localhost"
Username = "root"
Password = "root"
Name = "logon"
Port = "3306"
Type = "1">
Code:
<LogonDatabase Hostname = "localhost"
Username = "root"
Password = "root"
Name = "logon1"
Port = "3306"
Type = "1">
Code:
<WorldDatabase Hostname = "localhost" Username = "root" Password = "root" Name = "world" Port = "3306" Type = "1">
<CharacterDatabase Hostname = "localhost" Username = "root" Password = "root" Name = "logon" Port = "3306" Type = "1">
Code:
<WorldDatabase Hostname = "localhost" Username = "root" Password = "root" Name = "world1" Port = "3306" Type = "1">
<CharacterDatabase Hostname = "localhost" Username = "root" Password = "root" Name = "logon1" Port = "3306" Type = "1">
Although You really only need one logon DB unless you need different logon databases or configurations.. I spent a good part of yesterday trying to figure this out. If you make a new connection along with the existing connection you already have and name the databases the same they over write each other.. Hope I explained this well enough to help anyone that doesnt understand databases and how they work..