Problem doing Select * from table

2002-12-03 Thread Jason Hall
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

Re: Problem doing Select * from table

2002-12-03 Thread Bhavin Vyas
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 am using mysql 3.23.41 The tables are set