[HELP] ArcEmu 2.3.4 DATABASE HELP!

[comet2500]

I have done everything, and when it's time to run the sql scripts... When I open up arcemu-logonserver it says, connection error, database 'characters' is unknown..

Than when I try to open up arcemu-world, and it says, connection error, database unknown, 'arcemu..'.

When I go into the config folder, and edit the database name, it then shows for logonserver that it connects, but says no database selected.

For world, I delete both of the names.. and then when I retry opening it it goes all the way down, and then shows no database selected.. and then keeps retrying to connect.

PLEASE HELP!

[kreegoth]

post configs...

[comet2500]

Configs? What do you mean..

Just the normal, arcemu-logonserver, arcemu-world.

IT SEEMS I MIGHT NEED DATABASE FILES! BUT I DON'T KNOW WHERE TO GET IT!

Error/Configs over look..


arcemu-logonserver:
username:
Password:
name: [CHARACTERS] <---- but works if blank, but isn't suppose to be blank.

arcemu-world
username: password: , name: Arcemu <---- can't be blank, but this says unknown.
username: password: , name: characters <--- can't be blank, but this also says unknown.

[XxXxVeLoCiTyXxXx]

did you install MySQL and set up the databases?

[comet2500]

What do you mean did I install mysql? I have heidisql, and mysql 5.0. I am not sure what you mean by the database though.. I didn't touch database, so I think I need a little help on how to do so.

[XxXxVeLoCiTyXxXx]

DatabaseSetup – Arc Emulator – Trac

[XxXxVeLoCiTyXxXx]

after you read that, if you can get it to work, send me your conf files, cause im pretty much stuck with the problem i have

[comet2500]

So what do I do?

Importing Databases? I don't really understand how to, maybe can you make a little guide!

[XxXxVeLoCiTyXxXx]

get SQLyog from that link, then after you install it, there will be a thing that comes up to make a new connection, so make the new connection with the password you specified when you installed MySQL, then make 3 databases, called k_logon, k_character, and k_world. after that, make a new connection, but for the databases to include, put "k_world;k_character;k_logon". select the k_logon database, then go to file, then open and navigate to arcemu/source/trunk/sql, then open k_logon, then press the little green arrow that says "run query". next select k_character and go to file, then open, and open k_character, and do the same thing you did w/ k_logon, and repeat the process for k_world

[comet2500]

Well, I am using Heidi Sql? Is that ok..

Also, I am using hamachi to make it, and I added the databases and then now I am stuck..

[XxXxVeLoCiTyXxXx]

well idk how to do it in heidi sql, so just do it the way i told you lol. afterwards, you can uninstall SQLyog if you want

[comet2500]

I installed it, but I can't find Arc/Sql

[XxXxVeLoCiTyXxXx]

its arc/source/trunk/sql

[comet2500]

I know, I can't find arc/source/trunk/sql.

Where is it located, in the sqlyog, or arcemu folder?

[XxXxVeLoCiTyXxXx]

arcemu folder