Problem with loading server

[maya6man24]

Im using mysql 5.5 maybe I should try another version?

[chrismed0]

I installed Wamp which comes with MySQL 5.5, PHP, and Apache (The apache and PHP I'm using for PEQ Editor) and so far it works great with 5.5.

Are you using Windows 7?
Make sure you have the most current PEQDB files. Mine was Rev2214 I think.

I placed mine in a folder on my desktop.
If your using windows 7 you can "hold shift" then right click on the folder then click on Command prompt. That will open you command prompt on that folder. In the command prompt type this:

mysql -uroot -p

you will see MqSQL start up and ask for a "password:"
Enter your password then you will see this:

mysql>

Then type your peq database name like this:

mysql> use peq

Then it should say changed to peq or using peq or something like that.

then:

source peqdb_rev2214.sql

then

source load_player.sql

and/if

load_bots.sql

the rest are the update files in your "EQEmu\util\sql" folder
any of the numbers higher then your rev are updates and you can use you 3rd party program to source them in real fast. Also check out Navicat. I tend to use it more then Heidi though I use both of them I like Navicat much better.

I didn't use the Bot release so never sourced it in. and also make sure the peqdb_rev sql file is in the same folder as the other sql files you just downloaded.

as long as you have the most resent things you shouldn't have a problem.

[maya6man24]

thanks will try that again. Just found this people have had the same problem.
http://www.eqemulator.org/forums/showthread.php?t=29784

Before you sourced the load_player.sql did you open the file and set the correct file paths?

By default it will look something like this:

source player_tables/aa_timers.sql;
source player_tables/account.sql;
source player_tables/account_ip.sql;
source player_tables/account_rewards.sql;


But in order for it to work it should look similar to this:

source C:/Temp/player_tables/aa_timers.sql;
source C:/Temp/player_tables/account.sql;
source C:/Temp/player_tables/account_ip.sql;
source C:/Temp/player_tables/account_rewards.sql;

and i did this but still will not work for me.

[maya6man24]

I changed load_player back to source/player_tables and did the shift right click thing and it worked, thanks, but gave an error on loading the bots but thats ok, more worried about getting the server up and running first. Now to try to run it and see what happens.

[chrismed0]

Nope with the most resent rev of the peqdb I didn't have to change anything. I don't know about the bots sql, didn't use it.

But the players sql and the actual rev I never had a prob on at all. I have tweeked my db so many time in the last week getting the way I want it or tring different things that I have had to source / back it up several times. never with any problems.

very important to be in the same directory as your sql files when you open your command prompt and start mysql.

[maya6man24]

getting zone: dynamic_01 reported state start then stopped over and over again. wont go past that first zone, I used 2214 db.

[chrismed0]

Don't know what to tell you then. I did tweek my stuff once and had to redo parts of it. I forgot to do something but I can't remember and I kept getting the stop / start state over and over....
It had to do witht he DB to.. sorry, just can't remember what it was but I did figure it out.. and it was a DOH moment. Palm to forehead. I just wish I knoew what to tell ya.

[maya6man24]

Thank you for your help you have been very helpful, going to fiddle with it some more maybe start over and try that. Thank you.