MySQL Forums
Forum List  »  MyISAM

Table marked as crashed and last (automatic?) repair failed
Posted by: newbie Shai
Date: February 23, 2011 08:39AM

Dear All,
I have table crashed and checked that the the .MYD size is around 12G and MYI is 17G. So I run this command myisamchk -r /var/lib/mysql/fms/tripDataOri.MYI
- recovering (with sort) MyISAM-table '/var/lib/mysql/fms/tripDataOri.MYI'
Data records: 0
- Fixing index 1
- Fixing index 2
- Fixing index 3
- Fixing index 4
- Fixing index 5
- Fixing index 6
- Fixing index 7
- Fixing index 8
129531000

It keep running and I saw a new .TMD file is created. So am I doing the right thing to recover is it? How long will it take? Thank you.

Options: ReplyQuote


Subject
Views
Written By
Posted
Table marked as crashed and last (automatic?) repair failed
8549
February 23, 2011 08:39AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.