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 |
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 ... |
you can also go into "C:\mysql\data" and make a folder with the name u want for ur DB
|
It's part of the EQEmu Windows Installation stuff.
|
.
open mysql and type
create database eq; that will make your database |
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.