I hope this helps..... What table format are you using? When did data loss happen eg. after power loss?
Yes do use the MySQL tools to repair the tables. Also you could run the bin logs back in to MySQL so all sql changes are run on the table again. The other thing to think about is locking tables can copying them to back up. This way you just have to lock db and copy back! Simon ----- Original Message ----- From: "Kelvin Leung" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, February 18, 2004 3:23 AM Subject: Data lost > 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] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
