EQEmulator Forums - Updated Windows Server Setup Guide

EQEmulator Forums (https://www.eqemulator.org/forums/index.php)

- Support::Windows Servers (https://www.eqemulator.org/forums/forumdisplay.php?f=587)

- - Updated Windows Server Setup Guide (https://www.eqemulator.org/forums/showthread.php?t=29043)

In order to be able to source those files, make sure you are in the same folder as those files are located before you log into the mysql server. Or, if you have Navicat or something, you can just run them from the GUI.

someone should write a "SQL security for dummies using EQEMU" wiki and all wiki setup guides reference to it. :)

so the multitude of guides on thie site confuse me, as it seems like all of them tie together in some weird way, however i followed the steps on this guide and ended up with the error perl58.dll is missing.. i tried searching was there something i missed? the only thing im seeing is that i should have the other used version of perl but i followed this guide

While going through your Server Setup Guide, i ran into a major problem after completing the first part of step 3. Tried both command line, and query browser. Command line read something about an error, but disappeared instantly. Tried the Query Browser... had Server Host: 127.0.0.1 Port 3306, name: root, password: oogbar *Worked up until i tried utilizing the walkthrough step 3, for some reason*. Hit connect... aaaannnd... "Could not connect to the specified instance. *2 lines down* MySQL Error Number 2003 *next line down* Can't Connect to MySQL server on '127.0.0.1' (10061) *2 lines down* If you want to check the network connection, please click the Ping button." *Press Ping* "Pinging 127.0.0.1 *Line down* Reply from 127.0.0.1: Time = 0ms TTL = 128" any ideas on what went post-nuclear hari-kari?

Tried "mysql -root -p" from RUN.
Enter password: *enters any of a giant plethora of passwords*
ERROR 2003 (HY000): Can't connect to MySQL server on 'localhost' (10061) *Same as the last trillion messages, but at least the stupid RUN command box doesn't instantly disappear after i enter the password!!* ;shoots his compuker! *Oogbar shoots his compuker!*

Thanks Vales, great guide. I followed the guide exactly, except as follows:
Use ActivePerl-5.8.9.826-MSWin32-x86-290470.msi instead of the 5.10xxxx version. The 5.8.8 version will not work either.

Additionally, I changed the eqemu_config.xml as I want this to work on a private LAN without setting up a public IP or port forwarding, etc to allow access from outside. Here is my eqemu_config.xml file, v1. All seems to work for me now. so far...

Code:

<?xml version="1.0">

<server>

        <world>

                <shortname>Virgilhome</shortname>

                <longname>EQ@Virgilhome</longname>

                <address>172.16.0.25</address>

                <localaddress>172.16.0.25</localaddress>

                <loginserver>

                        <host>172.16.0.25</host>

                        <port>5998</port>

                        <account></account>

                        <password></password>

                </loginserver>

                <!-- Sets the shared key used by zone/launcher to connect to world -->

                <key>putsomethingorotherinhere</key>

        </world>

        <database>

                <host>localhost</host>

                <port>3306</port>

                <username>root</username>

                <password>mypassword</password>

                <db>peq</db>

        </database>

</server>

Ok... the magical solution for if you dont know your MySQL root password! *Though its a bit painful* Un-install all MySQL, Go to your compuker's search option, search for MySQL *Because uninstall leaves some stuff*, and delete the leftovers. Found this out by getting severely irritated with the program, and went on a deleting spree.

I think the default WAMP install uses the username 'root' and no password.

You can reset the root password for mysql by stopping mysql and restarting it using the following command:

Code:

mysqld --skip-grant-tables --skip-networking

This starts mysql without any security, hence disabling networking support.

You can then run the client, where you

Code:

use mysql;

and use standard SQL commands to reset your root password. Then stop mysql, and restart it normally.

This guide dosen't work..

I'm using rev1052 and the login server .bat file errors out - windows could not find 'world' or 'eqlaunch'... frustrating..

Quote:

Originally Posted by everlastnmn (Post 181894)

I'm using rev1052 and the login server .bat file errors out - windows could not find 'world' or 'eqlaunch'... frustrating..

I think you are missing the statement

c:
CD c:\[folder] the folder name will be where those files are located.

Seriously, can someone update this ? I have followed this word for word and it dosen't work. Specifically the .bat file. I tried the change directory as suggested above and still no dice.

this guide is missing alot of stuff. the one on the wikki is your best bet.

Quote:

Originally Posted by OpIeWoRkS (Post 180966)

I am trying this install but am stuck on step 4. When I try to source the database I get:
ERROR:
Failed to open file 'peqdb_rev1038.sql' , error: 2

Read in the post where someone was having same issue and figured it out but unfortunately didn't say what to do to fix problem. If anyone can help me I would really appreciate it.

I'm getting the same error. Did you manage to find a fix ?

After extracting the database the file shows a blue ? icon. BTW, It was extracted to the same folder as the other sql files, ie, C:\Program Files\mysql\bin\projecteqdb\peqdatabase

Any tips appreciated :)

once you extract the files you have to take all the sql files and put them in just the bin folder, they cant be in any sub directories. try that out

Fantastic mastajon ! worked like a charm :D

Now why on earth couldn't Vales server set-up guide explain that , I can't be the only person to trip-up on this bit :rolleyes:

Thanks again !

Thanks also to Vales , whom without the guide we would'nt even know where to start :)

Server runs great, it compiles, database appears to be working can play online and all that jazz but the LDoN (after doing the quest) and all that, the adventure recruiter still doesnt bring up any adventures, I noticed the Debug zone log file has this in it: Client::SendAdventureSelection(): NPC had no template id

This is using the latest PEQ database from the repository and I looked up the NPC and it's true all of the npc's have 0 set as template id ..

How are people getting the LDoN's working?

I don't know a lot about LDoN, but I believe the only ones currently implemented in the PEQ database are Mistmoore Catacombs. Those are available from Xyzelauna_Tu`Valzir in Butcherblock.

She is the only NPC with an Adventure_Template > 0 in my (few weeks old) copy of the database.

The topic is getting off-topic but..

I suggest you to take a look at: http://www.eqemulator.net/wiki/wikka...reSystemSample

Check your DB:
1. Each adventure has an adventure_templateID (id field) in the adventure_template table
2. You have to set adventure template entries (IDs) in the adventure_template_entry table and assign one ore more adventure_templateID to each one of them.
3. Assign the adventure template entry (ID) to the adventure recruiter of your choice in the npc_types table (adventure_template_id field)

The specific adventure recruiter will offer all the adventures (adventure_templateIDs) listed in the adventure_template_entry table and detailed/defined in the adventure_template table

So check your DB and make sure all set correctly.

Thats pretty much it.

Meh the jist of it is that the database isn't pre-set already apparently

Okay, I downloaded and running the following:
ActivePerl-5.10.0.1004-MSWin32-x86-287188
mysql-essential-5.1.42-win32
peqdb_rev1052.sql

I can login okay...I get to the server select and see my server, but have 2 problems:
1) I have "You have 0 of 0 expansions" displayed.
2) I fail to connect to my server with:
Error 1017: Cannot login to the EverQuest server. You may need to re-run the Update Patch. Repeatedly seeing this message indicates a lost of connectivity to the Patch Server. This is usually temporary.

