MySQL Forums
Forum List  »  InnoDB

Advanced Search
New Topic

Re: What could cause a table to 'crash' and should be repaired?
Posted by: Aftab Khan
Date: November 20, 2012 06:15AM

>I don't restart mysql at all, doing a "REPAIR TABLE bhost_cache;" normally does the trick

Are you sure the table in subject is Innodb? Because REPAIR TABLE is not intend to work with Innodb.

http://dev.mysql.com/doc/refman/5.1/en/repair-table.html


Please provide MySQL error log output.



Edited 1 time(s). Last edit at 11/20/2012 06:16AM by Aftab Khan.

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
What could cause a table to 'crash' and should be repaired?
1911
Simon Goodman
November 14, 2012 12:43AM
Re: What could cause a table to 'crash' and should be repaired?
1035
Rick James
November 14, 2012 09:39PM
Re: What could cause a table to 'crash' and should be repaired?
1087
Simon Goodman
November 15, 2012 02:49AM
Re: What could cause a table to 'crash' and should be repaired?
940
Aftab Khan
November 20, 2012 06:15AM


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.