MySQL Forums
Forum List  »  Newbie

Problems accessing a table within an otherwise-working db
Posted by: Natasha Hurley-Walker
Date: July 21, 2005 05:04AM

Hello,

I've been using a simple table within a database for a year or so now without any problems. It has an index called 'id' (int(11)) which increments every time a new record is added, 10 columns of various types and probably around 3 million records. Recently this table has stopped responding.

I can:
describe the table
see the table using 'show tables'
perform all normal operations on all other tables in the database

I can't:
update the table
check the table (I think - it has been running for an hour with no response)
select any data from the table, even something simple like max(id)

Does anyone know what the problem could be? Is there a simple solution, such as restarting the computer? ;) I don't want to lose any data, of course :)

Thanks!
Tash

Options: ReplyQuote


Subject
Written By
Posted
Problems accessing a table within an otherwise-working db
July 21, 2005 05:04AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.