Multiple Mysql servers

[OMGPWN]

Is there a way to have a MySql server set up for WOTLK server and a regular wow server.. cus when I try it deletes my database from wotlk and overwrites it with the regular wow dtabase cus there both running off the same mysql ><
If you understand what I mean please help. +reperz

[kaothic]

Yup only needed change the port from the 2nd server.

Put 3306 to 1st mysql server & 3307 to 2n mysql server.

But is more easy 1 mysql server with different DB, one for wotlk, another to login, another to characters and another to regular BC server.

[dejavu11]

Wouldn't it be better to simply change the name of the database used for one of the servers when you create it?

i.e.

world and world2

[OMGPWN]

If I make world 1 and world 2 they will appear on both accounts =P lol so there would be to DB on both but imma try teh port thin thank you and +rep if I havent givein to much today

"You have given out too much Reputation in the last 24 hours, try again later." will later

[Mr.Jebus Christ]

hmm ive never tryed but mabey make shorcut for mysql and hit propties and after the last " in the shorcut thing put -m

[bleachlizard]

When you go to install MySQL, you can install multiple instances of it. Just make sure the service names are different (ie, MySQL5_1 and MySQL5_2 or something like that) and the ports are different (ie, 3306 and 3307). When you go to login through your SQL client (like Navicat or SQLYog or something), just change the port to whatever SQL you want to log in to:

So, if you want to log in to MySQL5_1, then you'd put that to port 3306 (the default)
If you wanted to log in to MySQL5_2, then you'd put port 3307 in.

Then you can upload the DB's and change your world and logon servers accordingly.

I hope that helps. If you want more detailed instructions (including pictures), I'm working on a post right now just for this type of thing.

Cheers.