1) Connect to HeidiSQL/Navicat/SQLyog and create 2 new databases, chr and world.
2) Import character and logon tables to chr database and world tables to world database. Which db to use? It's up to you.
3) Go to your server folder and copy Ascent folder. Name the copy as you like. In this tutorial, we shall call it testrealm.
4) Go to the testrealm folder, open your world config and search for
Code:<WorldDatabase Hostname = "127.0.0.1" Username = "root" Password = "ascent" Name = "world" Port = "3306" Type = "1"> <CharacterDatabase Hostname = "127.0.0.1" Username = "root" Password = "ascent" Name = "chr" Port = "3306" Type = "1">
Change the text in red to point at the new databases.
5) Scroll down a little bit until you find
Code:<Listen Host = "0.0.0.0" WorldServerPort = "8130">
Change WorldServerPort to 8130 or something else than 8129
6) Go to your logonserver config and find
Code:<LogonDatabase Hostname = "127.0.0.1" Username = "root" Password = "ascent" Name = "chr" Port = "3306" Type = "1">
Change the red text to point at the new character database.
7) Go to your realm config and find
Code:<Realm1 Name = "Test Realm" Address = "YOUR IP GOES HERE:8130" Icon = "Normal" Colour = "1" Population = "1.0" TimeZone = "1">
Change realm name, put your ip but don't delete port 8130
Close ascent-logonserver.conf, go to original ascent folder and start ascent-logonserver&ascent-world.exe
9) Go back to the testrealm folder and open your world.exe