FUDforum
Fast Uncompromising Discussions. FUDforum will get your users talking.

Home » General » Database discussions » table is crashed and should be repaired (mysql bug?)
Show: Today's Messages :: Unread Messages :: Show Polls :: Message Navigator
| Subscribe to topic | Bookmark topic 
Switch to threaded view of this topic Create a new topic Submit Reply
table is crashed and should be repaired [message #44482] Mon, 23 June 2008 12:37 Go to next message
tufan is currently offline  tufan   Turkey
Messages: 70
Registered: June 2002
Karma: 0
Member
add to buddy list
ignore all messages by this user
Hi,

Recently I guess my hosting company made a change and fudforum stopped working. Upon investigating, FUDForum_non_browsable_directory/errors/sql_errors containted a message like:

Table '... fud2_ses' is marked as crashed and should be repaired.

Googling it showed a table repair was required, however, upon repairing table from the cpanel interface gave the message

'table is already up to date'.

Using the mysql command line gave the same result, so no repair was possible. Digging google a little more I found a solution (accidentaly), but that may require you an ssh access:

mysql -u user_name -p fud

mysql> repair table fud2_ses use_frm;

and now it works. 'use_frm' option to repair table did the work. Couldn't find it in this forum either, so I thought it might be helpful to post...


cya,
tufan


http://sfx-images.mozilla.org/affiliates/Buttons/firefox2/firefox-spread-btn-1.png
Re: table is crashed and should be repaired [message #158015 is a reply to message #44482] Mon, 19 January 2009 05:25 Go to previous message
naudefj is currently offline  naudefj   South Africa
Messages: 3631
Registered: December 2004
Karma: 17
Senior Member
Administrator
Core Developer
add to buddy list
ignore all messages by this user
Great tip. Thanks for sharing.
Quick Reply
Formatting Tools:   
  Switch to threaded view of this topic Create a new topic
Previous Topic: Performance Problems MySql
Next Topic: MSSQL to MySQL
Goto Forum:
  

-=] Back to Top [=-
[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Dec 12 09:13:50 EST 2017

Total time taken to generate the page: 0.00767 seconds