Forum > Serverside Modding

[QUESTION] Ports for a wow server

<< < (4/14) > >>

Смердокрыл:

--- Quote from: "saifi0102" ---Just create 3 additional database in your current MySQL server and name them like
realmname_auth, realmname_char, realmname_world
--- End quote ---
But what about all the "world" stuff like items, npcs, etc? They should not be same on the two servers.

Amaroth:
And they won't.

Server1 will have (for instance):
auth1
characters1
world1

Server2 will have (for instance):
auth2
characters2
world2

All those 6 databases will be on 1 MySQL server, yes, but that doesn't matter, because server 1 will be using only databases with 1 and server 2 will be using only databases with 2. So whatever you change in world2 database will NOT be changed in world1 database (unless you copy your changes) and thus it won't affect server 1 in any way. So there is really absolutely no need of 2 MySQL servers.

Смердокрыл:
Thanks for explanation, now I understand fully. Questions now: 1)How do I tell denwer to create the "...2" databases? 2)In order for the 2nd server to have a different realm name, I need to change it in Auth2/realmlist, right?

Amaroth:
Well, I use SQLYog for managing my databases, creating backups, importing/exporting SQL dumps and so on. In SQLYog, you just need to right click into blank place in database tree, select Create Database (ctrl+D btw) and there you go.

Fill in name you wish to give to database, charset utf8 and collation utf8_general_ci always worked for me and is used by TC2 by default. Using another settings might sometimes not work properly, but I am not sure about that. Then you will just need to fill that database, so you will most likely import new blizzlike TC2 database. Or you can copy old databases to new ones, so you will have 3 pairs of same databases, but you can modify any of those pairs without modifying 2nd one.

Process would be similiar in any other MySQL editor, if you don't want to use SQLYog.

Смердокрыл:

--- Quote from: "Amaroth" ---Well, I use SQLYog for managing my databases, creating backups, importing/exporting SQL dumps and so on. In SQLYog, you just need to right click into blank place in database tree, select Create Database (ctrl+D btw) and there you go.

Fill in name you wish to give to database, charset utf8 and collation utf8_general_ci always worked for me and is used by TC2 by default. Using another settings might sometimes not work properly, but I am not sure about that. Then you will just need to fill that database, so you will most likely import new blizzlike TC2 database. Or you can copy old databases to new ones, so you will have 3 pairs of same databases, but you can modify any of those pairs without modifying 2nd one.

Process would be similiar in any other MySQL editor, if you don't want to use SQLYog.
--- End quote ---

Navigation

[0] Message Index

[#] Next page

[*] Previous page