Hi,

> I have some tables in the ISAM format in the database.  The tables 
> have the data, but whenever I do a select * from table_name, it 
> returns an empty set for most of the tables.  Whenever I do a 
> count(*) query I get the total no of records.

try running isamchk (c:\mysql\bin\isamchk *.ISM) in the database
directory.


Rgds,
  Tfr

 --==< [EMAIL PROTECTED] >==< MySQL development team >==< Tallinn / Estonia >==--  

---------------------------------------------------------------------
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/           (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Reply via email to