When my eqhost file is pointing to my server and I have this problem, but when I change the file back to eqemulator.net:5998 everything works fine connecting to other servers.

I saw previous posts with similar problems and people posted that they fixed it, but didn't say how. Please help...this is driving me nuts.

1. you have 0 of 0 is correct .. as trevius told me that isn't important it will still let you log in.

2. unknown might check over ini files, check your port settings, wait for world to loaded up before login to server. or change your ports to 5998 and see if that helps.

just a word of advice when they do all winks they left out 2 important steps
1. php-5.3.1 php setup and config settings i got from cavedude site 80)
2. apache_2.2.14-win32-x86-no_ssl.msi
3. ActivePerl-5.10.1.1006-MSWin32-x86-291086.msi- i'm going to try running both perl's perl58.dll and perl510.dll don't forget to copy perl5.8.7.exe file and perl58.dll it should work on all clinet's now 80)

word of advice that don't make login server work so you can see the expanshion's that a whole new steps when i can reproduce what i did to get that working i'll post an update.

PEQ Editor Installation Guide for Dummies*
=============================
*This guide is in no way, shape, or form related to, or endorsed by the writers of other 'Dummies' books, nor am I calling you a dummy for using it... The name just sounded amusing
=============================
This guide assumes you already have MySQL and EQEmu Installed on your system. If you do not, please do that first.

