** NEW UPDATED ITEM DB **

[Raahb]

I tried that MySQL Front but I still can't really figure out what to do. I also tried deleting the item.sql from the 3.13 addon and replacing it with the items.sql from this thread and using the install.bat that came with 3.13. No luck so far.

[inferno222]

I think this will work, it's what I did, and I *think* it worked, and have had no problems after doing it.

Delete items table in mySql Front
Move items.sql to mysql/bin folder
Go to MYSQL/bin folder, open mysql.exe

type 'use eq'
then type 'source items.sql'

let it scroll, and when it's done, close mysql.exe

then you're done..of course I have no idea if this worked or not, since I know jack sh!t about mysql, but I seem to be able to find more PoP items, and of course everything works fine.

can any of you mysql genius' let us know if that even works?

[Trumpcard]

That works fine..


Folks, I don't want to get on a rant, but if you are going to run a server, you REALLY need to learn SQL a bit and some basic mysql syntax. Not having any idea how the database works is going to frustrate you to no end.

There are TONS of mysql tutorials on the web, use some of them and get an understanding of how to manage the database, believe me, you're lives will be much better.


The EASY way to do this.

1) Copy the new items.sql to the C:\mysql\bin directory
2) Open a DOS command window (if you dont know how to do this, there are instructions out there)
3) cd c:\mysql\bin
4) type 'mysql' This opens the mysql interface.
5) use eq;
6) drop table items;
7) source items.sql;


Thats it, and it doesnt require any external tools. Here are a few mysql commands to get you started, but if you are going to run your own server, for goodness sake learn a bit about the tools we use to manage it. We arent a basic mysql forum! I don't mind a few mysql questions here or there, but these forums shouldnt be filled with 100 questions on 'how do i use mysql'. There is TONS out there on managing a mysql database, use google and find a few, print them out, read them in the toilet.

Basic Commands:

show databases; //shows all databases installed on your mysql instance
use <database>; //sets that as the active database
show tables; //shows all currently defined tables in the database you selected
describe tablename; //gives you a description of the format of the table
select * from <tablename>; //displays all records in the indicated tablename


If you're going to run an eqemu server, learn to use the tools.. Anyone that says 'I want to run a server, but I don't want to have to learn all this new computer stuff ' really should stick to playing on someone elses server.

Please keep in mind I'm not picking on anyone, I'm just telling you, going to run your own server? LEARN MYSQL ! It's not hard at all

[bobmook]

an even better gui is mysqlyog available at this address http://www.webyog.com/sqlyog/download2.php

In order to add the items table using mysqlyog you'd drop the table then just browse to the items.sql file from the tools- run batch file and run it.
In mysqlfront I think there's a query analyzer built in so you'd run the items.sql from there.
These are just ways of doing what Trumpcard explained though a gui and it has been my experience that at times the mysql gui's don't run sql scripts correctly, so caveat emptor.