SQLyog realmlist files missing?

[dragon_hacker]

Hi, I'm trying (pitifully) to make a wow server, and many of the guides here don't talk much about running the SQLyog for the server. When ever I run my SQLyog I only have three things on the far left hand side: information_schema, mysql, and test. I do not have the "realm" (Might be misspelled) tab that allows me to edit my server. What do I need to get that? The guids basically say you get that when you download SQLog... Any help would be appreciated.

P.S. Once you do get all your files, how do you use SQLog to run/log on to the server?

[Gastricpenguin]

SQLyog doesn't "run" your server. It is another MYSQLGui so you can edit the mysql database. When you install SQLyog, your databases won't magically appear. You need to create them and import databases into it. Then you will be able to edit your mysql data.

[dragon_hacker]

Okay, how do I import the databases in to it. Theses are the things that the guides leave out.

[dragon_hacker]

Well, thanks for posting anyways...

[jay77]

Firstly, you have to compile your own server. MySQL runs your database. You have to import your database like Gastricpenguin said, that would be done by (for world) getting a database, for arcemu i recommend squireDB. for aspire I really don't know. and trinity and mangos I know UDB is really good. The logon and character database is found in the SVN of the core that you have, in the trunk, into the "sql" folder, and you will find the structure and updates for character, logon, and world. Depending on what core your running, I can't really help much further, let me know what core, and revision, and I'll see what I can do...
P.S. I know like nothing about mangos and trinity.

P.S.S. +Rep is a better way to thank someone, hehe.

[The-Eradicator]

You just right click and select "Create new database". Then select Import -> Import from SQL dump and select your .SQL files.