[QUESTION] Ports for a wow server

[Смердокрыл]

Just create 3 additional database in your current MySQL server and name them like
realmname_auth, realmname_char, realmname_world

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.

[Смердокрыл]

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.

[Смердокрыл]

I thought the databases are somehow created when I run denwer...

[Смердокрыл]

I tried to add the 2 to the names of the folders in usr/local/mysql-5.5 but still, no additional databases are created and the "run" and "stop" files from any server affect all the servers.

[Amaroth]

Idk what is "denwer".

Why should be databases made "just by themselves"? How would that possibly work while MySQL really is not just made for TC2, it is database server used by... whoever you can imagine... Do you think that shops use auth, characters and world database? Ofc nope . They are made by create script which is being downloaded with TC2 core and which is being executed during database installation.




I suppose that actually reading something about MySQL would help you before you start to run multiple realms and such things.

[Magnus]

I suppose that actually reading something about MySQL would help you before you start to run multiple realms and such things.

That's really the best hint to give :-)

Seriously, if you are really running 2 different mysql servers, stop that and deinstall one. IMHO there is only one reason to run different mysql servers and this is if you need for some reason servers with different versions. F. ex. for old software or for developing.
May the best thing is to deinstall both and make a proper installation of exactly 1 server. (Before backup data if necessary)

Than install the 3 databases for TC server ONE and 3 databases with different name for TC server TWO. Put the correct database names in the config files. The mysql port will be for all the mysql default port 3306.

Personally I always install together with a mysql server also apache/php/mysqladmin. It's quite nice to work with mysqladmin sometimes as an alternative to SQLyog. Additionally you can write very easy some scripts in php for modifying stuff in your databases or create some custom interfaces. However you have to read and learn such trivial things by reading tutorials in the internet.

[Смердокрыл]

Idk what is "denwer"

This is in russian, but you can use automatic translation (in google chrome for sure): www.denwer.ru/
If you download a pre compilled server from any russian website (which is what I do, since I cannot compile a server myself due to 1)the process being very complicated 2)only 3.5.5 and WoD files available for download on trinity core website), this tool is gonna be in there.

[Magnus]

Seems to be a classical WAMP package. As I told. With Apache/PHP/mysqladmin and so on.

Hope it is virus free ;-)

Beside of that: You don't need to compile a mysql server. There are also binaries to download:
https://dev.mysql.com/downloads/mysql/

Just be sure that you have only 1 mysql server installed at the end.

As far as I know TC has a very detailed wiki with a lot of links too. Follow exactly the step by step installation guide.
http://collab.kpsn.org/display/tc/TrinityCore+Home

[Смердокрыл]

Anyway, I figured it out. Thanks Amaroth, Saifi0102, and Magnus for your help!


P.S. If anyone of you knows how to work with FuTa, could you please help me a bit more?)
viewtopic.php?f=10&t=9732

[Смердокрыл]

Oh, no, I didnt figure it out. I now have the databases appear in the connection, but when I try to open one it tells me e.g. "table 'auth2.realmlist' doesnt exist"

===============================================
Nvm, fixed it

[Magnus]

But you have imported the data and table structures from Trinity ?

[Amaroth]

Oh my. Precompiled repack.

Toss that into garbage bin and learn how2trinity and how2mysql . At least one day do so. By actually compiling emu and installing all needed things by yourself, like MySQL databases and so on you will learn quite a lot. And knowledge is the biggest power you can have while modding. Until then I can imagine that most of things I wrote didn't make any sense to you. Well, its still great that you have finally made it, let us know if there is anything more.