Otdfbt

Multi tool use

What does the "ep" capability mean?

Why was Germany not as successful as other Europeans in establishing overseas colonies?

Unexpected email from Yorkshire Bank

How to stop co-workers from teasing me because I know Russian?

Why is it that the natural deduction method can't test for invalidity?

Stop and Take a Breath!

Why don't other Westeros houses use wildfire?

The Defining Moment

How come there are so many candidates for the 2020 Democratic party presidential nomination?

How do I use proper grammar in the negation of "have not" for the following sentence translation?

Pass By Reference VS Pass by Value

How did Captain America manage to do this?

Fizzy, soft, pop and still drinks

Mac Pro install disk keeps ejecting itself

Why do Computer Science majors learn Calculus?

What route did the Hindenburg take when traveling from Germany to the U.S.?

Who is the Umpire in this picture?

How would one muzzle a full grown polar bear in the 13th century?

What language was spoken in East Asia before Proto-Turkic?

What does KSP mean?

Realistic Necromancy?

Critique of timeline aesthetic

Examples of subgroups where it's nontrivial to show closure under multiplication?

Shrinkwrap tetris shapes without scaling or diagonal shapes

MySQL MyISAM corrupt table, how to restore?

How to speed up MySQL table repairing process?Restoring a slave MySQL database from raw backups of master gives InnoDB tablespace errorsMysql-Server-5.1 upgrade problemMySQL: Corrupt ARCHIVE table. Help, Please?multiple mysql processes caused DB table to crashMySql crash: Incorrect key file for tableMySQL Table not repairingMariaDB galera cluster fail when dumping or optimizing databaseMySQL Server won't start - [ERROR] COLLATIONFatal error: Can't open and lock privilege tables: Table storage engine for 'user' doesn't have this option

.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty height:90px;width:728px;box-sizing:border-box;

0

I have a MySQL MyISAM table that's corrupt. It first showed up in my mysql log as:

[ERROR] /usr/sbin/mysqld: Table './mydb/mytable' is marked as crashed 
and last (automatic?) repair failed

I then ran CHECK TABLE on it, and after churning away for well over an hour, I got this:

+--------------+-------+----------+----------------------------------------------------------+
| Table | Op | Msg_type | Msg_text |
+--------------+-------+----------+----------------------------------------------------------+
| mydb.mytable | check | warning | Table is marked as crashed and last repair failed |
| mydb.mytable | check | warning | 5 clients are using or haven't closed the table properly |
| mydb.mytable | check | warning | Size of indexfile is: 215237632 Should be: 4096 |
| mydb.mytable | check | error | Record-count is not ok; is 4212263 Should be: 0 |
| mydb.mytable | check | warning | Found 48 deleted space. Should be 0 |
| mydb.mytable | check | warning | Found 1 deleted blocks Should be: 0 |
| mydb.mytable | check | warning | Found 8362327 key parts. Should be: 0 |
| mydb.mytable | check | error | Corrupt |
+--------------+-------+----------+----------------------------------------------------------+

Does all this indicate that this table is too far gone to be salvageable? Or should REPAIR TABLE still work? Or are there other options to fix this table without replacing the data? I'm asking first because this table is pretty huge for my system and I have a feeling that it's going to take a loooong time to know if repair is going to work.

mysql corruption myisam

share|improve this question

asked Feb 26 '14 at 3:06

curtisdfcurtisdf

1911213

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  The output above suggests that MySQL believes the table "Should be" empty. I hope you had backups.
  
  – Michael Hampton♦
  Feb 26 '14 at 3:47
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Actually, REPAIR TABLE worked nicely, and quicker than I thought.
  
  – curtisdf
  Feb 26 '14 at 4:34
  

  
  
  
  

add a comment | 

0

I have a MySQL MyISAM table that's corrupt. It first showed up in my mysql log as:

[ERROR] /usr/sbin/mysqld: Table './mydb/mytable' is marked as crashed 
and last (automatic?) repair failed

I then ran CHECK TABLE on it, and after churning away for well over an hour, I got this:

+--------------+-------+----------+----------------------------------------------------------+
| Table | Op | Msg_type | Msg_text |
+--------------+-------+----------+----------------------------------------------------------+
| mydb.mytable | check | warning | Table is marked as crashed and last repair failed |
| mydb.mytable | check | warning | 5 clients are using or haven't closed the table properly |
| mydb.mytable | check | warning | Size of indexfile is: 215237632 Should be: 4096 |
| mydb.mytable | check | error | Record-count is not ok; is 4212263 Should be: 0 |
| mydb.mytable | check | warning | Found 48 deleted space. Should be 0 |
| mydb.mytable | check | warning | Found 1 deleted blocks Should be: 0 |
| mydb.mytable | check | warning | Found 8362327 key parts. Should be: 0 |
| mydb.mytable | check | error | Corrupt |
+--------------+-------+----------+----------------------------------------------------------+

Does all this indicate that this table is too far gone to be salvageable? Or should REPAIR TABLE still work? Or are there other options to fix this table without replacing the data? I'm asking first because this table is pretty huge for my system and I have a feeling that it's going to take a loooong time to know if repair is going to work.

mysql corruption myisam

share|improve this question

