
Originally Posted by
DeathNET
How would i make 2 realms with amber? i dont know much on sql so a step by step guide please!

first of all, what kind of 2 realms do you want?
2 different realms: 2 world databases, 2 character databases, 1 realmd?
or 2 world databases, 1 character database, 1 realmd database??
first of all, make a copy of the server folder, so you have 2 folders with the same server files..
for 2 world databases:
open navicat, go to the mangos database, double click on it to open the database, right click and choose the "write to SQL" or something sounds like it.
now right click on the top at the name of the SQL database, and choose "make new database" and give it a name like: mangos2 or other.
if you want to have 2 character databases do the same thing as mangos but now with the character database, or if you want to have a clear character database extract a clean characters.SQL of UDB www.udbforums.com.
now open the realmd database, click on the realmlist and click on the + button down to add a line, fill the name, ipaddress, etc. for the second realm..
now go to the folder of the server which one you've copied.
open the mangos.conf file and edit the lines:
Code:
RealmID = 1
DataDir = "."
LogsDir = ""
LoginDatabaseInfo = "127.0.0.1;3306;root;mangos;realmd"
WorldDatabaseInfo = "127.0.0.1;3306;root;mangos;mangos"
CharacterDatabaseInfo = "127.0.0.1;3306;root;mangos;characters"
change them to
Code:
RealmID = 2
DataDir = "."
LogsDir = ""
LoginDatabaseInfo = "127.0.0.1;3306;root;mangos;realmd"
WorldDatabaseInfo = "127.0.0.1;3306;root;mangos;mangos2"
CharacterDatabaseInfo = "127.0.0.1;3306;root;mangos;characters2"
now you have to start the realmd.exe and mangos.exe of the first server folder and only the mangos.exe of the copied server folder.
Now you've running 2 mangos.exe and 1 realmd.exe
succes