Cant Source Item DB
 

I dont have any problems sourcing Db.sql, but when i try to source any item DB it fails...
__________________________________________________
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 31 to server version: 4.0.17

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> use eq
Database changed
mysql> source dumpeditems.sql;
ERROR:
Failed to open file 'dumpeditems.sql', error: 2
mysql>
__________________________________________________

Ive tried a bunch of different DB's but i get that every time, except when i try MyraItems.sql, then its gives me a bunch of lines about how rows and colomns dont match (or something)

I know im probably doing something very dumb and should be hit with the noob stick :oops: , but after more than a week of searching the forums, ive yet to come across an answer.

Also, would this failure to load items cause my server to 1017 me?

What version of eqemu are you using? And what db's did you source into mysql? some db's are not compatible with others, and also some db's are not compatible with some versions of eqemu....

make sure dumpeditems.sql is in the same folder as mysql.exe - in other words, if you are running mysql from the /bin folder, move dumpeditems.sql into it first.

Myra's DB and MW BD come with items so you cant sourse in more.

as the the other error check Scorps post.

Im using 5.3DR2 and i must have come across an older version on Myra's DB, because it has two files, MyraDB.sql, and MyraItems.sql. but I'll check to see if i have the dumpeditems in the right folder.

yeah i have the dumpeditems file in bin with mysql, but i noticed something this time that i didnt before, the icon for the dumpeditems.sql is diferent from the one on DB.sql, it's using the icon it likes to use when it doesnt know wtf the file is (i forget what it's called ... im a little tired =P)


Atm i only have Myras DB sourced, so if anyone could point me to a recent version with the items included, or a DB and an Item db that will work together, that would be great.

I will bet $ you didnt unzip the file, and Winzip wont work for this ether i personaly use WinRAR, google for it to find out where to get it.

thanks ill try that now

worked just fine, thanks matt, not im just having some trouble getting my boot5zones to connect, so im off to look for those answers now :wink:

The MyraItems are things that are missing from the collected items in dumpeditems.sql. She included them because they are used as loot or by merchants. If you can't get it to source, it means the table has changed and she needs to fix it. Let her know if you still are having trouble.