Log in

View Full Version : Databases


DannMann99
09-13-2002, 07:35 AM
Do they come with eqemu? i just got my server up and running everything working but i dont have any items. Go figure.

devn00b
09-13-2002, 08:27 AM
did you also source in items.sql?

if not you need to

DannMann99
09-13-2002, 10:42 AM
Im kinda a newwb at this. I dont quite know what you mean by source in.
I have the items.sql file but i dont know how to load it up (i downloaded it from the site)
plz help/.

devn00b
09-13-2002, 11:09 AM
copy items.sql to your mysql\bin directory (where mysql.com is located on yer hard drive)

Drop to a dos window (Start menu -> run -> type Command)

then goto your mysql directory

(usualy would look like this cd\mysql\bin)

type mysql -f eq < items.sql. (in the dos window)

that is the easyest way i know.

Shawn319
09-14-2002, 10:35 AM
or copy items.sql to the c:\mysql\bin folder, then open up mysql.exe in the same folder, type use eq; and hit enter, then type source items.sql; and hit enter

xarbok
09-19-2002, 11:19 AM
Where do you find the items.sql file? I dont have it anywhere in my eqemu folder and mysql

Sidilian
09-19-2002, 11:32 AM
In the 3.6 release it is called hq-items-3.6.sql... same file.

*Thanks Lurker*

source this and then the *magelo*sql file in or just use the install.bat like the README says...

*grin*

xarbok
09-19-2002, 11:41 AM
I couldn't find items.sql or hq-items-3.6.sql at all, did a full search through my computer. I even checked the eqemu zip, it doesnt have it either.

Sidilian
09-19-2002, 11:46 AM
Check the 3.6 database add-on... linked on the front page...