Greetings, Had a problem with a mysql table. About a dozen columns, one of them being a text column. I had earlier had a fulltext index on this text column but removed it. Later on, with 104 records in the table, whenever anyone tried to update info in the text column portion of a row, mysql would throw an error like: "Incorrect key file for table: 'tablename'. Try to repair it..." Running myisamchk shows that the checksum was incorrect. Running myisamchk -r on the file shows good things, recovering the file with 104 records. Unfortunately, it had wiped 80 of them. Any ideas what causes this sort of error, and why myisamchk wiped the records during the repair? Many thanks. Mike Robinson IT / Developer - Toronto Star TV Phone: 416.945.8786 Fax: 416.869.4566 Pager: 416.329.3904 Email: [EMAIL PROTECTED]
