View Full Version : Loss of Items ...
bbaker1980
04-21-2004, 07:27 AM
I'm not positive if this is the place I'm supposed to be posting this, but here goes.
I upgraded to 5.6 and when I login, there are items missing, items in the wrong slot, etc. I think I saw somewhere that the dumpeditem SQL file is a fix for this (?), but I'm unsure how to use those files, their purpose, and where to put them. (I'm still very new - poke fun if needed though :lol: )
How do I fix this problem?
Monrezz
04-21-2004, 10:53 AM
Download the dumped items sql, then unzip it and source it into your database the same way your sourced MW.
mysql -u root -p -b eq (Enter root as password)
source dumpeditems.sql;
exit
RexChaos
04-21-2004, 01:45 PM
If I sourced this pre-5.6 do I need to do it again? I haven't noticed any problems myself, but one person reported losing items on the server. Also if I source the dumpeditems.sql it'll overwrite my customized gear right?
Monrezz
04-22-2004, 03:47 AM
Yes, it'll overwrite unless you manually re-source your custom content.
The dumpeditems.sql is updated automatically every 7 hours I believe, so it will always be up to date with latest live information (and structure).
RexChaos
04-22-2004, 05:14 AM
Any chance of JUST having one with the structure? If it was a blank structure with no data, would that keep things up to date without monkeying up my existing database? Just curious :)
Also, if I were to download that instead of trying to get a blank one, I could just wipe out all the datamyself and then source it into my database. If that would work...
And here I was thinking this would be fun. ;)
Monrezz
04-22-2004, 05:39 AM
SHOW CREATE TABLE items;
Gives you the structure of the items table. If you want to change your current table you'll have to run an ALTER table command using the txt file for reference - see the Mysql website for documentation if you are unsure on how to do that.
RexChaos
04-22-2004, 05:48 AM
Thanks Mon. :) So much work...but oh so rewarding when someone logs on the server and goes /ooc "why cant i use ooc? what's custom on this? can i b gm plz!??!"
My taxes need to get to me quick...I need a vacation...
vBulletin® v3.8.11, Copyright ©2000-2025, vBulletin Solutions Inc.