asked Feb 26 '14 at 3:06

curtisdfcurtisdf

1911213

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  The output above suggests that MySQL believes the table "Should be" empty. I hope you had backups.
  
  – Michael Hampton♦
  Feb 26 '14 at 3:47
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Actually, REPAIR TABLE worked nicely, and quicker than I thought.
  
  – curtisdf
  Feb 26 '14 at 4:34
  

  
  
  
  

add a comment | 

I have a MySQL MyISAM table that's corrupt. It first showed up in my mysql log as:

[ERROR] /usr/sbin/mysqld: Table './mydb/mytable' is marked as crashed 
and last (automatic?) repair failed

I then ran CHECK TABLE on it, and after churning away for well over an hour, I got this:

+--------------+-------+----------+----------------------------------------------------------+
| Table | Op | Msg_type | Msg_text |
+--------------+-------+----------+----------------------------------------------------------+
| mydb.mytable | check | warning | Table is marked as crashed and last repair failed |
| mydb.mytable | check | warning | 5 clients are using or haven't closed the table properly |
| mydb.mytable | check | warning | Size of indexfile is: 215237632 Should be: 4096 |
| mydb.mytable | check | error | Record-count is not ok; is 4212263 Should be: 0 |
| mydb.mytable | check | warning | Found 48 deleted space. Should be 0 |
| mydb.mytable | check | warning | Found 1 deleted blocks Should be: 0 |
| mydb.mytable | check | warning | Found 8362327 key parts. Should be: 0 |
| mydb.mytable | check | error | Corrupt |
+--------------+-------+----------+----------------------------------------------------------+

Does all this indicate that this table is too far gone to be salvageable? Or should REPAIR TABLE still work? Or are there other options to fix this table without replacing the data? I'm asking first because this table is pretty huge for my system and I have a feeling that it's going to take a loooong time to know if repair is going to work.

mysql corruption myisam

share|improve this question

asked Feb 26 '14 at 3:06

curtisdfcurtisdf

1911213

[ERROR] /usr/sbin/mysqld: Table './mydb/mytable' is marked as crashed 
and last (automatic?) repair failed

+--------------+-------+----------+----------------------------------------------------------+
| Table | Op | Msg_type | Msg_text |
+--------------+-------+----------+----------------------------------------------------------+
| mydb.mytable | check | warning | Table is marked as crashed and last repair failed |
| mydb.mytable | check | warning | 5 clients are using or haven't closed the table properly |
| mydb.mytable | check | warning | Size of indexfile is: 215237632 Should be: 4096 |
| mydb.mytable | check | error | Record-count is not ok; is 4212263 Should be: 0 |
| mydb.mytable | check | warning | Found 48 deleted space. Should be 0 |
| mydb.mytable | check | warning | Found 1 deleted blocks Should be: 0 |
| mydb.mytable | check | warning | Found 8362327 key parts. Should be: 0 |
| mydb.mytable | check | error | Corrupt |
+--------------+-------+----------+----------------------------------------------------------+

share|improve this question

asked Feb 26 '14 at 3:06

curtisdfcurtisdf

1911213

share|improve this question

asked Feb 26 '14 at 3:06

curtisdfcurtisdf

1911213

asked Feb 26 '14 at 3:06

curtisdfcurtisdf

1911213

asked Feb 26 '14 at 3:06

curtisdfcurtisdf

1911213

1 Answer
1

active

oldest

votes

0

I proceeded with REPAIR TABLE anyway, figuring that if the table was already too far gone, I had nothing else to lose. Thankfully, it worked! The table is back up and functioning normally.

share|improve this answer

answered Feb 26 '14 at 4:35

curtisdfcurtisdf

1911213

add a comment | 

Your Answer

StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "2"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);

else
createEditor();

);

function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);



);

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);

Sign up using Google

Sign up using Facebook

Sign up using Email and Password

Post as a guest

Name

Email

Required, but never shown

StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fserverfault.com%2fquestions%2f578318%2fmysql-myisam-corrupt-table-how-to-restore%23new-answer', 'question_page');

);

Post as a guest

Name

Email

Required, but never shown

0

I proceeded with REPAIR TABLE anyway, figuring that if the table was already too far gone, I had nothing else to lose. Thankfully, it worked! The table is back up and functioning normally.

share|improve this answer

answered Feb 26 '14 at 4:35

curtisdfcurtisdf

1911213

add a comment | 

0

I proceeded with REPAIR TABLE anyway, figuring that if the table was already too far gone, I had nothing else to lose. Thankfully, it worked! The table is back up and functioning normally.

share|improve this answer

answered Feb 26 '14 at 4:35

curtisdfcurtisdf

1911213

add a comment | 

I proceeded with REPAIR TABLE anyway, figuring that if the table was already too far gone, I had nothing else to lose. Thankfully, it worked! The table is back up and functioning normally.

share|improve this answer

answered Feb 26 '14 at 4:35

curtisdfcurtisdf

1911213

share|improve this answer

answered Feb 26 '14 at 4:35

curtisdfcurtisdf

1911213

answered Feb 26 '14 at 4:35

curtisdfcurtisdf

1911213

answered Feb 26 '14 at 4:35

curtisdfcurtisdf

1911213