-Install Apache 2.2.3 with all the default options. Set your server ip address to "localhost" without the quotes obviously.

When the installation is complete:
Click Start -> All Programs -> Apache HTTP Server 2.2.3 -> Control Apache Server -> Stop
this will stop the server from running.

-Install PHP 4.4.4 with a standard installation. I suggest using the default path of "C:\PHP" for the install directory. When Prompted, select "Apache" from the list of platforms. Ignore the message telling you that you need to manually configure apache... we know that already

-Once PHP4.4.4 is installed, browse to c:\php and create 2 new folders.
Folder 1 should be named "upload"
Folder 2 should be named "session"

-Create a new folder on your C: drive called "www"

-Extract the contents of the PEQ Editor 1.0 zip file to the new folder ('www')

-Click Start -> All Programs -> Apache HTTP Server 2.2.3 -> Configure Apache Server -> Edit the Apache httpd.conf Configuration File
If prompted to choose a program to open it with, select Wordpad (or notepad, but wordpad is usually easier to use).

At the top add the following (you may copy and paste it if you are lazy like me )

Code:

#PHP 4.4.4 config
ScriptAlias /php/ "C:/php/"
AddType application/x-httpd-php .php
Action application/x-httpd-php "/php/php.exe"

Now hit CTRL-F to open the find window and type in: ServerName

Make sure the line found looks like this:

Code:

ServerName localhost:80

If not, change it so it does.

Scroll down about 6 lines to where it says "DocumentRoot", make sure that line looks like this:

Code:

DocumentRoot "C:/www"

if not... fix it

Scroll down about 10 lines and you will see something to the extent of this, but not word for word...

Code:

<Directory />
Options FollowSymLinks ExecCGI
AllowOverride None
Order deny,allow
Deny from all
</Directory>

We want to replace it with the following:

Code:

<Directory />
Options All
AllowOverride None
Order allow,deny
Allow from all
</Directory>

Just copy/paste that over top of the existing block... you need it to be exactly the same as what I wrote.
Scroll down about another 10 lines and you will find:

Code:

<Directory "C:/www">
#bunch of commented lines starting with #
Options (bunch of options)
#bunch more commented lines
and more junk here and so on
</Directory>

Just highlight everything from the <Directory "C:/www"> to the </Directory> making sure to highlight both of those lines as well and paste the following over top:

Code:

<Directory "C:/www">
Options All
AllowOverride None
Order allow,deny
Allow from all
</Directory>

Doing that is somewhat redundant as far as apache is concerned, but in the event you ever mess around in .htaccess files or the config file later, you have less of a chance of screwing it up

-Now save the file and close wordpad.

-Browse to c:\php (where we installed php and made those 2 folders earlier)

-Open the file named "php.ini" using wordpad and hit CTRL-F to open the find window
Search for "session".

The highlighted line should say: session.save_path="C:\Documents and Settings\blahblahblah....\upload"
and the one above it should say something like: upload_tmp_dir="C:\Documents and Settings\blahblahblah....\session"

Anyone with 2 brain cells can see that someone at PHP pulled an oopsey when they set the default session folder to "upload" and vice versa. Although this won't actually make a difference in the performance of PHP/Apache it is somewhat amusing. Regardless, to keep things clean, we want to store our session data in the same folder as our php crap so change those 2 lines to:

Code:

upload_tmp_dir="c:/php/upload"
session.save_path="c:/php/session"

Now save the file, close wordpad.

Click Start -> All Programs -> Apache HTTP Server 2.2.3 -> Control Apache Server -> Start
This will restart the Apache Server

