[Guide] How To Merge You Main Database Into One

This guide will show you how to put your account database into your my database. This is my first guide so bare with me.

lets start....

1. make sure everythings turned off ie acct, msg, npc servers, mysql, and xamp or wamp.

2. Make a back-up of both your my and account databases(they are located in your mysql/data folder. copy and paste them some where else.

3. open the account folder Right-Click-select all. Right-Click-cut.

4. open the my folder, Right-Click-paste. click No To All.

5. open Accserver folder. and change AuthourizeDB.cfg, gameserver.cfg, and config.ini

config.ini should look like this

Code:

[System]
LOGINLISTENPORT   = 9958
POINTLISTENPORT = 9865
SERVER_FULL_DELAY_SECS   = 3000
SERVER_BUSY_DELAY_SECS   = 1000
SERVERNAME = TEST
LOGINNAME = root
PASSWORD = rufeng
SERVERIP = YOUR IP HERE
[Database]
DBHOSTNAME=127.0.0.1
DATABASENAME=my  <=only thing you need to change
DBUSER=root
DBPASSWORD=rufeng

6. AuthorizeDB.cfg should look like this if your using the Candy db.

Code:

 127.0.0.1 root rufeng my account name password id
count_stat server_name status
127.0.0.1 root 0aba5bef155bc40b my

:::change rufeng if this is ur not your mysql password:

if your useing a different db

Code:

127.0.0.1 root test my account name password id
count_stat server_name status
127.0.0.1 test 4871344843773d3d111 my

:::change test if this is ur not your mysql password:::

7. gameserver.cfg should look like this if using candy db.

Code:

600 1 127.0.0.1 root rufeng my

:::change rufeng if this is ur not your mysql password:::

if you using mannequin DB

Code:

800 1 127.0.0.1 root test my

:::change test if this is ur not your mysql password:::

8. run mysql, servers and xamp or wamp

there you go you should have only my and mysql databases. xD

THANKS ENJOY

hmm .. aq ase.. baik letak sekali ngn make server ..

ha'a . betol gak ..