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 
Return to the default flat view Create a new topic Submit Reply
table is crashed and should be repaired [message #44482] Mon, 23 June 2008 12:37 Go to previous message
tufan is currently offline  tufan   Turkey
Messages: 70
Registered: June 2002
Karma:
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
[Message index]
 
Read Message
Read Message
Previous Topic: Performance Problems MySql
Next Topic: MSSQL to MySQL
Goto Forum:
  

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

Current Time: Mon Oct 23 11:16:07 EDT 2017

Total time taken to generate the page: 0.00621 seconds