New Server issues

[HnathBST]

The guys over at PEQ have recently switched from the SVN to a google drive with a daily dump. I don't think any of the guides have been updated to reflect this, so your DB is most likely out dated.

to source the new files like kingly said you simply put them in your C:\EQ\SQL folder, open a command prompt and navigate to that folder.

then type:

C:\EQ\SQL> mysql -u root -p peq
<it will ask your password, type it and press enter>
mysql> source drop_system.sql
<this will take a second>
mysql> source peqbeta_{date_time}.sql <this will change depending on when you d/l>
<this will take a minute, good time to get some coffee...>
mysql>source user_tables_{date_time}.sql <same date as above>
<this won't take as long>
mysql>source source_views.sql

Obvisiously ignoring my comments ^*

That SHOULD get you up and running with your DB, just let us know if you encounter any errors.

[warkid]

ok as far as im aware server is up and running could someone log in and check for me please (to see if outsiders can connect)?

server name is warville

[TylerBarnes]

Originally Posted by HnathBST

The guys over at PEQ have recently switched from the SVN to a google drive with a daily dump. I don't think any of the guides have been updated to reflect this, so your DB is most likely out dated.

to source the new files like kingly said you simply put them in your C:\EQ\SQL folder, open a command prompt and navigate to that folder.

then type:

C:\EQ\SQL> mysql -u root -p peq
<it will ask your password, type it and press enter>
mysql> source drop_system.sql
<this will take a second>
mysql> source peqbeta_{date_time}.sql <this will change depending on when you d/l>
<this will take a minute, good time to get some coffee...>
mysql>source user_tables_{date_time}.sql <same date as above>
<this won't take as long>
mysql>source source_views.sql

Obvisiously ignoring my comments ^*

That SHOULD get you up and running with your DB, just let us know if you encounter any errors.

I'm trying to follow these directions but I'm hitting a bit of a road block.
I downloaded the google drive stuff, put it in my SQL folder and then opened cmd.exe, navigated to the folder so it said C:\EQ\SQL>
I put the code in, enter my password and get the following error: ERROR 1049 <42000> Unknown database 'peq'
Not entirely sure why it's not working. I put the .tar.gz files in there and then extracted them but still preserved the original files so it had both the .tar.gz and the extracted files in the SQL folder.

[HnathBST]

Originally Posted by TylerBarnes

I'm trying to follow these directions but I'm hitting a bit of a road block.
I downloaded the google drive stuff, put it in my SQL folder and then opened cmd.exe, navigated to the folder so it said C:\EQ\SQL>
I put the code in, enter my password and get the following error: ERROR 1049 <42000> Unknown database 'peq'
Not entirely sure why it's not working. I put the .tar.gz files in there and then extracted them but still preserved the original files so it had both the .tar.gz and the extracted files in the SQL folder.

Depending on what directions you followed your database May not be named peq. You need to change the command 'MySQL -u root -p peq' to match the database you do have.