Click Start -> Run.
Type in "cmd" to open the command prompt window.
Type: cd\ (hit enter)
(any of you who actually typed (hit enter)... i really don't know how you made it this far lol)
you should now see: C:>
type: mysql -u root mysql -p
it will prompt you for your root password. this is whatever you set it as when you installed mysql.
once your password is accepted you will be in the mysql prompt, which looks like this: mysql>
Enter the following command

Code:

\. c:\www\sql\schema.sql

********************************
IF YOU ARE UPGRADING FROM AN OLD
VERSION YOU DO NOT NEED TO RUN
THE NEXT COMMAND!!!
********************************
Only for those who are doing a fresh install of PEQ Editor 1.0...
Enter the following command:

Code:

\. c:\www\sql\allspells.sql

Thats it ladies and gents. Open up Firefox or whatever web browser you use... and type the following address into your address bar:

Code:

localhost/index.php

The username and password should already be set for you. Just submit and have fun editing!

-Aerewen

Ok, i got 2 little Q's to ask, involving the guide, and what OS was used in its creation... #1 for Vale; what OS are you running? #2 for those who succeeded in creating a server; What OS are you running? I am running Windows XP home addition, and when i get to the part of running the "Run" program, that brings up a text base command thing, and type in the things the guide says to type in 'I.E. ipconfig, cod\peq_db *not even cod works, CMD perhaps?*, \u pew *everything till this point is peQ, where'd the W come from?*' it just goes to the next line, tabbed over, like "Wtf? meh... /ignore command" ... Could this be a difference in OS's, somehow incorrect following of instructions *despite ocd*, or maybe my usual luck with ONLY my stuff doing things that are far beyond even impossibly messed up?

well at the time i'm now running windows 7 ultimate, when i made that work was in windows nt 4.0 or windows xp pro it's all the same... when you type ipconfig you type it in the run command, if you want to really have fun with xp goto c:\windows\system32\ click on the icon gpedit click on administrative templates, network 80) if you understand a server your in luck now. alot of goodies in that program gpedit. if your going to setup a true server might want to use linux system for best results

since the W key is next to the Q key on a qwerty keyboard, I'm pretty sure that pew is just a typo for peq. Look at your keyboard (unless you are using dvorak).

I didn't understand instructions at #10 on how to use heidisql, so I used method suggested by this user:

Quote:

Originally Posted by spidey1170 (Post 175695)

I used a CL (command line) input into mysql for this:

Click on START, RUN and type CMD, this will pull up a command line interface

Next, type (without quotes): "mysql -u root -p"
Enter your password when prompted

Type "\u peq" and hit ENTER

Then you are able to type in the sql query, hit ENTER and it should work. Hope that helps =)...

I ended up with this error:
ERROR 1146 (42S02): Table 'peq.tblloginserveraccounts' doesn't exist
mysql>

Any input or advise would be greatly appreciated! :)

Eva Aising what Step 10 was telling you! if you saved the file EQEmuLoginServerDBInstall.sql copy and past it to C:\Program Files\HeidiSQL\data\peq

Quote:

Originally Posted by OscarGrouch05 (Post 184608)

copy and past it to C:\Program Files\HeidiSQL\data\peq

That folder does not exist on my computer, but thanks for trying to help! I just didn't know what a query was or why I was executing it and generally didn't know wtf was going on in heidi, but I understand now.

When I try to input the command into mysql prompt directly, I still get error stated in my post above. Heidisql reports that the row was affected and doesn't give me an error message. I assume that it worked just fine.

Whenever I use my start.bat, I almost immediately get a message saying that I cannot connect to login server. Error 10061. If anyone knows anything about dyndns or why I'm not able to connect to my own host server, please post here or send a PM to help. I have been searching for over a week now and can't get this working. I'm almost certain I completed the tutorial correctly and am just not getting a connection to dydns.

I finally got it working through some advice from other threads and a whole lot of trial and error. Here's the thread with my config file: http://www.eqemulator.org/forums/showthread.php?t=30723

SOAB!! Not being anywhere near C++ certed *i'm lucky enough to know how to even get Disk defrag to run, let alone how to play eq...*, payed UBER SUPER close attention to exactly what WAS TYPED into the pictures on the guide, and typed in what was typed in, not what i was being told to! I.E.: Instead of COD\PEQ_DB, it was CD\PEQ_DB!!! *Smashes head on keyboard* oogbar duuuum! oogbar smash dum...

Revision774-Bots.zip
is currently not on the Google code site,
if anyone could reupload it that would be awesome!

#4 (B) and (C) do not seem to work for me.

A) Then type: source peqdb_Rev859.sql; (actually used peqdb1589 as that is what downloaded through SVN for me)
This worked just fine for me.

B) Then type: source load_player.sql;
ERROR: Failed to open file 'xxxxxxxxxxxxxx.sql', error2
About 60 of these errors pop up.

C) Then type: source load_bots.sql;
ERROR: Failed to open file 'xxxxxxxxxxxx.sql', errror 2
7 errors of this type pop up.

The .sql files are in MYSQL\bin folder.
Load_bots.sql is 1KB in size.
Load_player.sql is 3KB in size.

