Just a dumb question

[DaemonCantor]

I would like to know why we all have a copy of the full WoW database files in our server directory and not use them, I do know that the server has to store some info for on the fly use but wouldn't be better to decrypt and send the way Blizzard does it and cut the mysql db into a quarter of it's size?

I'm just trying to wrap my head around all of this so that I can learn and maybe help in some way other than just thank you's and what the heck did I do wrong post's.

[Patman128]

I would like to know why we all have a copy of the full WoW database files in our server directory and not use them, I do know that the server has to store some info for on the fly use but wouldn't be better to decrypt and send the way Blizzard does it and cut the mysql db into a quarter of it's size?

I'm just trying to wrap my head around all of this so that I can learn and maybe help in some way other than just thank you's and what the heck did I do wrong post's.

...what? :huh:

[yasuno]

You mean base almost everything from the dbc cache files, and only a little bit from a actual db?

[DaemonCantor]

You mean base almost everything from the dbc cache files, and only a little bit from a actual db?

The last time I talked with one of the real live people who work in Blizz Development, they let slip that everything needed to run the game except a server core was in the Client's copies and all they ran was a DB parser with a few scripts. I can believe this due to the fact that I had to extract the database they were talking about just to fire up the server in the first place. Now you can understand my confusion and don't get me wrong I do think what has been made is far more than I ever could imagine or do on my own...

[darkstalker]

dbc info is incomplete (and sometimes wrong), it doesnt contain everything, things like creature spawns arent in the dbc

[DaemonCantor]

Thank you I can understand that....ok so we're using an sql DB to augment whats missing that make sence, and also answers the question of why Blizzard seems to use so many scripts when I look at info on wowhead and other sites simular.

[Zayfox]

What you need to remember is that Blizzard's retail servers are a corporate project. While we're close, MaNGOS is definitely not the exact same as Blizzard's servers, and of course isn't corporate with funding in the ten-thousands.

The 'caching' of data that the Blzzard's database does would be all okay, but the constant transmission of encrypted data when we could already have it on board the server would result in a massive bandwidth usage increase.

In a nutshell, if you're having issues with MySQL database sizes, you may want to look at purchasing a bigger hard-disk.