The indexes are probably corrupt, you will need to run 'myisamchk' on the
table.
- Original Message -
From: "Jason Hall" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, December 03, 2002 3:04 PM
Subject: Problem doing Select * from table
> I
I am using mysql 3.23.41
The tables are set to MyISAM.
Table "A" i having problem with has 1.4 million records.
When i perform a mysqldump it hangs on this table but dumps other tables.
Also when i do a select * from table it hangs. But if i do select count(*)
from table a get a result.
The fiel