Thread: CMAKE Error
View Single Post
  #41  
Old 04-19-2014, 01:09 AM
Hockyplr
Sarnak
 
Join Date: Aug 2013
Posts: 43
Default

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
Reply With Quote