PHPmyAdmin optimize error!! 1

[ThomasJSmart]

helphelphelp!

i tried to optimize one of my tables in phpmyadmin it produced an error and now mysql cant read the table at all anymore!!

what can i do???
thanks

I learned a bit yesterday, today i learned a lot, imagine what i'll learn tomorrow!

 

[ThomasJSmart]

this is the error msg phpmyadmin is displaying now:

Can't open file: 'content.MYD'. (errno: 144)


I learned a bit yesterday, today i learned a lot, imagine what i'll learn tomorrow!

 

[sleipnir214]

It's a problem with one of your database's tables.

You're going to have to issue "REPAIR TABLE tablename" (

http://www.mysql.com/doc/en/REPAIR_TABLE.html)

Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!!

 

[ThomasJSmart]

fieeuw! that worked,
domdom domdom domdom

thanks!

I learned a bit yesterday, today i learned a lot, imagine what i'll learn tomorrow!

 

[sleipnir214]

K9logic:
Just out of curiosity....

What is the setting on your PHP installation for "output_handler"?

I was having problems of that kind myself recently, thus the reason I was able to supply a fix so quickly. Running OSCommerce e-commerce websites, I would get that error every two or three days on one table or another.

I had "output_handler" set to ob_gz_handler. I removed that setting and I haven't had a problem with table corruption in two weeks (knock wood).


As a note, what I had previously done to keep the sites up was to run a Linux cron job every 15 minutes that ran "show table status". If the "Comment" column contained error information, my cron job automatically ran REPAIR TABLE for the table indicated.

Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!!