I used the SVN update as instructed in the guide and it downloaded peqdb_1589.sql RAR file for me. I extracted and moved all the .sql files to the MYSQL\bin folder as instructed earlier in this thread.

I should not be getting these errors when I try to source the player and bot .sql
Anyone else run into this and maybe a workaround?

You can not type source peqdb_rev1589.sql at the cl and expect it to work as you are missing the file path.

Example of usage:

source D:/MYSQL/bin/peqdb_rev1589.sql

When sourcing in the load_bots.sql, load_player.sql and so on you have to open the files and add the file paths to each line so the program knows where to look for each file.

Thanks Black,

I have absolutely no experience using C++, MYSQL, Pearl, etc. I am a total noob at programming.

when I am entering each line 1 at a time I get a result -
Query OK, 0 rows affected <0.00 sec>

Is this the results I am looking for?
Thanks for the help

Yes, you could definitely see that once, twice, or not at all but that will depend on what it is that you are sourcing in.

You are entering each line one at a time? Each line meaning load_player.sql or the contents of load_player.sql? You seem to be on the right path but there might have been a slight misunderstanding.

So just to make sure we are on the same page. This is an example of what I meant before.

Contents of load_player.sql

Code:

source D:/Everquest/SVN/PEQ Database/player_tables/aa_timers.sql;

source D:/Everquest/SVN/PEQ Database/player_tables/account.sql;

source D:/Everquest/SVN/PEQ Database/player_tables/account_ip.sql;

source D:/Everquest/SVN/PEQ Database/player_tables/account_rewards.sql;

source D:/Everquest/SVN/PEQ Database/player_tables/adventure_details.sql;

source D:/Everquest/SVN/PEQ Database/player_tables/adventure_members.sql;

source D:/Everquest/SVN/PEQ Database/player_tables/adventure_stats.sql;

source D:/Everquest/SVN/PEQ Database/player_tables/Banned_IPs.sql;

source D:/Everquest/SVN/PEQ Database/player_tables/bugs.sql;

source D:/Everquest/SVN/PEQ Database/player_tables/buyer.sql;

source D:/Everquest/SVN/PEQ Database/player_tables/char_recipe_list.sql;

source D:/Everquest/SVN/PEQ Database/player_tables/character_.sql;

source D:/Everquest/SVN/PEQ Database/player_tables/character_activities.sql;

source D:/Everquest/SVN/PEQ Database/player_tables/character_enabledtasks.sql;

source D:/Everquest/SVN/PEQ Database/player_tables/character_tasks.sql;

source D:/Everquest/SVN/PEQ Database/player_tables/character_backup.sql;

source D:/Everquest/SVN/PEQ Database/player_tables/chatchannels.sql;

source D:/Everquest/SVN/PEQ Database/player_tables/commands.sql;

source D:/Everquest/SVN/PEQ Database/player_tables/completed_tasks.sql;

source D:/Everquest/SVN/PEQ Database/player_tables/db_version.sql;

source D:/Everquest/SVN/PEQ Database/player_tables/eventlog.sql;

source D:/Everquest/SVN/PEQ Database/player_tables/faction_values.sql;

source D:/Everquest/SVN/PEQ Database/player_tables/friends.sql;

source D:/Everquest/SVN/PEQ Database/player_tables/gm_ips.sql;

source D:/Everquest/SVN/PEQ Database/player_tables/group_id.sql;

source D:/Everquest/SVN/PEQ Database/player_tables/group_leaders.sql;

source D:/Everquest/SVN/PEQ Database/player_tables/guild_bank.sql;

source D:/Everquest/SVN/PEQ Database/player_tables/guild_members.sql;

source D:/Everquest/SVN/PEQ Database/player_tables/guild_ranks.sql;

source D:/Everquest/SVN/PEQ Database/player_tables/guild_relations.sql;

source D:/Everquest/SVN/PEQ Database/player_tables/guilds.sql;

source D:/Everquest/SVN/PEQ Database/player_tables/hackers.sql;

source D:/Everquest/SVN/PEQ Database/player_tables/inventory.sql;

source D:/Everquest/SVN/PEQ Database/player_tables/instance_lockout.sql;

source D:/Everquest/SVN/PEQ Database/player_tables/instance_lockout_player.sql;

source D:/Everquest/SVN/PEQ Database/player_tables/keyring.sql;

