A issue of MySQL
Shi-Ming Chen
shiming.cv90g at nctu.edu.tw
Fri Apr 2 05:53:20 UTC 2004
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
More information about the fedora-list
mailing list