For the Database install, I of course installed MySQL. Then per the guide:
Code:
Currently you must download the latest database from the following location (you will get redirected to a Google Drive folder):
?
1
http://peqtgc.com/releases
The filename will be something like:-
?
1
peqbeta_{Date_and_Time}.tar.gz
where {Date_and_Time} is actually the time it was generated e.g 2014-04-01-02:01
Next, go to the folder C:\EQ\SQL and unzip the file.
If double-clicking on peqbeta_{Date_and_Time}.tar.gz does not launch 7-zip or your preferred unzipper, you may need to launch 7-manually (possibly using 'Run as Administrator' and go into the settings/options and tell it to associate it with .gz files).
Once you have the file opened with 7-zip, select extract and extract it to C:\EQ\SQL. It may just unzip to a file called peqbeta_{Date_and_Time}.tar. You then have to unzip *that* file, and inside are the files you really want.
There will be approx 11 files, one of which will be Readme.txt. I would advise reading that text! It will be updated whenever the database is (unlike this guide), and may have information that override what you read here. Copied from the current Readme
Then I did the following steps:
Code:
c) Now it is time to create the database.
The following assumes you have used my tip to rename the files to something easier to type!
Launch a command prompt window and navigate to your C:\EQ\SQL folder by typing:
cd c:\EQ\SQL
Then enter mysql -uroot -ppassword where password is the password you chose when installing MySQL.
You should be presented with a mysql> prompt. If you do not, and it says it cannot find "mysql" please refer to (link) Adding MySql to your "Path"
Assuming you are now logged in, you can now create your database.
Type:
create database peq;
and press enter.
The following ensures any commands you use next will apply to this new database:-
Type:
use peq;
and press enter.
Note: Now that the database is created anytime you need to login to MySQL in the future, you can do it with a single line command:
mysql -uroot -pyourpassword peq
Type:
source peqbeta.sql;
and press enter.
This may take a while to complete, depending on how powerful your PC is.
When the mysql> prompt returns:
Type:
source player_tables.sql;
and press enter.
Finally, type
exit
and press enter to return to the command prompt.
That was the process I used