Databases

DannMann99 · #1 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 · #2 09-13-2002, 08:27 AM

did you also source in items.sql?

if not you need to

DannMann99 · #3 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 · #4 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 · #5 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 · #6 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 · #7 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 · #8 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 · #9 09-19-2002, 11:46 AM

Check the 3.6 database add-on... linked on the front page...