Need Database Help!

[earnheart1]

k so i wana make a new realm and like i got the realm up but it has all the same chars as my first one... SO how do i copy the database called "world" to my new database called "world2" and make everything work with eachother?

[Willzy]

First of all, what core and DB program are you using?

[earnheart1]

whydb and arcemu and mySQL

[mercdragon]

if you are useing navicat for your db. first click on your world db til it lights green. then right click on it and dump sql file to some where on server. once thats all done click on world2 til lit up green then right click hit execute sql file and find the file you dumped and start it.

[Link_S]

Or if you use SQLyog you're able to copy the data without the hassle of to store the data then load it again.

[Zymus]

Or couldn't you also just add another field to the user table dictating which realm the player is restricted to? that way you don't have to take up teice the amount of space, and all you have to do is edit the DB queries to say like "SELECT * FROM characters WHERE username='%s' AND realm=%d', "someusername", 0;