Database not all loaded?

[fiveohhh]

Anyone have any idea why a bunch of the items in my DB don't work, its says they don't exist. but I can see them when I open the db file up. Of course I'm new to this, so I could be opening the wrong file up. I'm opening the sql file named db. I downloaded an updated one, and it seems all the "newer items" aren't loading. do I need to do anything with the file besides copy it into the directory?
Thanks
Andy

[Shawn319]

Just having the file in the mysql/bin dir does nothing. the actual database is in mysql/data folder (in wierd files, dont mess with em). you have to source the db.sql file using mysql.exe for them to get put in. if you already have the item or another db.sql there you will get a TON of duplicate entry errors and it will take forever to finish.

[fiveohhh]

Sorry for my ignorance, but what can I do than to get the items? I know very little about DB's Thanks for the help and uick replies shawn, Its very helpful.

[Trumpcard]

copy the database file to the c:\mysql\bin directory

get a dos window..
then type

c:\mysql\bin\mysql -f eq < file


that will load the file into the eq database..

the -f should supress 100,000 annoying beeps..

[Shawn319]

The default DB.sql comes with the most complete item list so far. the problem with item DB addons in there not complete (with all of the unknowns and complete item structure). addon Db's were made with FQAdmin (AKA EQEmu Admin Tool) and was not very thorough when items or characters were made.

[fiveohhh]

copy the database file to the c:\mysql\bin directory

get a dos window..
then type

c:\mysql\bin\mysql -f eq < file


that will load the file into the eq database..

the -f should supress 100,000 annoying beeps..

I tried this and I just get the system cannot find the file specified. . . .

[Trumpcard]

Did you copy the file you wanted to load to the directory?

[fiveohhh]

I got it figured out misread your post. Thanks for the help and promptness:)