Hey All,

I'm trying to restore functionality to a table, but not having much luck. Basically, after running a CHECK TABLE I found some issues. The associated table files (.frm, .MYD, .MYI) were all backed up. Issued a REPAIR TABLE to fix the table. After running CHECK TABLE it looks like all the issues were gone. However, the associated table files were replaced with the backups (no, mysqlhotcopy was not used - bad, I know). The replaced files contained the information needed. Unfortunately, everytime I run a count query i get 0 records. I ran FLUSH TABLE, but that wasn't working either. Any ideas???

Many thanks...

Which version of MySQL are you using?
What OS the server runs on?
Have you tried an extended check?

Hi bstjean,

Thanks for the reply (again). We are running MySQL 3.23 on Red Hat Linux 7.3. I'm not sure I'm familiar with an Extend Check. What does it do? I suppose I'll read the MySQL documentation on that.

The table is repaired, but I can't get the records to show up. I'm thinking I just need to "reload" the table or something. But how? We may try to restart MySQL...restarting seems to do the trick sometimes. Thought there'd be a way to restart (refresh or reload) a table. I thought that is what FLUSH TABLE did.

Anyway, thanks again for the response and continued help. It is much appreciated.

Best Regards,
DrSmartman

Plenty of ways/tricks to do the job... Check these links...

http://www.mysql.com/doc/en/Repair.html
http://www.mysql.com/doc/en/REPAIR_TABLE.html
http://www.mysql.com/doc/en/Corrupte...AM_tables.html
http://www.mysql.com/doc/en/Using_mysqlcheck.html
http://www.mysql.com/doc/en/Table_maintenance.html

Hope this helps!