New to EQEmu

[Glyph485]

Howdy, I'm new to creating the EQEmu server and I've done my best to get it going by myself but i've still got a couple specific questions. I'm on the SQL/Sourcing portion of the build, i've been following the "Latest" guide: http://www.eqemulator.net/wiki/wikka...ide#SQLUpdates

First problem: I can't seem to run mysql from any location like it's part of the shell. Namely, I run a command prompt from C:\EQ\SQL and typing in mysql does not run it, I get an error saying it is not a command. To get around this i've copied all of the SQL files into the bin folder of mysql which seems to work.

peqbeta_2014-xxxxxx.sql is the main database right? How do you know if you need the updates that are listed with revision numbers since the newer things seem to be organized via date rather than rev number.

When I attempt to source alot of files I get errors like "Table 'peq.aa_effects' doesn't exist. This sounds important, and a search on these boards hasn't resulted in anything. Anybody know what I'm doing wrong or if this is a problem?

Thanks in advance~

[moofta]

First issue: you didn't tick the box to add MySQL to your PATH.

1. Find where your mysql.exe is, and copy the location from windows explorer (mine is in "C:\Program Files\MySQL\MySQL Server 5.7\bin"
2. Right click on "Computer" then select properties (I'm assuming you are using Win7).
3. Click on "Advanced System Settings" on the left
4. Click on "Environment Variables"
5. Under System variables, find "Path", click on it and select edit.
6. At the end of the variable value add a ; then paste the path you copied earlier.
7. Click on OK twice.
8. Now either log out or reboot (may as well reboot).

Second issue:
I had this problem too. It looks like the peq daily database actually misses a ton of the scripts needed to set up the eqemu database. What I did was get the old link (that says don't use this database!) and copied all the player scripts etc, then sourced those. Not sure why the required SQL tables aren't included in the source code.

I'm also a newbie so hopefully someone will fill us in

[Glyph485]

Thanks Moofta, Do you have a server currently up and running?

I actually got to the point where my server gets up, but when I try to create a character on it, it disconnects me and the status tells me I am missing a table in my PEQ database :/

[Glyph485]

I'm rather confused as to which *.sql files need to be sourced into my peq database at this point. The latest PEQBETA doesn't have a revision number and all the latest guide description stuff still refers to the rev #.

Can someone please enlighten me as to what *.sql files will need to be sourced into peq database after the peqbeta_YYYY-mm-dd is added?