COMPLETE PUBLIC SERVER SETUP - Jan-2011

[pepsiphreak79]

im not trying to be rude just frustrating that some of the peopel really arent trying to help there just being negative saying your doing it wrong or refer to the walk through but they are not acually helping i did thank the one that acually offered some help ... and they act like we have all been here for ages ans should already know all this...
its kinda condasending and thats why i was negative

[trevius]

In a previous post in this thread, you said you were able to source all of the PEQ SQL without errors, but now you are getting errors when you try?

Are you following these 3 step exactly (accounting for the path difference where your PEQ files are located)?

13.First, go to your C-Drive and right click on the folder you made called peqdb
and choose "SVN Checkout"
In the "URL of repository" line copy and paste the following:
http://projecteqdb.googlecode.com/svn/trunk/peqdatabase (then click OK)
It will finish with "At Revision XX"

Next, go to that folder peqdb and unzip the file from peqdb_rev1751.sql.gz
to the same peqdb folder.
This file will be named peqdb_rev1751.sql (without the .gz)

***NOTE***
The "rev1751" was the most current at the time of this writing. It may change over time.

14. Ok, now open up your Navicat Lite program that you installed.
On the upper left you will see Connection. Click on that and choose MySQL
A connection window will open. The only thing you really need to do is put your mysql
password in (make sure the "Save Password" is checked) and click OK.
This will create a connection with MySQL.
In the Connections window, you should now see localhost_3306 (Double click on that)
Then right click on that same name (localhost_3306) and choose New Database...
In the next window, in the first line, type peq (then click OK)
Close Navicat Lite.

15. NOW, you need to go in to a command prompt and navigate to the peqdb folder.
Simply type cd \peqdb and you should be there. You will see: C:\peqdb>_

REMEMBER THE PASSWORD YOU GAVE when you set up MySQL ? (You need it NOW)

***WARNING*** - at this point, make sure you are in the peqdb folder.

Type mysql -uroot -p
Hit enter and enter your password. (Hit enter again)
You should now see a prompt that looks like this: (along with "Welcome" text before it)
mysql>_

Type the following (in order):

use peq (Hit enter and you will see a short note saying "Database changed")

Then type the following:

source peqdb_rev1751.sql (when this is done, you will be back at the mysql>_ prompt)

Then type in the following:

source load_player.sql (this will load fast)

***WARNING*** - When you compiled your server, if you chose "ReleaseBots", you will now
need to type the following at the mysql prompt:

source load_bots.sql

Which ever you chose, you can now close the command window and work on the sql updates.

***WARNING*** - the sql updates ARE NOT in the peqdb folder, they are in the source
folder where you compiled your server, but you can use Navicat Lite to run the updates.

If you follow those 3 steps, your DB should be all set and you can move on to troubleshooting your next issue(s). If you are unable to understand exactly what to do at any part of those 3 steps, just ask specifically about the part you are unsure about.

If you don't know how to open a command prompt, you can do all of this fairly easily through Navicat and probably HeidiSQL as well. I don't use HeidiSQL, so I can't speak for how to do it there, but Navicat is similar I am sure and very simple. You just create a new database named "peq" (without the quotes). Then you double click that database to connect to it and right click on it. In that menu, you should see an option to Source the SQL (may not be worded exactly like that, but I am not at my desktop to verify right now). You then browse to the folder where your PEQ SQL files are located and run them in the order that the guide says to.

[lerxst2112]

Looks like Trevius beat me to the punch, but maybe this will help anyway.

You can do everything you need to from the command prompt and not have to worry about using a different tool to create the database. I remember when I originally tried to use SQLyog to source load_player.sql it failed because it doesn't set the current directory to where the file you're importing is so it couldn't find the player_tables directory.

I also show deleting the existing database just to be sure you are starting from scratch. It sounds like, from the issues you posted, that you may have had something leftover there causing a conflict.

Substitute whatever directory you have the peq files in for the first command. The blue text is what I typed. I didn't include all of the spam the source commands generate because it wouldn't be helpful. If you want to save all of the output to a file you can type tee output.txt as the first command at the mysql> prompt. The file will be saved in the directory you started MySQL from.

If you are not using bots then skip the source load_bots.sql command.

C:\>cd EQEmu\Database\peqdatabase

C:\EQEmu\Database\peqdatabase>dir
 Volume in drive C has no label.
 Volume Serial Number is 4A57-06FC

 Directory of C:\EQEmu\Database\peqdatabase

12/06/2011  03:11 AM    <DIR>          .
12/06/2011  03:11 AM    <DIR>          ..
10/04/2010  10:20 PM               564 drop_bots.sql
12/05/2011  07:55 PM             2,566 drop_player.sql
12/05/2011  07:55 PM             2,752 drop_system.sql
10/04/2010  10:20 PM               276 load_bots.sql
12/05/2011  07:55 PM             2,659 load_player.sql
12/05/2011  02:02 AM       169,453,496 peqdb_rev2083.sql
12/05/2011  07:55 PM        22,451,506 peqdb_rev2083.sql.gz
12/05/2011  07:55 PM    <DIR>          player_tables
10/04/2010  10:20 PM             1,586 readme.txt
12/05/2011  07:55 PM    <DIR>          updates
               8 File(s)    191,915,405 bytes
               4 Dir(s)  495,992,610,816 bytes free

C:\EQEmu\Database\peqdatabase>mysql -uroot -p
Enter password: *****
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 9
Server version: 5.0.91-community-nt MySQL Community Edition (GPL)

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> drop database peq;
Query OK, 151 rows affected (2.15 sec)

mysql> create database peq;
Query OK, 1 row affected (0.00 sec)

mysql> use peq
Database changed

mysql> source peqdb_rev2083.sql
mysql> source load_player.sql
mysql> source load_bots.sql
mysql> quit