Missing parts of the install guide?

Steel · #1 03-01-2010, 04:25 AM

First the link to the perl and mysql part is a dead link.

But thats not my prob atm.Ive followed it to the letter and im to the point of sourceing the database.

Create database peq;worked
use peq;worked
source peqdb_rev1265.sql;error 2

Yes its unzipped and in the folder that the guide says to put it.
Whats missing from the guide?

**joligario** · #2 03-01-2010, 06:59 AM

Did you launch your mysql from the same directory your .sql file was located?

Steel · #3 03-01-2010, 05:57 PM

Install guide never meantioned anything like that.Dont really understand what you are talking about actually.So,no i havent.Dont know how either.Ty though

**trevius** · #4 03-02-2010, 12:22 AM

Try adding in the full path to those files you are trying to source. If they are stored in "C:\peqdb\", then you would need to enter something like this instead:

Code:

source C:\peqdb\peqdb_rev1265.sql;

Otherwise, you can always do it by opening the command prompt (start>run then type "cmd"and click ok). Then, go to the folder where your .sql files are by doing something like:

Code:

c:
cd peqdb

Then start mysql by doing this:

Code:

mysql -u root -p

You can reply "root" in that command with whatever username you created for your database. Then, log in with your password when prompted.

Then, continue the rest of the steps such as:

Code:

use peq

And so on as instructed. Since you started in the folder with your SQL files, it shouldn't have a problem finding them anymore.

Steel · #5 03-02-2010, 09:26 PM

none of that worked.
BUT i did get it to source rev1265 by moving it all to c: then typing mysql>source c:\peqdb_rev1265.sql;

Then i went to source the load_player.
Typed mysql>source c:\load_player.sql;
But all i get now is a list of error 2's matching the content listed inside the load_player file,and a list of beeps to go with that error.And before the beep/error list it says unknown command '\l'.Trying it without the ; at the end i get the same list of errors but no unknown command.

Tryed 3 diff installs of mysql with same results.

This is getting really out there.Wish the guide was complete really.

Zandig · #6 03-03-2010, 11:14 AM

Move the database files and directories into the 'MySQL/bin' directory.

Then from the command line change the directory to the 'MySQL/bin' directory:
(assuming you installed MySQL on the c: drive)
cd\
cd MySQL/bin

then run your MySQL commands to connect to the database and source.

Run this from the command line:

Code:

mysql -u root peq -p
(note: enter you password when prompted)

\u peq

\. drop_system.sql
will drop the database for you.

\. peqdb_Rev1265.sql
will load the database for you.

NOTE: Be sure to backup your characters if you are going to
\. drop_player.sql
\. load_player.sql

Steel · #7 03-04-2010, 05:00 PM

That worked.Sure do appreciate it.Got a new issue now but im searching it more before i post it but all i can find is way old posts year or 2 +.

Btw could someone ask vale to add those querys to the guide for future peeps?Ty

**trevius** · #8 03-04-2010, 06:37 PM

He cannot edit his post, but anyone is able to edit the wiki page he made for it that is linked at the top of his post. You just have to make a wiki account, which takes no time at all. Being able to let anyone update the wiki page is the point of having a wiki :P