select on table pausing indefinitely

[arm207]

hi,
when i try the following at the mysql command line...

select * from items;

nothing returns, it just hangs indefinitely. Does anyone know why this is? I have ran "unlock tables"


I have already logged into mysql, all its services are running, and I have selected the right database, but not sure why its not working.

 

[TonyGroves]

How big is the table? If it's enormous, then it could take a very long time.

Or maybe the table contains binary data that causes your terminal to freeze?

Otherwise, there might be some sort of corruption, either of the table (unlikely with those symptoms) or of the program. Have you tried restarting the server?