source D:/Everquest/SVN/PEQ Database/player_tables/launcher.sql;

source D:/Everquest/SVN/PEQ Database/player_tables/launcher_zones.sql;

source D:/Everquest/SVN/PEQ Database/player_tables/mail.sql;

source D:/Everquest/SVN/PEQ Database/player_tables/merchantlist_temp.sql;

source D:/Everquest/SVN/PEQ Database/player_tables/name_filter.sql;

source D:/Everquest/SVN/PEQ Database/player_tables/object_contents.sql;

source D:/Everquest/SVN/PEQ Database/player_tables/petitions.sql;

source D:/Everquest/SVN/PEQ Database/player_tables/player_corpses.sql;

source D:/Everquest/SVN/PEQ Database/player_tables/player_corpses_backup.sql;

source D:/Everquest/SVN/PEQ Database/player_tables/player_titlesets.sql;

source D:/Everquest/SVN/PEQ Database/player_tables/quest_globals.sql;

source D:/Everquest/SVN/PEQ Database/player_tables/raid_details.sql;

source D:/Everquest/SVN/PEQ Database/player_tables/raid_members.sql;

source D:/Everquest/SVN/PEQ Database/player_tables/reports.sql;

source D:/Everquest/SVN/PEQ Database/player_tables/respawn_times.sql;

source D:/Everquest/SVN/PEQ Database/player_tables/rule_sets.sql;

source D:/Everquest/SVN/PEQ Database/player_tables/rule_values.sql;

source D:/Everquest/SVN/PEQ Database/player_tables/sharedbank.sql;

source D:/Everquest/SVN/PEQ Database/player_tables/spell_globals.sql;

source D:/Everquest/SVN/PEQ Database/player_tables/timers.sql;

source D:/Everquest/SVN/PEQ Database/player_tables/trader.sql;

source D:/Everquest/SVN/PEQ Database/player_tables/trader_audit.sql;

source D:/Everquest/SVN/PEQ Database/player_tables/variables.sql;

source D:/Everquest/SVN/PEQ Database/player_tables/zone_flags.sql;

Your load_player.sql should look something like that and if it does then a simple sourcing of load_player.sql will source in all of those files.

OK, I've got everything compiled and installed.

Using minilogin on localhost only (127.0.0.1), so I have that IP address in all the correct spots.

I double click on my Serverstart.bat link and this error comes up with the c:\eqemu\eqlaunch.exe

[DEBUG] Starting log: logs/eqemu_debug_5744.log
[DEBUG] [LAUNCHER__INIT] Loading server configuration..
[DEBUG] [NET__WORLD] WorldConnection connect: Connecting to the server 127.0.0.1:9000 failed: TCPConnection::Connect(): connect() failed. Error 10061
[DEBUG] [LAUNCHER__ERROR] worldserver.Connect() FAILED! Will retry.
[DEBUG] [LAUNCHER__INIT] Starting main loop...

Just for giggles, I fire up my EQ game and login to only to find a blank server select screen.
I'm so close to playing on my own server I can taste it. What am I missing here that is causing me not to be able to connect my world sever?

Thanks for the help!
Knotthead

BIG Problems with this guide

When following this guide exactly this is what happens

1) Download and install Tortoise SVN∞.
After it's installed, navigate to your MySQL installation folder. In that directory, you should see a folder named bin - this is where you'll download the database to.

2) Right-click the folder and select SVN Checkout.
In the new window that pops up, where it says URL of Repository at the top, paste in:

http://projecteqdb.googlecode.com/svn/trunk
The line under that where it says Checkout directory: is the location of the folder you are downloading it to - keep an eye on that to make sure it's the correct folder.

Problems:
If you Install Mysql (Custom) and check C Include Files / Lib Files
you will recieve a warning that there are already files in the bin folder.

Also
When importing the database to the bin folder this way (currently rev1589) it creates the follow file path C:mysql/bin/projecteqdb/peqdatabase causing a failure at step 4a in the guide

A) Then type: source peqdb_Rev859.sql; (rev1589 in my case)
and press Enter.

I'm guessing since peqdb_rev1589.sql is not directly the bin folder and ends up in the peqdatabase folder ?

Could somebody PLEASE update this guide?

Hopefully somebody can update it with regard to correct file/folder pathing so it works. I guess I need guide for dummies. *sigh* since I can't even get past step 4A