Good afternoon, Our /var partition crashed last night, and as a result, several MySQL tables were corrupted. After cleaning up the partition, we repaired those tables via mysqlcheck.
When we started using the webapp built on top of those tables today, we noticed that rows were missing from some of the corrupted tables. Those tables appear to be tables where mysqlcheck reported that "Size of datafile is: x Should be: y". For example: Table Op Msg_type Msg_text cs.carescoutHH check error Size of datafile is: 4640132 Should be: 4640484 cs.carescoutHH check error Corrupt As I interpret that output, it suggests that (before repairs) the file /path/to/mysql/cs/carescoutHH.MYD was only 4,640,132 bytes when it should have been 4,640,484 bytes. I have assumed that if mysqlcheck repairs a table then by definition all of the data is still present in that table. Or, stated differently, that mysqlcheck would report that it was unable to repair a table if it rebuilt the structure of the table but lost data during the process. But perhaps I have assumed that incorrectly. Is it possible that mysqlcheck repaired the table, but that rows are still missing from the table? That, when faced with inadequate data to rebuild a row, it (silently) discards that row? Thanks for your help. -Chris -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
