i am having trouble. i have made it to this part. where it all says 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.
(OPTIONAL) If you plan on using Bots, also do the following:
Type:
source load_bots.sql;
and press enter.
(OPTIONAL) If you plan on using mercenaries, follow this seperate guide located here.
when i get to use peq; i hit enter, it says database changed. and still shows mysql> so then i try typing mysql -uroot -root peq which root was my password. and it does nothing. then if i try to go to the next step and type source peqbeta.sql; it gives me a 1064 error. how can i fix this? i really hjave no experience with command prompt or mysql. i tryed using a normal command prompt it wouldnt change over to the other directory, i tryed using the mysql command line program. and it got me to the 1064 error. any help would be great
|