A issue of MySQL

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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



[Index of Archives]     [Current Fedora Users]     [Fedora Desktop]     [Fedora SELinux]     [Yosemite News]     [Yosemite Photos]     [KDE Users]     [Fedora Tools]     [Fedora Docs]

  Powered by Linux