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:

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

http://sfx-images.mozilla.org/affiliates/Buttons/firefox2/firefox-spread-btn-1.png

Report message to a moderator

[Message index]

		table is crashed and should be repaired By: tufan on Mon, 23 June 2008 16:37
		Re: table is crashed and should be repaired By: naudefj on Mon, 19 January 2009 10:25

Previous Topic:	Performance Problems MySql
Next Topic:	MSSQL to MySQL

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon May 06 01:35:47 GMT 2024

Total time taken to generate the page: 0.05435 seconds