A issue of MySQL

[Shi-Ming Chen]

Shi-Ming Chen wrote:
> Recently I upgraded my box from Redhat 8.0 to Fedora Core 1. There is a 
> MySQL server in this box, and I backuped my_table_name.[frm, MYI, MYD] 
> to a  safe place. After installing FC1, I copied these backuped files to 
> /var/lib/mysql/my_db_name/, and it worked. But I lost some records!
> 
> When I use the sql command: SHOW TABLE STATUS FROM my_db_name, it shows 
> that the there is *3558* rows in my_table_name, but when I use: SELECT * 
> FROM my_table_name, it only shows *1816* rows!
> 
> How can I recover my lost rows?
> Thanks.
> 
> -- 
> Shi-Ming Chen
> 
> 
And then I put my_table_name.[frm, MYI, MYD] to a MySQL (ver.4) server 
in Windows, and it shows ALL rows! My disaster is over, but I am curious 
that why the MySQL in FC1 can't read all rows? (Original MySQL version 
in RH8 and FC1 is 3)

--
Shi-Ming Chen