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
add to buddy list
ignore all messages by this user

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...


[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: Sun Aug 19 10:04:49 EDT 2018

Total time taken to generate the page: 0.00678 seconds