Step: 12

[Tarnien]

Ok Thanks to Rogean! He got me all the way to Step 11 before we had to stop n stuff...

12. Create EQ Database

Make sure you followed the instructions in the cvs section for adding mysql binaries to the %path%.

Open a DOS prompt
Win98/95/ME - start->run->command
Win2k/XP/2k3 - start->run->cmd

Type in the following:
c:
cd "\eqemu\cvs\eqemu\eqemu release"
mysql -u root mysql

Inside of mysql, type these commands:
create database eq;
grant all privileges on *.* to test@localhost identified by 'test' with grant option;
quit

You should see the following as output from above:
Code:
C:\EqEmu\cvs\eqemu\EQEMu Release>mysql -u root mysql
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 22 to server version: 3.23.57-nt

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> create database eq;
Query OK, 1 row affected (0.00 sec)

mysql> grant all privileges on eq.* to test@localhost identified by 'test'
with grant option;
Query OK, 0 rows affected (0.00 sec)

mysql> quit
Bye

C:\EqEmu\cvs\eqemu\EQEMu Release>



Back in the DOS prompt, type this command:
mysql -u test -p eq

You should see a password prompt - enter in your password ('test' in this sample). You should see the following:
Code:
C:\EqEmu\cvs\eqemu\EQEMu Release>mysql -u test -p eq
Enter password: ****
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 24 to server version: 3.23.57-nt

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql>


Time to load a blank database. Type in the following command:
source db.sql;

You will see the following for a LONG time:
Code:
mysql> source db.sql;
Query OK, 0 rows affected (0.03 sec)

Query OK, 0 rows affected (0.02 sec)

Query OK, 0 rows affected (0.00 sec)
(... repeat about fifteen thousand times)


You now have an EQ database with NO ITEMS/MOBS/ETC. See http://www.eqemulator.net/forums/viewtopic.php?t=6176 for info on populating your database.

0.5.0-DR3 - While 0.5.0 is still under development, you will need to run these temporary scripts to create tables that hold our work in progress:
source doors_objects.sql;
source pets.sql;

Close out the DOS window. You are done with it.

I can't get passed

Open a DOS prompt
Win98/95/ME - start->run->command
Win2k/XP/2k3 - start->run->cmd

Type in the following:
c:
cd "\eqemu\cvs\eqemu\eqemu release"
mysql -u root mysql

for some reason when i type that stuff in in the cmd window nothing happens at all.. no error messages or anything :/