I've got an unusual situation. We backup our MySQL databases every night. The backup is done by copying the folders containing the database files (MyISAM on a Windows 2000 server) to a temp folder. They are then zipped and FTP'd to a server at our offices. If I then unzip the database they is always one table that needs to be repaired. I've check the table on the live server using CHECK TABLE table_name and it comes up clean. I've even tried the extended CHECK TABLE and it also comes up clean. If I copy just that table from the live server to my local installation and run the CHECK TABLE table name EXTENDED I then get a size difference warning for the indexfile and the datafile as well as a error "Record at: 2874384 Can't find key for index: 6" and then another error that simply says Corrupt. The table is then marked as crashed. If I run REPAIR TABLE table_name EXTENDED I get a message stating that the number of rows changed from 217393 to 230912.
I hope I'm making sense. Any help would be appreciated.