Log in

View Full Version : I'm having trouble setting up a database in MySQL


VGDMuda
08-18-2003, 08:06 AM
1) Download mySQL from www.mysql.com, install it and copy db.sql from the folder you extracted the EQemu zip to into the mySQL\bin directory (usually C:\mysql\bin).

2) In your mySQL/bin directory (usually C:\mysql\bin) run winmysqladmin.exe and it should ask you to enter a username and password. Choose a username and password that you can remember because you will need it later

3) After you have chosen a username and password go to the Database tab in mySQL and right click the area for Databases and click Create Database

4) Type in eq as the database name and click Create database.

5) Close winmysqladmin and run mysql.exe in your mySQL/bin directory.

6) Type "use eq" without the quotes and hit enter. It should say Database changed.

7) Type "source db.sql" without the quotes and hit enter. A lot of lines should pass by and that is normal. If you get an error at this point then you didn

08-18-2003, 08:11 AM
Not sure where these instructions are from, but i created my db from the mysql CLI, i.e.

cd \mysql\bin

mysql

mysql> create database eq ;

*EDIT*

mysql> use eq ;

* ENDEDIT*

and then source the db ...

yoru
08-18-2003, 03:30 PM
you can also go into "C:\mysql\data" and make a folder with the name u want for ur DB

VGDMuda
08-18-2003, 03:30 PM
It's part of the EQEmu Windows Installation stuff.

x-scythe
08-18-2003, 08:18 PM
open mysql and type

create database eq;

that will make your database

useless
08-19-2003, 10:42 AM
you have to open a dos prompt modify the db

a sorta good windows DB program for sql is "artronic art admin"
http://www.artronic.hr/