[TriLUG] mysql db messed up

[Jason Tower]

got a client with a mysql problem as described below.  if anyone thinks 
they can rectify the problem please contact me offline asap.

jason
------------------------------------------
Issue is... there are several tables that are reporting with 0 rows, but 
are the size of their regular table size with hundreds of thousands of 
rows.  in particular -     products, product_groups, product_categories 
are affected.

You can login to the db via phpMyAdmin here <snip>

As you can see, products says it has no rows, but is 6.8 MB in size.    
if you look at the file contents of  products.MYD - you can see that it 
has a ton of data in it, but somehow the index is corrupted or 
whatever...