How I fixed "table is marked as crashed and should be repaired" in Myth .20 on Ubuntu Feisty

May 15, 2007 - 10:07am — george

Don't know what happened exactly, but I couldn't fast forward TV shows anymore. But this time the previous fix didn't work.

Went into PHPMyAdmin, went to the mythconverg.recordedseek table and was told that the table had crashed. I clicked on the SQL tab to run an SQL command on this table.

REPAIR TABLE recordedseek;

Then I had to run

mythcommflag --rebuild -f

on my recordings.

Now it works again.

george's blog

Comments

October 29, 2011 - 9:42am — Anonymous (not verified)

thank a lot! I come from

thank a lot! I come from VietNam

October 26, 2011 - 1:39am — G.N.R.S.U (not verified)

you helped me a lot, even

you helped me a lot, even saved my site, thanks!

Details:

1.select the error table (show "in use")

2.click and select the "Repair table" drop menu at the bottom

3. that is all

this issue often happens after the fixing of shared hosting overloading evet!

November 9, 2010 - 1:02pm — Mike (not verified)

Thank you

Thank you so very much! You really saved my day with your post. I only had to do the table repair not the second thing.
Thanks! Mike

October 29, 2010 - 12:44pm — Eplexx (not verified)

Thanks!

I found other things in google and yours was the only one that helped so thanks so much!

October 21, 2010 - 5:54am — Gurria (not verified)

Job well done

I got my Table crashed and your blog helped me fix. Thank you very much as i have too many clients online and i would have lost all of there data.

August 11, 2010 - 4:54am — Anonymous (not verified)

Great Help

Simple and Great Help

from : http://www.twitterons.com/Sunny

July 22, 2010 - 12:27pm — Anonymous (not verified)

Saved my blog!

Thanks for the tip, simply REPAIR in phpmyadmin worked for me.

March 1, 2010 - 11:07pm — Kumaraguru (not verified)

Table 'somthing' is marked as crashed and should be repaired

Hi,

I got the below error
Table '.\icmsms\contacts' is marked as crashed and should be repaired.

Ur conclusion is very usefull very thanks to helped fixed the above issue.

Thnks by
KumaraGuru V,

February 7, 2010 - 3:48pm — Anonymous (not verified)

deprecated.net

Navigation

Syndicate