MySQL Forums :: MyISAM :: Table marked as crashed and last (automatic?) repair failed


Advanced Search

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 8339 newbie Shai 02/23/2011 08:39AM
Re: Table marked as crashed and last (automatic?) repair failed 2878 Rick James 02/24/2011 03:50PM
Re: Table marked as crashed and last (automatic?) repair failed 2488 newbie Shai 02/24/2011 09:05PM
Re: Table marked as crashed and last (automatic?) repair failed 2254 Rick James 02/25/2011 07:50AM
Re: Table marked as crashed and last (automatic?) repair failed 2007 newbie Shai 02/25/2011 07:56PM
Re: Table marked as crashed and last (automatic?) repair failed 4198 Rick James 02/25/2011 08:43PM
Re: Table marked as crashed and last (automatic?) repair failed 1693 newbie Shai 03/02/2011 11:02AM
Re: Table marked as crashed and last (automatic?) repair failed 1350 Rick James 03/03/2011 11:13PM
Re: Table marked as crashed and last (automatic?) repair failed 1397 newbie Shai 03/04/2011 12:53AM
Re: Table marked as crashed and last (automatic?) repair failed 3911 Rick James 03/04/2011 08:21AM
Re: Table marked as crashed and last (automatic?) repair failed 1548 newbie Shai 03/04/2011 10:27AM
Re: Table marked as crashed and last (automatic?) repair failed 2104 Rick James 03/04/2011 08:29PM
Re: Table marked as crashed and last (automatic?) repair failed 1398 newbie Shai 03/04/2011 10:25PM
Re: Table marked as crashed and last (automatic?) repair failed 1688 Rick James 03/05/2011 03:55PM
Re: Table marked as crashed and last (automatic?) repair failed 1837 newbie Shai 03/06/2011 06:30PM


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.