My client reported the a case to me. He said one mysql table lost some of the data. The table structure is shown as follows: +-----------------------+---------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-----------------------+---------------+------+-----+---------+-------+ | uid | varchar(32) | | PRI | | | | createdate | datetime | YES | | NULL | | | lastmoddate | datetime | YES | | NULL | | | num_of_files | int(13) | YES | | NULL | | | createby | varchar(32) | YES | | NULL | | | field_107666797596432 | varchar(255) | YES | MUL | NULL | | | field_107666798773233 | varchar(255) | YES | MUL | NULL | | | field_107666808467434 | varchar(255) | YES | MUL | NULL | | | field_107666809745535 | decimal(13,5) | YES | MUL | NULL | | | field_107666813934636 | varchar(255) | YES | MUL | NULL | | | field_107666815016037 | varchar(255) | YES | MUL | NULL | | | field_107666815625938 | text | YES | | NULL | | +-----------------------+---------------+------+-----+---------+-------+ The fields "field_xxxxx" lost data in most of the records, but no data was lost on other fields. Do you think it is possible? I'm guessing that it is caused by the corrupted index file. Does it help if I repair the index file? Your suggestion is greatly appreciated as I need to suggest my client how to recover the data. --- Kelvin Leung IPOS Computer Systems Limited http://www.iposcsl.com/ Mobile: +852 9199-5852 Tel: +852 2329-0345 Fax: +852 2329-0343
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]