EQEmulator Forums

EQEmulator Forums (https://www.eqemulator.org/forums/index.php)
-   Archive::General Support (https://www.eqemulator.org/forums/forumdisplay.php?f=616)
-   -   I'm having trouble setting up a database in MySQL (https://www.eqemulator.org/forums/showthread.php?t=9131)

VGDMuda 08-18-2003 08:06 AM

I'm having trouble setting up a database in MySQL
 
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/


All times are GMT -4. The time now is 11:17 AM.

Powered by vBulletin®, Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.