FUDforum
Fast Uncompromising Discussions. FUDforum will get your users talking.
Home » FUDforum » How To » How do I deal with a corrupt index?
Show: Today's Messages :: Polls :: Message Navigator
Switch to threaded view of this topic Create a new topic Submit Reply
How do I deal with a corrupt index? [message #23068] Thu, 03 March 2005 01:48 Go to next message
WilliamBurns is currently offline  WilliamBurns   United States
Messages: 123
Registered: March 2004
Location: San Jose, CA
Karma: 0
Senior Member
I have version 2.6.1 with mysql 3.23.58 at the moment, and when they went to repair the database, it reported that fud261_index.MYI is corrupt and cannot be repaired. I notice that it is also pushing 23 megabytes in size! I also notice that there are other fud261_index files: a .MYD file, and a .frm file. I tried renaming the corrupt index file to bad_fud261_index.MYI, and doing so did not seem to disrupt my forum. Why? Can I delete that file? What role do the index files play? I know that WITH the corrupt index, virtually all of my older posts were trash.

Report message to a moderator

Re: How do I deal with a corrupt index? [message #23069 is a reply to message #23068] Thu, 03 March 2005 03:10 Go to previous messageGo to next message
Ilia is currently offline  Ilia   Canada
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
In mysql each table is represented by a total of 3 files, all of which are needed. Removing those files may cause problems.

FUDforum Core Developer

Report message to a moderator

Re: How do I deal with a corrupt index? [message #23087 is a reply to message #23069] Thu, 03 March 2005 21:27 Go to previous messageGo to next message
WilliamBurns is currently offline  WilliamBurns   United States
Messages: 123
Registered: March 2004
Location: San Jose, CA
Karma: 0
Senior Member
Then is this the file that is rebuilt when rebuild index is done from the control panel?

Report message to a moderator

Re: How do I deal with a corrupt index? [message #23088 is a reply to message #23087] Thu, 03 March 2005 21:53 Go to previous message
Ilia is currently offline  Ilia   Canada
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
Rebuild index is for search database only...

FUDforum Core Developer

Report message to a moderator

  Switch to threaded view of this topic Create a new topic Submit Reply
Previous Topic: how to add user to a gorup? I have done it, but.........See attachment files
Next Topic: Usernames with special characters
Goto Forum:
  

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

Current Time: Fri Nov 22 13:51:44 GMT 2024

Total time taken to generate the page: 0.03677 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.1.3.
Copyright ©2001-2023 FUDforum Bulletin Board Software