FUDforum: Database discussions » table is crashed and should be repaired

Home » General » Database discussions » table is crashed and should be repaired (mysql bug?)

Show: Today's Messages :: Polls :: Message Navigator

table is crashed and should be repaired [message #44482]

Mon, 23 June 2008 16:37

tufan

Messages: 70
Registered: June 2002

Karma: 0

Member

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