twebman

I can't export the contents of the table, nor can I read the table or edit, it, etc. The error I get is: #1016 - Can't open file: 'Rankings_dump.InnoDB'. (errno: 1)

I have two tables in my DB that are marked "in use" and cannot be accessed. I have tried myself to get them cleared up, to no avail. If there's anyone here who can help, I will gladly pay via PayPal.

Thanks, veridicus. I should have mentioned that I have restarted mysql. Is there something I can do within PHPmyAdmin? What would I do to unlock the tables? Sorry, I have tried some UNLOCK commands, but get bad syntax errors.

I have two tables in my DB that are marked as "in use" and I cannot query them, open them via PHP My Admin, or anything. I understand from some research that is means the tables are locked or stuck open. What can I do to resolve this issue?

Thanks, ToonMariner... Will try that method. I've done a few INNER JOIN queries and I'll see if I can get this one to work. THANKS!

I have a "This Day in Baseball History" database. The fields are: id, content, day, month, year The content field holds the descrip of what happened that day. The other fields are self-explanatory. I want to add a field that will tag each event to a certain team, so I can display the results to have a "this Day in Tigers History" page and "Yankees" and so on... Some events might be fit more than one team. How can I create a field that has an identifier for both teams? For example, if it's an event I want to have on both the Tigers and Yankees pages, can I put "DET" and "NYY" in one field separated by a space? How do I retrieve it? I've tried LIKE and CONTAINS and neither works. Is there a way to do it that I'm overlooking? Any help is appreciated.