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

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

Written By
Table marked as crashed and last (automatic?) repair failed
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.